Skip to Main Content
Return to Navigation

Configuring Application Servers or Process Scheduler Servers for Remote Data Access with DB2 UDB

This section discusses how to:

Before you can use remote data access, you must install the appropriate database connectivity software on the system where the application server or Process Scheduler server is running. In addition, you must edit the PSAPPSRV.CFG and, the PSPRCS.CFG configuration files.

See PeopleSoft Supported Platforms, PeopleSoft Hardware and Software Requirements, and your PeopleTools installation documentation for version and installation information.

Configuring Remote Data Access for DB2 UDB for Linux, UNIX and Windows

The minimum database connectivity software that needs to be installed is the IBM DB2 Run-Time Client. In addition, the application server configuration file, PSAPPSRV.CFG, must be edited. If the Process Scheduler server is being used, the Process Scheduler server configuration file, PSPRCS.CFG, must be edited as well. These configuration files reside in the PS_CFG_HOME directory within the appropriate domain and database name directory.

To edit the file, determine DB2 UDB's home directory and specify it in the configuration file.

For example, if DB2 UDB's home directory is C:\Apps\DB\DB2ODBC8, you should add the following lines under the ";JavaVM Shared Library=" section:

; RDBA DB2 Add to CLASSPATH=C:\Apps\DB\DB2ODBC8\java1x\db2java.zip

Or, if DB2 UDB's home directory is /mnt/db2/v8.1/java12, you should add the following lines under the ";JavaVM Shared Library=" section:

; RDBA DB2 Add to CLASSPATH= lmnt/db2/v8.1/java1x/db2java.zip

Configuring Remote Data Access for DB2 UDB for z/OS

The database connectivity software that needs to be installed is IBM DB2 Connect. In addition, if the application server is being used, the application server configuration file, PSAPPSRV.CFG, must be edited manually. If the Process Scheduler server is being used, the Process Scheduler server configuration file, PSPRCS.CFG, must be edited as well. These configuration files reside in the PS_CFG_HOME directory within the appropriate domain and database name directory..

Determine DB2 UDB's home directory, and specify it in the appropriate configuration file. For example, if DB2 UDB's home directory is C:\Apps\DB\DB2ODBC8, add the following lines under the ";JavaVM Shared Library=" section:

; RDBA DB2
Add to CLASSPATH=C:\Apps\DB\DB2ODBC8\java1x\db2java.zip