CA RC/MigratorCA Endevor SCM InterfaceDB2 AdministrationCA RC Compare for DB2 for z/OSCA RC Extract for DB2 for z/OSCA RC/QueryCA RC Secure for DB2 for z/OSCA RC Update for DB2 for z/OSCA Database Analyzer for DB2 for z/OSCA Fast Unload for DB2 for z/OSCA Fast Check for DB2 for z/OSCA Fast Index for DB2 for z/OSCA Fast Load for DB2 for z/OSCA Rapid Reorg for DB2 for z/OS
When objects are created in DB2 the specified defaults are used as the initial attribute values when created, templated, or altered. If no definitions exist when an object is created, defaults are typically aligned with the values that are used by DB2.
In an RC/Migrator for DB2 for z/OS (RCM) COMPARE strategy comparing DDL for a new tablespace that has PRIQTY/SECQTY = -1 , the PRIQTY/SECQTY are not generated in the resulting DDL.
Release: Component: RCM
This is working as designed. If you do not specify PRIQTY or specify PRIQTY -1, DB2 uses a default value for the primary space allocation. Unlike RC/Query, RCM will try to condense the DDL and in this case there is no need for PRIQTY. If you need to change PRIQTY/SECQTY to a specific value you should use Global Changes.
When objects with the generated DDL (with no PRIQTY/SECQTY) are executed in DB2, later examination of the catalog records for the objects in SYSTABLEPART and SYSINDEXPART will show the value of PRIQTY and SECQTY are set to -1 by DB2.
If you need to change PRIQTY/SECQTY that is allocated you should use Global Changes during the compare strategy to set the value in the generated analysis output.
In this example any source value (also -1) is changed to 12 and DDL contains PRIQTY 12 and SECQTY 12 for tablespaces and you can do this for indexes also with IXPQ and IXSQ.
Example input DDL with -1 in primary and secondary quantity: CREATE TABLESPACE TBSROLE IN DBCORP USING STOGROUP SYSDEFLT PRIQTY -1 SECQTY -1 ERASE NO FREEPAGE 0 PCTFREE 5 BUFFERPOOL BP0 LOCKSIZE ANY CLOSE NO SEGSIZE 64 LOCKMAX 0 CCSID EBCDIC ;
Generated DDL without Global changes being used.
CREATE TABLESPACE TBSROLE IN DBCORP USING STOGROUP SYSDEFLT <------no PRIQTY or SECQTY generated ! ERASE NO FREEPAGE 0 PCTFREE 5 BUFFERPOOL BP0 LOCKSIZE ANY CLOSE NO SEGSIZE 64 LOCKMAX 0 CCSID EBCDIC ;