Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

DDLOUT data sets in REORG PLUS

The DDLOUT output data set contains the SQL ALTER statements for the limit-key updates that REORG PLUS makes during partition rebalancing.

REORG PLUS opens this optional data set only if it updates limit keys.

REORG PLUS opens the data set with the following attributes, regardless of any attributes that you specify:

  • LRECL=80
  • RECFM=FB
  • BLKSIZE=27920

REORG PLUS writes the DDL to columns 1 through 72, and writes EBCDIC blanks to columns 73 through 80. This format enables you to use this data set as DDLIN input in a subsequent REORG PLUS job.

You can produce only a report of the ALTER statements, without completing the reorganization, by completing the following steps:

  1. Include a DDLOUT DD statement in your JCL.
  2. Specify the following options on your REORG command:
    • SHRLEVEL CHANGE
    • REBALANCE
    • MAXRO DEFER

  3. When REORG PLUS issues message BMC50829I, indicating that the LOGAPPLY phase is starting, cancel the job.

    REORG PLUS backs out the reorganization, but leaves the information in the DDLOUT data set intact.

Related topic

REORG-PLUS-DD-statements

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*