REALSTORAGE_MANAGEMENT in macro DSN6SPRM
The REALSTORAGE_MANAGEMENT subsystem parameter specifies whether DB2® should manage real storage consumption.
| Acceptable values: | ON, OFF, AUTO |
| Default: | AUTO |
| DSNZPxxx: | DSN6SPRM REALSTORAGE_MANAGEMENT |
- ON
- DB2 always discards unused real storage frames. Discarding the frames results in some CPU overhead, and this option is intended for systems in which the availability of real storage is limited. This value would most likely be appropriate for LPARs that have many DB2 subsystems, such as a development LPAR.
- OFF
- DB2 does not discard unused real
storage frames until one of the following conditions is met:
- The LPAR had reached an auxiliary critical state.
- The total real and auxiliary storage has reached 80% of the value of the REALSTORAGE_MAX subsystem parameter.
- AUTO
- DB2 discards unused real storage frames when a significant amount of paging activity is detected. By discarding frames, DB2 tries to bring the system to a point where paging is limited or nonexistent. However, it might not be possible to bring the system to that point if other applications on the same LPAR cause the shortage of real storage frames. AUTO is the default value.
