Setting the online reorg options

Use the Online Reorg Utility Options panel to specify the options for reorganizing table spaces.

To set the JCL options for online reorg options

1. Use the following menu selections to display the Online Reorg Utility Options panel:

   From this menu	Select this item and press Enter
   ALTER or BMC AMI Change Manager for Db2 Main Menu	Options
   ALTER or Change Manager Main Options Menu	JCLGEN options
   JCL Generation Main Menu	Utility Options
   Utility Options	Online Reorg Options

    ----------------------- ONLINE REORG UTILITY OPTIONS -----------------------
    COMMAND ===>
   
     BMCREORG XBMID: XBMB
   
     REORG MAPPING TABLE:
       J234.JFLTBMAB
   
     REORG MAPPING DATABASE:
      XXXX
   
     NOTE:  The mapping table full length cannot exceed 72 characters
     NOTE:  The mapping database full length cannot exceed 8 characters

2. In the BMCREORG XBMID field, specify the 

   EXTENDED BUFFER MANAGER

    (

   XBM

   ) subsystem (SSID) that the REORG PLUS utility accesses.REORG PLUS uses XBM or its XBM SNAPSHOT UPGRADE FEATURE (SUF) technology to create a snapshot of the data sets to be reorganized. ALTER and BMC AMI Change Manager for Db2 use this value when reorganizing a table space by using an online reorganization (SHRLEVEL CHANGE).

   The value of the SSID can be from 1 to 8 characters long.

3. In the REORG MAPPING TABLE field, specify the name of the mapping table that the IBM REORG utility uses to map the row IDs (RIDs) in the source table to the RIDs in the target table.

   Warning

   Note

   (Db2 Version 11 and later) If you want to use the system default values of IBM REORG, (not define a mapping table or a mapping database) for online reorg (SHRLEVEL CHANGE), perform the following steps:

   1. On the Online Reorg Utility Options panel, do not specify a mapping database name.
   2. On the Online Reorg Utility Options panel, do not specify a mapping table name.
   3. On the ALTER and CHANGE MANAGER Analysis Options panel, set the Require Mapping Table for IBM field to N. See Setting-the-Analysis-options.

   The name can be from 1 to 72 characters long, and can contain the &ZUSER or &USERID symbolic variable.

   Warning

   Note

   On the ALTER and CHANGE MANAGER Analysis Options panel, you can indicate whether to include the name of the mapping table in the syntax for the IBM REORG utility.

   The REORG PLUS utility invokes the IBM DSNUTILB utility control program to enable certain features. If you have specified to use the REORG PLUS utility, you still need to specify mapping table information. For information about the features for which REORG PLUS invokes DSNUTILB, see the REORG PLUS for DB2 documentation.

   If you are specifying a mapping table for Db2 Version 11 and later, ensure that the length of the LRSN column is appropriate for the tablespace that is being reorganized.

4. (Db2 Version 11 and later) In the REORG MAPPING DATABASE field, specify the name of the default database that the IBM REORG utilty uses when it implicitly creates a mapping table.

   Warning

   Note

   On the ALTER and Change Manager Analysis Options panel, the Require Mapping Table for IBM field must be set to N. See Setting-the-Analysis-options.

   The full length of the mapping database can be from 1 to 8 characters long.

   You cannot define both the mapping database and the mapping table.

5. Press END to save your changes and return to the ALTER or BMC AMI Change Manager for Db2 Main Menu.