TSRSIZE—tableSPACE Region Size

The TSRSIZE parameter is an integer representing the amount of storage to be used for the TABLE SPACE REGION (TSR). tableBASE uses Data Spaces for all TSRs, whether local or VTS. This ensures that tableSpace memory requirements do not affect other memory requirements in the region. The format for TSRSIZE is:

  • nnnnnnnn = bytes
  • nnnnnnnK = kilobytes
  • nnnnM = megabytes
  • nG = gigabytes

Value recommendations

The delivered default value for the TSRSIZE is 100M for all interfaces. The current minimum size of a TSR is 28 KB (but this may change in subsequent maintenance releases). The maximum size of a TSR is 2G (or 2048M or 2097152K). TSRSIZE only accepts up to eight digits, thus you cannot specify 2G as TSRSIZE=2147483648.

Note:
If you specify a value of 0, the minimum size will be substituted; if you specify a value of between 1 and the minimum, an error code will be returned.

Failure to set your TSR size parameter appropriately can produce the following error:

Error 92

There is insufficient tableSPACE region available. Increase TSR size.

Note:
  1. TSREGION and TSR parameters are maintained for backwards compatibility and are treated as equivalents to TSRSIZE.
  2. There is a possibility that your system programmers have established limits on the maximum size or the maximum number of data spaces. All local TSRs are allocated as SCOPE=SINGLE data spaces; VTS-TSRs are allocated as SCOPE=ALL data spaces.

This option applies to the TSR created by this region or job and all users accessing it.

This option can be specified for all tableBASE Interfaces.