Migrating STOGROUP-defined table space and index partitions

To set the secondary quantity to a factor of a primary quantity by importing DML

1. In an ISPF editor, type one of the DML statements shown in the following DML, and provide the information that is unique to your site.

   Warning

   Important

   PRIQTY and SECQTY are expressed in 4K pages.

           MIGRATE TABLEPART
   SET SQTY = PQTY / 2 - set secondary quantity to half of primary quantity
   WHERE
          DBNAME   LIKE     'CRJ%'
      AND (PQTY    BETWEEN  4 AND 60)   -- pages, not K
      AND STORTYPE =        'I'         -- STOGROUP-defined
   ;
   
   MIGRATE TABLEPART
   SET SQTY = 2 * PQTY   -- set secondary quantity to twice primary quantity
   WHERE
         DBNAME   LIKE 'CRJ%'
      AND PQTY     <    4     -- pages, not K
      AND STORTYPE =    'I'   -- STOGROUP-defined
   ;
   
   MIGRATE INDEXPART
   JOIN SYSIBM.SYSINDEXES IX
   SET SQTY = PQTY * 1.5 -- set secondary quantity to 1 1/2 of primary
                         -- quantity
   WHERE
         STORTYPE  =    'I'
      AND IXNAME    =    IX.NAME
      AND IXCREATOR =    IX.CREATOR
      AND IX.DBNAME LIKE 'CRJ%'
   ;
2. Import the DML file.