RID POOL SIZE field (MAXRBLK subsystem parameter)
The MAXRBLK subsystem parameter specifies the amount of storage in kilobytes that is needed for the RID pool.
| Acceptable values: | 0, 128–2000000 |
|---|---|
| Default: | 1000000 1 |
| Update: | press Enter twice on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM MAXRBLK |
Notes:
- Db2 calculates the value when you run the installation CLIST with INSTALL for INSTALL TYPE on panel DSNTIPA1, based on values that you specify on panel DSNTIPD.
When you run the installation CLIST with MIGRATE for INSTALL TYPE on panel DSNTIPA1, Db2 13 uses the Db2 12 field value. For more information, see Calculating storage requirements with the installation CLIST
The Override column of panel DSNTIPC controls whether Db2 uses the calculated value:
- To accept the calculated value, ensure that the Override column contains no value.
- To override the calculated value, specify a value in the Override column.
If you decide to change this field, estimate the storage that is required for the RID pool by
using the following formula:
Number of concurrent RID processing activities *
average number of RIDs * 2 * 8 (bytes per RID)Choosing 0 disables the use of the RID pool. In this case, Db2 does not use access paths or join methods that depend on RID pool storage.
This storage is located above the 2 GB bar.