Home | Previous Page | Next Page   Environment Variables > Environment Variables >

INFORMIXSTACKSIZE

The INFORMIXSTACKSIZE environment variable specifies the stack size (in kilobytes) that the database server uses for the primary thread of a client session. You can use INFORMIXSTACKSIZE to override the value of the ONCONFIG parameter STACKSIZE for a given application or user.

Read syntax diagramSkip visual syntax diagram>>-setenv--INFORMIXSTACKSIZE--size-----------------------------><
 
size
is an integer, setting the stack size (in kilobytes) for SQL client threads.

For example, to decrease the INFORMIXSTACKSIZE to 20 kilobytes, enter the following command:

setenv -STACKSIZE 20 

If INFORMIXSTACKSIZE is not set, the stack size is taken from the database server configuration parameter STACKSIZE or else defaults to a platform-specific value. The default stack size value for the primary thread of an SQL client is 32 kilobytes for nonrecursive database activity.

Warning:
For instructions on setting this value, see the IBM Informix: Administrator's Reference. If you incorrectly set the value of INFORMIXSTACKSIZE, it can cause the database server to fail.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]