DB2:getMemoryUsage
Retrieves memory usage statistics from all partitions in megabyte (MB) values.
Note: This method can be used IF-AND-ONLY-IF you have access and privileges to execute SYSPROC database objects.
Type
SYNC, IMPACT_INFO
Arguments
None.
Returns
|
Name |
Type |
Description |
|
Partition |
The database partition number from which memory usage statistics is retrieved. |
|
|
Max Memory (MB) |
Big Integer |
The maximum amount of instance memory (in bytes) allowed to be consumed in the database partition if an instance memory limit is enforced. |
|
Current Memory (MB) |
Big Integer |
The amount of instance memory (in bytes) currently consumed in the database partition. |
|
Peak Memory (MB) |
Big Integer |
The peak or high watermark consumption of instance memory (in bytes) in the database partition. |
Usage Notes
Invoking this method returns statistics for the amount of memory used from all partitions.