We have a 72 partition large (dssize 8g) tablespace that contains LOB data(3Meg blobs).
In reading the DB2 Version 9.1 for z/OS Admin Guide one of the restrictions for adding a partition is:
"You cannot add a new partition to an existing partitioned table space if the table has LOB columns."
I'm assuming this means we also cannot Rotate Partitions - can anyone confirm if rotating parts with LOBs is possible or not?
If I can't add and/or Rotate partitions, our next option is to rename the current table to something like CURRENTNAME_HIST, create a new partitioned table called CURRENTNAME_NEW, and then create a view called CURRENTNAME that joins the _HIST and _NEW tables together.
We don't see any restrictions that don't allow a Rename on a LOB table... anyone know of any?
If anyone knows of any issues/concerns with the planned approach to rename & use views or knows of a better approach - we are open to suggestions.
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L