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 DASD MANAGER PLUS for DB2 13.1.

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.

Important

For information about resize criteria, see the table at the end of this section.

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.

Important

For information about Resize criteria, see the table at the end of this section.

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.

Example 1— Resize option in IBM REORG

If you specify T (table spaces), I (indexes), or A (all) for the Resize option, BMCTRIG uses the following default formula to calculate the primary quantity (PQTY) unless you specify RESIZEPCT or a resize exit in BMCTRIG:

In this formula:

(ReorgSpace + (2 * SQTY)) = New PQTY

ReorgSpace is the value from the RS_TABLEPART or RS_INDEXPART statistics table. If the new PQTY is equal to the existing PQTY, the object will not be resized.

Example 2—RESIZEPCT and RESIZEDOWN options in BMCTRIG

If you specify RESIZEPCT 10 and RESIZEDOWN N, BMCTRIG compares the existing PQTY to the new PQTY (which is the REORGSPACE value from the statistics tables plus 10 percent).

If the new PQTY is greater than the existing PQTY, you will get an ALTER statement. If you do not get an ALTER statement, the new PQTY is smaller than the existing PQTY, and the RESIZEDOWN N setting prevented the resizing of the existing PQTY. If the new PQTY is equal to the existing PQTY, the object will not be resized.

 

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