RC/Migrator PRIQTY SECQTY values missing

book

Article ID: 109989

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

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. 

Environment

Release:
Component: RCM

Resolution

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.

TSPQ _ PRIMARY QUANTITY * CALC(12)
TSSQ _ SECONDARY QUANTITY * CALC(12)

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
    ;


 

Additional Information

Global Change Services

Define Defaults for DB2 Object Attributes