Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

BMC AMI Reorg parameters (RRGPARMS DD RRGPARMX DD)

The following topics describe the BMC AMI Reorg parameters. You can include these parameters in the RRGPARMS DD or RRGPARMX DD in the configuration job stream and override them in the BMC AMI Utilities job stream.

BMC AMI Reorg AUX YES-specific parameters are included with the BMC AMI Reorg parameters. 

Statistics gathered and reported in BMC AMI Reorg are controlled by parameters in the STTPARMS DD. For details of those options, see STTPARMS DD.

BMC AMI Reorg AUX YES uses default values from the system configuration unless you override them in your jobstream. 

RRGPARMS DD

Reorg parameters that apply to the table space processing

RRGPARMX DD

Reorg parameters that apply to the index processing whether the table space is being reorganized or just the index.

Related topics

Global-parameters-UTLPARMS
BMC AMI Unload parameters (ULDPARMS DD)
BMC AMI Check parameters (CIXPARMS DD)
BMC AMI Load parameters (LODPARMS DD)
BMC AMI Stats parameters (STTPARMS DD)

BMC-AMI-Reorg-command-and-syntax-reference

You can specify the following parameters in the RRGPARMX DD statement when using BMC AMI Reorg. These apply when reorganizing an index.

Parameter

Use and value

Determines the data set PQTY and SEQTY value and controls the value that BMC AMI Utilities use for a new index space allocation

Provides the name of an existing database for BMC AMI Reorg to use as a work database for internal processing

Specifies the number of pages between empty pages in the index space

Specifies the percentage of free space in each data page of the index space

Activates statistics gathering and updates the Db2 catalog

Indicates whether to skip statistics for the index when running the BMC AMI Reorg Index utility or BMC AMI Utilities Manager executing a REORG INDEX statement

Specifies a list of volumes to use in the IDCAMS DEFINE statement for each new Db2 index space data set

You can specify the following parameters in the RRGPARMS DD statement when using BMC AMI Reorg.

Parameter

Use and value

Specifies the Reorg Advisor table creator name

Specifies the Db2 subsystem on which the Reorg Advisor table resides

Specifies the Reorg Advisor table name

Determines the data set PQTY and SEQTY value and controls the value that BMC AMI Utilities use for a new table space allocation

Specifies BMC AMI Reorg to check for a concurrently running IBM REORG utility

Ensures that the uniqueness of a copy data set name is validated prior to the BMC AMI Reorg job execution

Enables you to specify during runtime, whether to produce copies during a reorganization and set objects to copy-pending status

Provides the name of an existing database for BMC AMI Reorg to use as a work database for internal processing

Specifies whether to honor the Db2 subsystem parameter by default

Specifies the number of pages between empty pages in the table space

Specifies whether to ignore indexes specified with DEFINE NO and to process other tables in the underlying table space

Allows BMC AMI Reorg to invalidate the dynamic cache

Specifies whether to include LOB auxiliary table spaces when processing a wildcard list of table spaces

Specifies what to do if BMC AMI Reorg encounters an integrity error while processing a table space that has an associated LOB

Specifies what to do if BMC AMI Reorg finds a row in the base table space whose corresponding row in the LOB auxiliary table space is missing

Specifies what to do if BMC AMI Reorg finds a LOB orphan

Specifies the minimum table space size, in pages, for which a reorganization performs

Enables you to specify during configuration whether the +COPY parameter should be available during runtime to produce copies during a reorganization

Specifies the percentage of available memory BMC AMI Reorg uses

Controls the order that partitions are processed when only partitioned indexes are being reorganized

Specifies whether BMC AMI Reorg performs a PBG compression dictionary check

Enables you to stop the compression dictionaries in different partitions from changing during a reorganization

Specifies whether BMC AMI Reorg should reorganize partitions specified in the REORG statement for partition-by-growth (PBG) table spaces

Specifies the percentage of free space in each data page of the table space

Allows BMC AMI Reorg to perform any necessary drain processing while generating a REPORTONLY summary report

Activates statistics gathering and updates the Db2 catalog

Tells BMC AMI Reorg whether to set CHECK-pending status on dependent table spaces when rows are discarded from the parent table in an RI (referential integrity) relationship

Indicates whether to skip statistics for the index when running the BMC AMI Reorg Index utility or BMC AMI Utilities Manager executing a REORG INDEX statement

Specifies a list of volumes to use in the IDCAMS DEFINE statement for each new Db2 table space data set

 

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