Error 709

Severity

17

Message text

There is insufficient system memory to continue login process for spid %d.

Explanation

The Memory Manager allocates and deallocates memory for Adaptive Server processes and manages memory requirements for the system. For each process connecting to the server, the Memory Manager allocates a memory structure called a procedure header and ensures that there is enough memory to dedicate to the process.

Error 709 is raised when a user process attempts to log in to the server, but there is not enough memory available to complete the login.

Action

Correct this error by increasing the amount of available memory. You can do this by:

Version 12.0 and earlier:

Increasing the total memory configuration parameter for Adaptive Server is the most straightforward method. It increases both the procedure and data caches, although it can waste memory. Since total memory and procedure cache percent are static parameters, you must restart Adaptive Server after changing these parameters.

Version 12.5 and later:

Increasing the procedure cache size configuration parameter for Adaptive Server is the most straightforward method.

Additional information

Check the value of the number of user connections configuration parameter. Since there is memory overhead associated with each user connection, setting this parameter too high can reduce the amount of space available for the data and procedure caches, and contribute to 709 errors.

Versions in which this error is raised

All versions