Articles & Content


Table Partitioning Automation (D13)

Topic: 2011 NA

Subtopic: DB2 for LUW

DATE: 2011-5-6 (08:00 AM - 09:00 AM)
SPEAKERS: Randy Goering (DST Systems Inc )

DB2 LUW 9.5 & 9.7 gives us the ability to have partitioned tables but how do you automate the creation of new partitions or the attachment and detachment of partitions. We have developed SQL Stored Procedure that can be used to automatically detach multiple partitions and add them to other tables or to drop them. You may have a table with historical data for many years and partitioned by month and you want to detach all of the monthly partitions for a given year and you want to save these monthly partitions not as individual tables but in a yearly table. This can be done using SQL Stored Procedures.

EXP. LEVEL: Intermediate


Overview of Business Problem. Discussion of why we needed to automate the attachment and detachment of table partition and why we moved the monthly partitions into another partitioned table.

Will discuss how to create a partition table and how to add partitions.

Will discuss how to attach and detach partitions using the DB2 alter table command.

Will discuss how we automated the attach/detach process with SQL Procedures.

Will discuss how we setup the SQL Procedures to be executed by the application group and how the DBA does not have to be involved in the attach/detachment process.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.