Table 10-2 describes the valid ranges for the ID types.
ID type |
Server limits |
|---|---|
Logins per server (suid) |
2 billion plus 32K |
Users per database (uid) |
2 billion less 1032193 |
Groups per database (guid) |
16,390 to 1,048,576 |
Figure 10-1 illustrates the limits and ranges for logins, users, and groups.
Figure 10-1: Users, groups, and logins available in Adaptive Server
Although Adaptive Server can handle over 2 billion users connecting at one time, the actual number of users that can connect to Adaptive Server is limited by:
The number of user connections configuration parameter
The number of file descriptors available from the operating system. Each user login uses one file descriptor per connection
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
See the release bulletin for the most up to date information about Adaptive Server’s limits for logins, users, and groups.
