Before you start
If you are preparing to take the DB2 10.1 for Linux, UNIX, and Windows DBA certification exam (exam 611), you've come to the right place — a study hall of sorts. This series of eight DB2 certification preparation tutorials covers the major concepts you'll need to know for the test.
This tutorial discusses the creation of DB2 databases, as well as the various methods used for placing and storing objects within a database. The focus is on partitioning, compression, and XML, which are all important performance and application development concepts you need to know to store and access data quickly and efficiently. This is the second in a series of eight tutorials that you can use to help you prepare for the DB2 10.1 for Linux, UNIX, and Windows DBA certification exam (exam 611). The material here primarily covers the objectives in Section 2 of the exam ("Physical design").
After completing this tutorial, you should be able to:
- Demonstrate the ability to create a database and manipulate various DB2 objects.
- Know how to convert existing database to automatic storage database.
- Use the Admin_move_table feature.
- Demonstrate knowledge of partitioning capabilities.
- Demonstrate knowledge of XML data objects.
- Demonstrate knowledge of compression.
- Demonstrate knowledge of new table features.
- Knowledge of Multi-temperature data feature.
To take the DB2 10.1 DBA exam 611, you must have already passed the DB2 10.1 Fundamentals exam 610. We recommend that you study the DB2 10.1 fundamentals certification exam 610 series before starting this series.
To help you understand some of the material presented here, you should be familiar with the following terms:
- Object — Anything in a database that can be created or manipulated with SQL (e.g., tables, views, indices, packages).
- Table — A logical structure that is used to present data as a collection of unordered rows with a fixed number of columns. Each column contains a set of values, each value of the same data type (or a subtype of the column's data type); the definitions of the columns make up the table structure, and the rows contain the actual table data.
- Record — The storage representation of a row in a table.
- Field — The storage representation of a column in a table.
- Value — A specific data item that can be found at each intersection of a row and column in a database table.
- Structured Query Language (SQL) — A standardized language used to define objects and manipulate data in a relational database. (For more about SQL, see the fourth tutorial in this series.)
- DB2 optimizer — A component of the SQL precompiler that chooses an access plan for a Data Manipulation Language (DML) SQL statement by modeling the execution cost of several alternative access plans and choosing the one with the minimal estimated cost.
You do not need a copy of DB2 to complete this tutorial. However, you will get more out of it if you download the free trial version of IBM DB2 10.1 to work along with this tutorial.