Setting-up the WebServices Gateway JDBC driver and Data Source
on WebSphere Application Server 4

Perform the 3 steps below before you install the Gateway Persistent Correlation
Application wsgwcorr.ear.
These steps are not needed when wsgwcorr.ear won't be installed (wsgwcorr.ear is
needed for asynchronous channels like the JMS channel).

For steps 2 and 3, make sure your Application Server is running.
Restart your Admin Server (node) after step 3.

Windows:

1- Database and Table creation
%Gateway_Dir%\install\WSGWinstallDB.bat will create the WSGWDB database and the
GatewayCorrelationBean table inside it.
Usage: WSGWinstallDB <WebSphere_AppServer_Dir> <db2userid> <db2pwd>

2- JDBC driver creation
%Gateway_Dir%\install\WSGWinstallJDBC.bat will create the JDBC driver
Usage: WSGWinstallJDBC <Gateway_Dir> <Node_Name> <WebSphere_AppServer_Dir> <DB2_Dir>

3 - DataSource creation
%Gateway_Dir%\install\WSGWinstallDS.bat will create the data source
Usage: WSGWinstallDS <Gateway_Dir> <Node_Name> <WebSphere_AppServer_Dir> <db2userid> <db2pwd>



Unix:

Make sure all the scripts under ${Gateway_Dir}/install have EXECUTE permission.
(chmod +x *.sh)

1- Database and Table creation
As the 'root' user, go to ${Gateway_Dir}/install/
${Gateway_Dir}/install/WSGWinstallDB.sh will create Correlation table in WSGWDB
database
Usage: ./WSGWinstallDB.sh <WebSphere_AppServer_Dir> <db2userid>

2- JDBC driver creation
${Gateway_Dir}/install/WSGWinstallJDBC.sh will create the JDBC driver
Usage: ./WSGWinstallJDBC.sh <Gateway_Dir> <Node_Name> <WebSphere_AppServer_Dir> <DB2_Dir>

3 - DataSource creation
${Gateway_Dir}/install/WSGWinstallDS.sh will create the data source
Usage: ./WSGWinstallDS.sh <Gateway_Dir> <Node_Name> <WebSphere_AppServer_Dir> <db2userid> <db2pwd>