Skip navigation links

Additional languages
5.2.2.2 DUMP 1223 »
Section Navigation      [Toggle]

5.2.2.1. DUMP 1000

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

Note

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).