DB2 for LUW

Table Partitioning Automation (D13) 

May 06, 2011 03:00 PM

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.

pdf file
NA11D13.pdf   4.97 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.