This chapter will prepare you to create, manage, and alter physical database objects. You will learn the proper use of compression, along with partitioning capabilities. We will discuss the implementation of Db2 BLU, along with the pureScale enhancements in the v11.1 release. We will also review the SQL enhancements in the Db2 v11.1 release. After the completion of this chapter, you will be able to demonstrate the ability to perform the following tasks:
- Creating, altering, and managing Db2 objects
- Implementing BLU acceleration
- Describing Db2 pureScale enhancements
- Properly use compression
- Describing SQL compatibility
- Describing partitioning capabilities
Certification test:
- Number of questions: 13
- Percentage of the exam: 22%