Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

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 BMC AMI Reorg for Db2 13.1.

DD statements for BMC AMI Reorg

This topic provides information about the following BMC AMI Reorg DD statements:

SYSIN

This is the only DD statement required for use with BMC AMI Reorg. Specify product statements as follows:

//SYSIN DD *
     <statement>
     <statement>
     <statement>

RRGPARMS

This DD statement is required only to override the BMC AMI Reorg parameters specified during installation. You can specify RRGPARMS in a data set or in the JCL. 

Example
//RRGPARMS DD DISP=SHR,DSN=NGT.REORG.PARMS

or

//RRGPARMS DD *


RRGPARMX

This DD statement is required only to override the BMC AMI Reorg parameters for index processing specified during installation. You can specify RRGPARMX in a data set or in the JCL. 

Example
//RRGPARMX DD DISP=SHR,DSN=NGT.REORG.PARMS

or

//RRGPARMX DD *

UTLPARMS

This DD statement is required only to override BMC AMI Utilities global parameters specified during installation. You can specify UTLPARMS in a data set or in the JCL. 

Example
//UTLPARMS DD DISP=SHR,DSN=NGT.UTIL.PARMS

or

//UTLPARMS DD *

For more information, see Invoking-DSNUTILB.

RUNSTATS

(optional) This DD contains RUNSTATS reports. You can send this DD statement to an output file or to a SYSOUT output class. 

Example
//RUNSTATS DD DISP=SHR,DSN=NGT.RUNSTATS.REPORT

or

//RUNSTATS DD SYSOUT=*

For more information, see RUNSTATS.

SYSDISC

(optional) This DD enables you to archive discarded rows. 

Example
//SYSDISC DD DISP=(MOD,CATLG,DELETE),DSN=NGT.REORG.DISCARDS

The following considerations apply to SYSDISC:

  • To have BMC AMI Reorg dynamically allocate your discard file, specify DISCARDDN on the REORG command instead of specifying a SYSDISC DD statement.
  • If you specify both DISCARDDN and a SYSDISC DD statement, BMC AMI Reorg uses the DISCARDDN option instead of the DD statement.
  • If you are reorganizing a partitioned table space and you specify a SYSDISC DD statement in your JCL, BMC makes the following recommendations:
    • Specify DISP=(MOD,CATLG,DELETE). If you specify DISP=(NEW,CATLG,DELETE), SYSDISC will contain only the last partition's discarded rows.
    • Do not specify the RLSE subparameter for the SPACE parameter. This specification can cause a B37 abend when the data set is reopened for a partition's discards.

SYSPUNCH

(optional) This DD will contain a generated LOAD statement if rows are discarded during the reorganization and a FORMAT other than UNLOAD is specified (see DISCARDDN for AMI Reorg).

Example
//SYSPUNCH DD DISP=SHR,DSN=NGT.REORG.LOADSTMT


To have BMC AMI Reorg dynamically allocate the data set that will contain the generated LOAD statement, use an OUTPUT SYSPUNCH command to specify the data set name.  You must place the OUTPUT command (for BMC AMI Reorg) before the REORG statement. 

NGTAUTO

If you are using automation control points with your job, you can specify an NGTAUTO DD statement to override the default data set (specified during configuration or with the NGTAUTO1 or NGTAUTO2 parameter).

This statement should reference a partitioned data set that contains the BMC AMI Utilities automation control points.

Example
//NGTAUTO DD DISP=SHR,DSN=NGT.AUTOMATN.CTRL.PTS

For more information, see:

DDLIN

(optional) Include this DD in your JCL if you want to supply ALTER statements to update limit keys during your reorganization. BMC AMI Reorg rebalances your partitions based on these limit key changes and updates the limit keys in the DBD and Db2 catalog.

DDLIN is the default DD name for this data set. Alternatively, you can specify the DDLIN option (DDLIN-for-REORG-TABLESPACE) on your REORG command to supply a different DD name. 

For more information, see Rebalancing-partitions.

PARTSDDL

(optional) Include this DD in your JCL if you are rebalancing partitions. BMC AMI Reorg writes DDL to this data set that you can use to create the table space, tables, and indexes that you are reorganizing.

If you do not include this DD statement, BMC AMI Reorg issues a warning message but continues the reorganization and rebalances your partitions.

For more information, see Rebalancing-partitions and REPBLDAL.

REPBLDAL

(optional) Include this DD in your JCL if you are rebalancing partitions. BMC AMI Reorg writes ALTER statements to this DD for the object that you are reorganizing. These ALTER statements reflect the new keys following the rebalance operation.

If you do not include this DD statement, BMC AMI Reorg issues a warning message but continues the reorganization and rebalances your partitions.

For more information, see Rebalancing-partitions and PARTSDDL.

Related topics

BMC AMI Reorg parameters
BMC-AMI-Reorg-parameters-RRGPARMS-DD-RRGPARMX-DD

Pending limit key changes

Free space considerations

Command-and-syntax-reference

 

 

 

 

 

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