| Code | Symbol | Kernel Block(s) |
| 1000 | DumpPageMemory |
DBACC, DBTUP
|
Description.
Prints data node mMemory usage (ACC &
TUP), as both a number of data pages, and
the percentage of DataMemory and
IndexMemory used.
Sample Output.
Node 2: Data usage is 8%(54 32K pages of total 640)
Node 2: Index usage is 1%(24 8K pages of total 1312)
Node 2: Resource 0 min: 0 max: 639 curr: 0
When invoked as ALL DUMP 1000, this
command reports memory usage for each data node
separately, in turn.
Additional Information. This is currently the only way to determine actual cluster memory usage (other than by waiting for the automatic threshold log messages to be generated).
