Hitachi

Hitachi Advanced Database Command Reference


27.3.2 Displaying the total memory size (-a option specified)

The adbls -d mem command is executed to display the status of the memory allocated by the server process (shared memory and heap memory).

[Figure]

Explanation of the output items

TOTAL_LIMIT

Displays the upper limit (in megabytes) for the total amount of memory that can be allocated by the HADB server (the value specified for the adb_sys_memory_limit operand in the server definition).

If the adb_sys_memory_limit operand in the server definition is not specified, an asterisk (*) is displayed.

TOTAL_USE

Displays the total amount of memory (in megabytes) currently allocated by the HADB server.

TOTAL_USE_PER

Displays the ratio (in percent) between the total amount of memory (in megabytes) currently allocated by the HADB server and the upper limit for the total amount of memory that can be allocated by the HADB server.

If the adb_sys_memory_limit operand in the server definition is not specified, an asterisk (*) is displayed.

TOTAL_MAX

Displays the largest amount of total memory (in megabytes) that has been allocated since the HADB server started.

TOTAL_MAX_TIME

Displays the time at which the total amount of HADB memory reached the value of the output item TOTAL_MAX. If the value of TOTAL_MAX has been reached several times since the HADB server started, the oldest time is displayed.

TOTAL_MAX_1h

Displays the largest amount of total memory (in megabytes) that was allocated by the HADB server within the most resent hour.

If the adbls -d mem command with the -a option specified is executed after the HADB server terminated abnormally, the largest amount of total memory allocated by the HADB server is also displayed. In this case, the range of displayed information is within one hour from the time the HADB server terminated abnormally.

Depending on when the adbls -d mem command with the -a specified is executed, the maximum size of allocated memory for only the most recent 59 minutes might be displayed.

TOTAL_MAX_TIME_1h

Displays the time at which the total amount of HADB memory reached the value of the output item TOTAL_MAX_1h. If the value of TOTAL_MAX_1h has been reached several times within the most recent hour, the oldest time is displayed.

TOTAL_MAX_1d

Displays the largest amount of total memory (in megabytes) that was allocated by the HADB server within the most recent day.

If the adbls -d mem command with the -a option specified is executed after the HADB server has terminated abnormally, the largest amount of total memory allocated by the HADB server is also displayed. In this case, the range of displayed information is within one day from the time the HADB server terminated abnormally.

Depending on when the adbls -d mem command with the -a specified is executed, the maximum size of allocated memory for only the most recent 23 hours might be displayed.

TOTAL_MAX_TIME_1d

Displays the time at which the total amount of HADB memory reached the value of the output item TOTAL_MAX_1d. If the value of the TOTAL_MAX_1d has been reached several times within the most recent day, the oldest time is displayed.

GBUFFER_USE

Displays the total amount of global buffer pages (in megabytes) currently allocated by the HADB server.

PROCESS_USE

Displays the total amount of process common memory (in megabytes) currently allocated by the HADB server.

If the adb_sys_shm_huge_page_size operand in the server definition is specified, the sum of the values rounded up by the value of the adb_sys_shm_huge_page_size operand in the server definition is displayed when shared memory is allocated. Therefore, this value might differ from the sum of the values of USE and FREE for process common memory that are displayed when the adbls -d mem command is executed without the -a option specified.

THREAD_USE

Displays the total amount of real thread private memory (in megabytes) currently allocated by the HADB server.

If the adb_sys_shm_huge_page_size operand in the server definition is specified, the sum of the values rounded up by the value of the adb_sys_shm_huge_page_size operand in the server definition is displayed when shared memory is allocated. Therefore, this value might differ from the sum of the values of USE and FREE for real thread private memory that are displayed when the adbls -d mem command is executed without the -a option specified.

HEAP_USE

Displays the total amount of heap memory (in megabytes) currently allocated by the HADB server.

OTHER_USE

Displays the total amount of memory for the shared memory management area (in megabytes) currently allocated by the HADB server.