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 directory that contains the connectivity software, for example C:\Program Files\IBM\SQLLIB\java, and specify it in the appropriate configuration file. Update the "Add to CLASSPATH" parameter in the General Settings for PSTOOLS section.
Add to CLASSPATH=C:\Program Files\IBM\SQLLIB\java\db2java.zip