Under AIX, the following error is generated when you start a SAS web server by using the PostgreSQL database management system:

The following steps should resolve this error. The problem might resolve after just the first two steps. If the problem does not resolve at that point, perform the third step.

1. Check the setting for the maximum user process. The problem can occur when the maximum user process on the machine is set too low. To check the setting, submit the following command:
lsattr -E -l sys0 | grep maxuproc

The setting should be no lower than 2048.

2. Change the maximum number of connections to 384 in the postgresql.conf file. This file is located in the data directory of the PostgreSQL installation.
3. Change the maxPoolSize="100" setting in the server.xml file to maxPoolSize="30" for all the SAS web servers, as shown in the example below for SASServer1
   
   <Resource auth="Container" driverClassName="org.postgresql.Driver" factory="com.sas.vfabrictcsvr.atomikos.BeanFactory" maxPoolSize="30" minPoolSize="10" name="sas/jdbc/Administration" password="${pw.sas.jdbc.Administration}" testQuery="select 1" type="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean" uniqueResourceName="sas/jdbc/Administration" url="jdbc:postgresql://ctnr6405.unx.sas.com:49432/Administration" user="adminowner"/>
   Note: The server.xml file resides in SAS-configuration-directory/Lev1/Web/WebAppserver/SASServerX_X/conf/. In this path, SASServerX_X represents all of the servers in your installation (for example, SASServer1_1,SASServer2_1,SASServer7_1, and so on).

   After you make this change, restart the servers.

Operating System and Release Information