 | Level: Introductory Dwaine Snow (dsnow@us.ibm.com), Senior DB2 Product Manager, IBM Toronto Lab
27 Jun 2006 Learn how to create DB2 databases, and about the mechanisms available for storing your tables, indexes, and
data within the database. This tutorial focuses on partitioning, compression, and XML, which are all important
performance and application development concepts that you need to know to store and access data quickly and efficiently. This is the second in a series of seven DB2 DBA certification prep tutorials that you can use to help prepare for the DB2 V9 for Linux, UNIX, and Windows Database Administration (Exam 731). Objectives - Create databases
- Use schemas
- Determine the various table space states
- Create and manipulate DB2 objects
- Create an SMS table space and understand its characteristics
- Understand the characteristics of, and use, DB2's automatic storage
- Implement table partitioning and MDC on your tables
- Use table compression
- Use XML
Prerequisites
To take the DB2 9 DBA exam, you must have already passed the DB2 9 Fundamentals exam 730.
If it's available, we recommend that you take the DB2 Fundamentals tutorial series before starting this series. If the Fundamentals series is not yet available, it's fine to do this DBA series first.
Although not all materials discussed in the Fundamentals tutorial series are required to understand the concepts described in this tutorial, you should at least have a basic knowledge of:
- DB2 products
- DB2 tools
- DB2 instances
- Databases
- Database objects
System requirements
You do not need a copy of DB2 to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM DB2 9 to work along with this tutorial.
Duration
Less than one hour
Formats html, pdf
| | | |
