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: Start of change1000000End of change 1
Update: press Enter twice on panel DSNTIPB
DSNZPxxx: DSN6SPRM MAXRBLK
Notes:
  1. 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 12 uses the Db2 11 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: Start of change
Number of concurrent RID processing activities *
average number of RIDs * 2 * 8 (bytes per RID)
End of change

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.