 | Level: Intermediate Paul Read (paul_read@uk.ibm.com), Product Introduction Manager, IBM
Richard Hewitt (richard_hewitt@uk.ibm.com), IT Specialist, DB2 LUW Consultant, IBM UK
14 Dec 2006 This tutorial is designed to demonstrate the functionality of range partitioning in DB2® 9. Participants will receive the hands-on experience of using the features of Range Partitioning with DB2 tables. Table partitioning is a data organization scheme in which table data is divided across multiple storage objects called data partitions, or ranges, according to values in one or more table columns. Each data partition is stored separately. These storage objects can be in different table spaces, in the same table space, or a combination of both.
Objectives
The objective of this session is to explore the features and benefits of DB2 9 range partitioning in the following areas: creating range partitioned tables, roll-in and roll-out of partitions, partitioned table management, and index management and placement.
Prerequisites
This tutorial is written for DB2 specialists whose skills and experience are at a beginning to intermediate level. You should have a general familiarity with using the DB2 command line, DB2 administration tools, and a working knowledge of SQL.
System requirements
-
DB2 9 Data Server
- Microsoft® Windows® 2000 or later, and an account with administrator privileges, or Linux® (Validated edition) with root access.
- Make sure the Java Runtime Environment is 1.4.2 or later on your system.
- Refer to the DB2 9 system requirements page to ensure that your hardware meets the requirements.
Formats html, pdf
Tutorial overview
The exercises in this tutorial enable you to work with the table partitioning feature and demonstrate the roll-in and roll-out of table data, easier administration of large tables, flexible index placement, and improved performance for business intelligence style queries.
They have been developed to demonstrate one or more tasks found within each of the areas.
Table partitioning offers the following:
- Easy roll-in and roll-out of table data
- Easier administration of large tables
- Flexible index placement
- Improved performance for business intelligence style queries
| | | |
