onstat -g lmm command: Print low memory management information

Use the onstat -g lmm command to display information about automatic low memory management settings and recent activity.

Figure 1: Syntax:

Example output

Figure 2: onstat -g lmm command output

Low Memory Manager

Control Block      0x4cfca220
Memory Limit       300000 KB
Used               149952 KB
Start Threshold    10240 KB
Stop Threshold     10 MB
Idle Time          300 Sec
Internal Task      Yes
Task Name         ‘Low Memory Manager’
Low Mem TID        0x4cfd7178
# Extra Segments   0

Low Memory Manager Tasks

Task                Count    Last Run
Kill User Sessions  267      04/04/2011.16:57
Kill All Sessions   1        04/04/2011.16:58
Reconfig(reduce)    1        04/04/2011.16:59
Reconfig(restore)   1        04/04/2011.17:59

Last 20 Sessions Killed

Ses ID Username Hostname PID   Time 
194    sfisher  host01   13433 04/04/2011.16:57
201    sfisher  host01   13394 04/04/2011.16:57
198    sfisher  host01   13419 04/04/2011.16:57
190    sfisher  host01   13402 04/04/2011.16:57
199    sfisher  host01   13431 04/04/2011.16:57

Total Killed 177

Output description

Control Block: Address of the internal control structure for automatic low memory management
Memory Limit: Amount of memory to which the server is attempting to adhere
Used: Amount of memory currently used by the server
Start Threshold: Value for the automatic low memory management start threshold
Stop Threshold: Value for the automatic low memory management stop threshold
Idle Time: The amount of time after which automatic low memory management considers a session idle
Internal Task: Yes = using HCL OneDB™ procedures; No = using user-defined procedures
Task Name: Name of user-defined procedure
Low Mem TID: Address of the automatic low memory management thread
Task: Kill = Automatic processes ran and terminated sessions.; Reconfig(reduce) = Automatic processes ran and freed blocks of unused memory.; Reconfig(restore) = Automatic processes ran and restored services and configuration.
Count: Number of times that the task ran
Last Run: Date and time when the last task ran
Ses ID: ID of session that was terminated (with an onmode –z command)
Username: User name of the owner of the session
Hostname: Name of the host where the session originated
PID: Process ID
Time: Date and time when the session was terminated

You use the LOW_MEMORY_MGR configuration parameter to enable the automatic low memory management.