Resize
The Resize option is available for REORG and BMCREORG in a BMCTRIG corrective action.
Resize is based on the REORSPAC exception. You must first collect and save BMCSTATS to the statistics repository tables. Resize is not available if the REORGSPACE or REORGSPACE_KB statistic is less than or equal to zero (indicating that the product gathered no statistics).
BMCSTATS collects REORGSPACE and REORGSPACE_KB statistics and saves them in the RS_TABLESPACE, RS_TABLEPART, RS_INDEXES and RS_INDEXPART tables.
When resizing is necessary, the product uses general rules to generate the target job and perform the series of events for each triggered table space or index. The Resize option determines which objects can be resized. (You can resize storage-group-defined objects independently of a reorganization if the corrective action contains a RESIZE service.) The Resize rules vary as follows.
Rule 1
Conditions: This rule applies when Resize is specified and all of the following conditions exist:
- Any partition of the table space is storage-group defined.
- That partition meets the resize criteria.
Response: The target job proceeds as follows for storage-group-defined objects:
- Generates an ALTER TS PRIQTY statement for that table space partition
- Generates ALTER SECQTY if RESIZEPCT2 is coded
Rule 2
Conditions: This rule applies when Resize is specified and all of the following conditions exist:
- Indexes are also evaluated for Resize.
- Any index partition that is related to the designated table space is storage-group-defined.
- That index partition meets the Resize criteria.
Response: The target job proceeds as follows for storage-group-defined objects:
- Generates an ALTER IX PRIQTY statement for the index partition
- (optionally) Generates ALTER SECQTY if RESIZEPCT2 is coded
Rule 3
Conditions: This rule applies when Resize is specified and either of the following conditions exists:
- Any partition of the table space is VSAM defined, and that partition meets the Resize criteria.
- Indexes are also being evaluated for Resize, any index partition related to the designated table space is VSAM defined, and that index partition meets the Resize criteria.
Response: If the service is REORG or BMCREORG, the target job proceeds as follows:
- Generates the REORG parameters, setting the UNLOAD option to PAUSE.
- Generates IDCAMS DELETE/DEFINE statements for all related VSAM table space and index partitions that meet the Resize criteria.
- Generates the REORG parameters, again using the RESTART parameter for the utility.
However, if the service is not REORG or BMCREORG, the target job generates the REORG parameters by using all the supplied options.
The following table lists the Resize criteria used when the table space or index partition has an exception:
Command | INDEX | PARTLVL | Partition with exception | Resizes |
---|---|---|---|---|
BMCSTATS TABLESPACE or TABLESPACESET or OBJECTSET | Y | N | Table space | All eligible table space partitions for the space. All eligible index partitions including non-partitioned indexes for the table space. |
BMCSTATS TABLESPACE or TABLESPACESET or OBJECTSET | Y | Y | Table space | Table space partition if eligible and related index partitions if eligible. Non-partitioned indexes are not resized. |
BMCSTATS TABLESPACE or TABLESPACESET or OBJECTSET | N | N | Table space | All eligible table space partitions for the space. |
BMCSTATS TABLESPACE or TABLESPACESET or OBJECTSET | N | Y | Table space | Table space partition if eligible. |
BMCSTATS TABLESPACE or TABLESPACESET or OBJECTSET | Y | N | Index | All eligible partitions for the index. |
BMCSTATS TABLESPACE or TABLESPACESET or OBJECTSET | Y | Y | Index | Index partition if eligible. |
BMCSTATS INDEX | N/A | N | Index | All eligible index partitions. |
BMCSTATS INDEX | N/A | Y | Index | The index partition if eligible. |
For resize limitations, see Resize-limitations.
The Resize criteria is specified by a set of BMCTRIG options. For more information, see Resize-options.