In one of our DB2 databases (on z/OS) we are rotating the first logical partition of a partitioned table to hold new data. The table space’s partitions were already having Compressed dictionaries (COMPRESS YES was specified in table space definition and sample data was loaded to built the dictionary for each partition).
To implement partition rotation, we are doing the following:
1. Delete the data from the first logical partition.
2. Rotate the first logical partition to the last logical partition, using ALTER TABLE statement.
Now my questions are:
1. Once the partition is rotated, do I have to build the compression dictionary for the last logical partition?
2. How does DB2 DELETE the data from the first logical partition during the Partition rotation? Does it drop and recreate the underlying DB2 data set for the first logical partition or does it delete the data (as a normal delete statement, and the deletes are logged)?
3. After partition rotation, I know that I have to use the PHYSICAL PARTITION Number to confine a DB2 Utility execution to a particular partition. However can any one confirm this?
Your inputs are valuable to plan our partition rotation.
Thanks in advance!!
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to $1600 off when you both come to the conference!
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L