Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Shared memoryThese topics describe the content of database server shared memory, the factors that determine the sizes of shared-memory areas, and how data moves into and out of shared memory.
Virtual portion of shared memoryThe virtual portion of shared memory is expandable by the database server and can be paged out to disk by the operating system.
Components of the virtual portion of shared memoryThe virtual portion of shared memory stores a variety of data.
Thread dataWhen a client connects to the database server, in addition to starting a session, the database server starts a primary session thread and creates a thread-control block for it in shared memory.
StacksEach thread in the database server has its own stack area in the virtual portion of shared memory.

Stacks

Each thread in the database server has its own stack area in the virtual portion of shared memory.

For a description of how threads use stacks, see Stacks. For information about how to monitor the size of the stack for a session, see monitoring sessions and threads section in your HCL OneDB™ Performance Guide.

The size of the stack space for user threads is specified by the STACKSIZE parameter in the onconfig file. You can change the size of the stack for all user threads, if necessary, by changing the value of STACKSIZE.

You can use the INFORMIXSTACKSIZE environment variable to override the STACKSIZE value in the server configuration file. Set INFORMIXSTACKSIZE in the environment and recycle the instance.