RIDBLKS—Max RID block
Use the Modify Max RID Block panel or the RIDBLKS command to specify the number of blocks to use for the RID pool. The sorting of record identifiers (RIDs) during list prefetch, hybrid joins, and access through multiple indexes occurs in the RID pool. The value specified is the maximum number of RID storage blocks that can be allocated at any time. No storage is allocated until needed at run time.
Modify Max RID Block panel
Command: CURRENT
Description . . . . . . : MAXIMUM NUMBER OF RID BLOCKS
Type the new maximum number of Rid Blocks you wish to change to. Then Press Enter.
Max Rid Blocks Parameter
Number of Rid Blocks . . . . 12500 (0, 4-65535 or delta)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
value | Maximum number of RID storage blocks that can be allocated at any time. Specify one of the following values:
|
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
RID blocks | None | None | None | MAXRBLK |