Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

DDLOUT data sets

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.

Related topic

REORG-PLUS-DD-statements

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.

 

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