PRB: ErrMsg: kistartup: No Memory Available for Threads

  - Microsoft SQL Server version 4.2 for OS/2

SYMPTOMS

When attempting to install or start SQL Server, the following error message is returned:

   kistartup: no memory available for threads

CAUSE

This message usually indicates that there is insufficient disk space for the OS/2 swap file. During the SQL Server installation or startup the swap file may grow to a size that exceeds the available disk space. The amount of disk space required for the swap file depends on the amount of RAM in the machine and how much RAM is consumed by LAN Manager buffers and other processes.

The OS/2 swap file is called SWAPPER.DAT and is identified by the SWAPPATH parameter in the CONFIG.SYS file. The swap file usually starts out at about 0.6 megabytes and grows to accommodate the memory requirements of the processes that are running.

WORKAROUND

In order to avoid this error, either free up additional space on the drive containing the swap file or change the SWAPPATH parameter to the path of a drive or partition that contains adequate disk space.