Configuring Application Servers or Process Scheduler Servers for Remote Data Access with Db2 for z/OS
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.
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 the Db2 for z/OS home directory, and specify it in the appropriate configuration file. For example, if the Db2 for z/OS 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