15.6.2 Steps to take when a memory shortage occurs during execution of an SQL statement or command

(a) If the variable aa....aa is PROCESS

Process common memory is insufficient. Increase the value specified for the adb_sys_proc_area_max operand in the server definition. Perform the following procedure.

Procedure:

1. Estimate the maximum size of the memory used by the HADB server.

   Execute the adbls -d mem command. In the output result, look for the value in the column MAX on the line whose THREAD-NO is 0.

   For details about the adbls -d mem command, see adbls -d mem (display the memory usage status) in the manual HADB Command Reference.

2. Terminate the HADB server.

   Terminate the HADB server by executing the adbstop command.

3. Change the server definition.

   In the server definition, set the adb_sys_proc_area_max operand to a value that is equal to or larger than the value determined from the following formula.

   Formula (megabytes)

   Explanation of variables

   max_size: Value of MAX identified in step 1 (bytes)

   get_size: Value of the variable bb....bb in the output message (bytes)

4. Start the HADB server.

   Execute the adbstart command to start the HADB server.

5. Re-execute the SQL statement or command.

Note

For details about the adb_sys_proc_area_max operand in the server definition, see the adb_sys_proc_area_max operand in 7.2.2 Operands related to performance (set format).

(b) If the variable aa....aa is THREAD

Real thread private memory is insufficient. Increase the value specified for the adb_sys_rthd_area_max operand in the server definition. Perform the following procedure.

Procedure:

1. Estimate the maximum size of the memory used by the HADB server.

   Execute the adbls -d mem command. In the output result, look for the maximum value in the column MAX on all of the lines whose THREAD-NO is not 0.

   For details about the adbls -d mem command, see adbls -d mem (display the memory usage status) in the manual HADB Command Reference.

2. Terminate the HADB server.

   Terminate the HADB server by executing the adbstop command.

3. Change the server definition.

   In the server definition, set the adb_sys_rthd_area_max operand to a value that is equal to or larger than the value determined from the following formula.

   Formula (megabytes)

   Explanation of variables

   max_size: Maximum value of MAX identified in step 1 (bytes)

   get_size: Value of the variable bb....bb in the output message (bytes)

4. Start the HADB server.

   Execute the adbstart command to start the HADB server.

5. Re-execute the SQL statement or command.

Note

For details about the adb_sys_rthd_area_max operand in the server definition, see the adb_sys_rthd_area_max operand in 7.2.2 Operands related to performance (set format).

(c) If the variable aa....aa is HEAP

Heap memory is insufficient. Perform the following procedure.

Procedure:

1. Check whether there are any unneeded processes. If you find any unneeded processes, terminate or delete them.

2. If there is still not enough memory after performing step 1, take the following action.

   • Execute the adbstop command to terminate the HADB server.

   • Execute the adbstart command to start the HADB server.

3. If there is still not enough memory after performing step 2, take the following action.

   • Execute the adbstop command to terminate the HADB server.

   • Restart the OS.

   • Execute the adbstart command to start the HADB server.

   If the problem occurred on a client, restart the client's OS.

4. If there is still not enough memory after performing step 3, take the following action.

   • Execute the adbstop command to terminate the HADB server.

   • Change the kernel parameter settings to increase the maximum size of memory that can be used by the process.

   • Restart the OS.

   • Execute the adbstart command to start the HADB server.

   If the problem occurred on a client, change the kernel parameter settings on the client to increase the maximum size of memory that can be used by the process. Then, restart the client's OS.

5. Re-execute the SQL statement or command.

(d) If the variable aa....aa is SHARE

Shared memory is insufficient. Perform the following procedure.

Procedure:

1. Check whether there are any unneeded processes or shared memory. If you find any unneeded processes, terminate them. If you find any unneeded shared memory, delete it.

2. If there is still not enough shared memory after performing step 1, take the following action.

   • Execute the adbstop command to terminate the HADB server.

   • Execute the adbstart command to start the HADB server.

3. If there is still not enough shared memory after performing step 2, take the following action.

   • Execute the adbstop command to terminate the HADB server.

   • Restart the OS.

   • Execute the adbstart command to start the HADB server.

   If the problem occurred on a client, restart the client's OS.

4. If there is still not enough shared memory after performing step 3, take the following action.

   • Execute the adbstop command to terminate the HADB server.

   • Change the kernel parameter settings to increase the maximum size of shared memory.

     If you have applied HugePages to the HADB server's shared memory, make sure that the kernel parameters are set to make HugePages usable. For details, see 6.2 Estimating the kernel parameters.

   • Restart the OS.

   • Execute the adbstart command to start the HADB server.

   If the problem occurred on a client, increase the maximum size of shared memory on the client. Then, restart the client's OS.

5. Re-execute the SQL statement or command.