REALSTORAGE_MAX in macro DSN6SPRM
Specifies the maximum GB of real and auxiliary storage that Db2 can consume.
| Acceptable values: | NOLIMIT, 1–65535. |
|---|---|
| Default: | NOLIMIT |
| DSNZPxxx: | DSN6SPRM REALSTORAGE_MAX |
| Security parameter: | No |
- NOLIMIT
- Real and auxiliary storage consumption for Db2 is not bounded.
- 1–65535
-
If the total real and auxiliary storage in GB reaches or exceeds the specified limit, Db2 enters contraction mode.
In contraction mode, Db2 discards every 30 commits. Db2 indicates when it enters contraction mode by issuing console messages DSNV516I and DSNS005I with reason LOW ON AVAILABLE FRAMES. When Db2 leaves contraction mode, it issues message DSNV517I.
In most cases, set this parameter to twice the amount of real and auxiliary storage that the Db2 subsystem might reasonably consume.