Configuring Application Servers or Process Scheduler Servers for Remote Data Access with DB2
This section discusses configuration steps on Db2 for z/OS.
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, Certifications tab on My Oracle Support, and the product documentation for PeopleSoft 9.2 Application Installationfor version and installation information.
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 home directory, and specify it in the appropriate configuration file. For example, if DB2 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