o/s file descriptors Summary and Information

The System Administration Guide lacks clarification on the behavior of configuration parameter o/s file descriptors. By default Adaptive Server uses just under 2000 max o/s file descriptors. Then Adaptive Server dynamically increases its usage of o/s file descriptors from the @@max_connections setting up to the max configured value allowed by the o/s upon startup. This number does not decrease though. To process DBA’s request to increase @@max_connections setting, Adaptive Server first check the o/s max setting.