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 | |
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 LOBMaster-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 LOBMaster 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. |
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 |
|---|---|
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 | |
Specifies the maximum amount of memory that each server task can use | |
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 a space saving trigger for processing LOB auxiliary table spaces | |
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 |
Related topics