KFAA30930-E

An attempt to acquire enough memory to execute the SQL statement has failed. <SQLSTATE: 53201>

               aa....aa: Type of memory that is insufficient

                        PROCESS: There is a shortage of process common memory to be used to execute the SQL statement.

                        THREAD: There is a shortage of real thread private memory to be used to execute the SQL statement.

                        HEAP: Heap memory is insufficient.

                        SHARE: Shared memory is insufficient.

               bb....bb:

                  Size of memory area you attempted to acquire (bytes)

               S:

                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               Action:

                  Take one of the following corrective actions, and then re-execute the SQL statement or the command.

                        Re-estimate the amount of memory required, and then carefully review the value specified in the server definition.

                        Temporarily terminate the HADB server by using the adbstop command, and then change the value specified in the server definition. Then, execute the adbstart command to start the HADB server.

                        Allocate sufficient available memory as instructed in Steps to take when a memory shortage occurs during execution of an SQL statement or command in the HADB Setup and Operation Guide.