Resize options
This topic covers resize options that determine which formulas are used for new allocation values (PRIQTY and SECQTY) when BMCTRIG selects objects to be resized.
These options also specify rules regarding the generation of those jobs. BMCTRIG evaluates objects for resizing if the corrective action contains a RESIZE service or a reorganization (REORG or BMCREORG) with the RESIZE option set in the service syntax.
The following figure shows the syntax for Job generation options.
Resize options
The following table shows the resize options, showing the availability by object type (INDEX (IX), INDEXSPACE (IS), TABLE SPACE (TS), and TABLE SPACE SET (TT)). Values in boldface are the default values.
Resize options
Option name | Value | Description | Object type | |
|---|---|---|---|---|
TT, TS | IX, IS | |||
MAXPCT | 0 (default) through 100 | Defines the percentage to use when recalculating the primary quantity if the primary quantity exceeds the value that MAXPRIM sets If you specify a nonzero percentage, BMCTRIG recalculates the primary quantity to that percentage of REORGSPACE. | X | X |
MAXPRIM | 0 (default) through 67108864 | Sets a maximum primary quantity allocation quantity in kilobytes If you do not set a nonzero maximum, BMCTRIG uses the maximum data set or piece size to limit the allocation. | X | X |
RESIZEDOWN | Y (default) N | Indicates whether to let table space or index objects be resized downward when the product generates a reorganization | X | X |
RESIZEJOBS | Y (default) N | Indicates whether to split REORG and RESIZE job steps into separate jobs This option is valid only when STDJCL is Y. Specifying RESIZEJOBS Y forces PARTLVL Y and MAXOBJECTS 1 and splits REORG and RESIZE job steps into separate jobs for each object or partition. If RESIZEJOBS is N, REORG and RESIZE job steps are combined with other utility job steps into a single job in accordance with the MAXOBJECTS parameter. BMCTRIG limits the number of JCL steps per job to 255 or the value of the MAXSTEPS option. If you are using workload balancing, BMCTRIG ignores RESIZEJOBS. | X | X |
RESIZEPCT | 0 (default) through 999 | Specifies the percentage value that is added to the existing REORGSPACE value to calculate the new PRIQTY RESIZEPCT is an alternative to the following default method (zero value) for resizing objects and partitions: PRIQTY = REORGSPACE + (2*SQTY) With a nonzero value, the product calculates a new primary quantity as follows: PRIQTY = REORGSPACE * 1. nn The variable nn is the percentage that you entered. Both methods are under the control of the DASD MANAGER PLUS RESIZE exit, which you can modify. For more information, see members ASUXRESZ (assembler version) and ASUXRESC (C version) in About-User-Exits. Tip: To fit the data in one extent and account for DB2 preformatting and preallocation, add space equivalent to two secondary allocations to the size of the primary allocation. | X | X |
RESIZEPCT2 | 0 (default) through 999 | Resizes the secondary allocation quantity Use this option with RESIZEPCT. When you specify a nonzero value, BMCTRIG calculates the new SECQTY value by applying the percentage to the newly calculated primary quantity. A zero value specifies not to alter the secondary quantity when resizing. | X | X |
ROUND | A (default) C | Rounds the allocation quantities based on the allocation type (A) as noted in the BMCSTATS tables or calculates (C) on a cylinder boundary | X | X |