CA RC/Compare converting a segmented tablespace to a UTS PBG, the original SEGSIZE is not honored.

Document ID : KB000006556
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When altering a segmented tables pace to a Partition-by-Growth (PBG) Universal
table space (UTS), CA RC/Compare for DB2 for z/OS (RCC) generates the
following DDL to make the change:

ALTER TABLESPACE dbname.tsname MAXPARTITIONS 1

A reorg utility is also generated to materialize the table space to PBG UTS.
Once the reorg has been executed the SEGSIZE of the altered object is now 32.

 

Cause:

As per the DB2 SQL Reference Guide, if MAXPARTITIONS is specified on a simple or segmented
table space, the table space is converted to a partition-by-growth universal table space that can
grow to a maximum number of integer partitions. The SEGSIZE is set to the default of 32
if the SEGSIZE prior to conversion is less than 32.

Resolution:

If it is a requirement to retain the original SEGSIZE, then currently you must avoid
using DB2 Alter. This can be done by performing a DROP/CREATE in the Analysis.
To do this set the following Analysis Option to 'Y':

DROP & RE-CREATE ==> Y

Additional Information:

Please refer to the alteration considerations section in the CA RC/Migrator documentation.