17
There is insufficient system memory to continue login process for spid %d.
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.
Correct this error by increasing the amount of available memory. You can do this by:
Version 12.0 and earlier:
Use the total memory configuration parameter to increase the total amount of memory requested by Adaptive Server.
Use the procedure cache percent configuration parameter to increase the percentage of total cache space dedicated to procedure cache.
Decrease the amount of memory required for other resources; for example, unneeded user connections.
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:
Use the max memory configuration parameter to increase the total amount of memory available to Adaptive Server.
Use the procedure cache size configuration parameter to increase the percentage of memory dedicated to procedure cache.
Decrease the amount of memory required for other resources; for example, unneeded user connections.
Increasing the procedure cache size configuration parameter for Adaptive Server is the most straightforward method.
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.
All versions
