Sybase DC35823-01-1500-04 Restoring correct permissions, File descriptors and user connections

Restoring correct permissions

Restoring correct permissions

Sybase software files and directories are installed with the correct access permissions. If you notice that the permissions are no longer correct, you can restore the correct permissions with the script setperm_all, located in the $SYBASE/$SYBASE_ASE/install directory.

File descriptors and user connections

The number of user connections used by Adaptive Server cannot exceed the number of file descriptors available to Adaptive Server on the operating system. When configuring user connections on Adaptive Server, the System Administrator should take into account the number of file descriptors available per process. Although most of the open file descriptors are available for user connections, a few are used by Adaptive Server for opening files and devices.

For HP-UX

The kernel parameters maxfiles and maxfiles_lim control the number of file descriptors available to any one process. The limit is 10,000 for HP-UX on a 32-bit system, and 60,000 on a 64-bit system.

To obtain the current values on the file descriptors use the Korn or Bourne shell ulimit command: ulimit -n

For AIX

The number of file descriptors per process is determined by the operating system parameter open_max. The default value of open_max is 32767. Adaptive Server can use a maximum of 2000 file descriptors per engine, regardless of the value of open_max. For more information on setting open_max, see the AIX operating system documentation.

To obtain the current value of the open_max parameter, use the Korn or Bourne shell ulimit command:

ulimit -n

34 Adaptive Server Enterprise