Configuring Application Servers and Process Scheduler Servers for Remote Data Access for Informix
Before you can use remote data access with Informix on UNIX or Windows, the Informix database connectivity software (the supported version of Informix Client) must be installed on the system where the application or Process Scheduler server is running.
You must also install and configure the supported version of IBM Informix JDBC Driver on the same machine. The driver installation program is included as part of your Informix server software distribution — refer to your Informix JDBC Programmers Guide for details.
See PeopleTools 8.53 Installation for Informix, PeopleSoft Supported Platforms, and PeopleSoft Hardware and Software Requirements for version and installation information.
Important! You can install the JDBC driver anywhere. However, for proper remote data access functionality with your PeopleSoft system, you must install it under %INFORMIXDIR%/ifxjava_home.
If you're using the application server, you must edit the application server configuration file, PSAPPSRV.CFG. If you're using the PeopleSoft Process Scheduler (batch server), you must edit the server configuration file, PSPRCS.CFG. These configuration files are located in the PS_CFG_HOME directory within the appropriate domain or database name directory.
Under the line ";JavaVM Shared Library=" in the appropriate configuration file, add the following:
; RDBA Informix Add to CLASSPATH=%INFORMIXDIR%/ifxjava_home/lib/ifxjdbc.jar