Login connection limitations

Although Adaptive Server allows you to define more than two billion logins per server, the actual number of users that can connect to Adaptive Server at one time is limited by the:

• Value of the number of user connections configuration parameter, and

• Number of file descriptors available for Adaptive Server. Each login uses one file descriptor for the connection.

  The maximum number of concurrent tasks running on the server is 32,000.

1. Configure the operating system on which Adaptive Server is running for at least 32,000 file descriptors.

2. Set the value of number of user connections to at least 32,000.

   Before Adaptive Server can have more than 64K logins and simultaneous connections, you must first configure the operating system for more than 64K file descriptors. See your operating system documentation for information about increasing the number of file descriptors.

To issue a global variable, enter:

select variable_name

For example:

select @@minuserid
----------- 
-32768