STACKSIZE

onconfig.std value

32 for 32-bit database servers
64 for 64-bit database servers

units

Kilobytes

range of values

32 through limit determined by the database server configuration and the amount of memory available

takes effect

When the database server is shut down and restarted

refer to

The following material:

• Stacks, in the chapter on virtual processors in the IBM Informix Administrator's Guide
• CREATE FUNCTION statement, in the IBM Informix Guide to SQL: Syntax

The STACKSIZE parameter specifies the stack size for the database server user threads. The value of STACKSIZE does not have an upper limit, but setting a value that is too large wastes virtual memory space and can cause swap-space problems.

For 32-bit platforms, the default STACKSIZE value of 32 kilobytes is sufficient for nonrecursive database activity. For 64-bit platforms, the recommended STACKSIZE value is 64 kilobytes. When the database server performs recursive database tasks, as in some SPL routines, for example, it checks for the possibility of stack-size overflow and automatically expands the stack.

User threads execute user-defined routines. To increase the stack size for a particular routine, use the stack modifier on the CREATE FUNCTION statement.