Configuring WebSphere Application Server 3.x for z/OS or OS/390

 

The following steps detail how to configure WebSphere Application Server Version 3.02 for OS/390 or z/OS to work with DB2 Web Query. The following steps assume that you have successfully installed and configured JDBC and performed the basic DB2 Web Query installation, customization and configuration of the IBM HTTP Server and WebSphere Application Server and successfully executed the sample application.

To configure WebSphere Application Server version 3.x:

1.         In your WebSphere Application Server installation directory, locate and open the file named was.conf.

Note: If the suggested directory structure was used during install, the file will be located in the following path:/usr/lpp/WebSphere/AppServer/properties.

2.         In the file was.conf, set session.cookies.enable to true to enable WebSphere session tracking.

3.         In the file was.conf, adjust the default session time-out parameter to your system preferences by adjusting the value associated with the session.invalidationtime parameter. The default is 1800000 ms or 30 minutes.

Note: The values for the idleconnectiontimeoutmiliseconds and inuseconnectiontimeoutmiliseconds parameters should be set to the same value as the session.invalidationtime parameter.

4.         Add the following text to was.conf: <installRoot>

# ================================================================= #

# BEGIN DB2 Web Query

# ================================================================== #

 

deployedwebapp.DB2WebQuery.description=IBM DB2 Web Query Tool

deployedwebapp.DB2WebQuery.host=default_host

deployedwebapp.DB2WebQuery.rooturi=/DB2Tools

deployedwebapp.DB2WebQuery.documentroot=<installRoot> /web

deployedwebapp.DB2WebQuery.classpath=<installRoot>/se rvlet

deployedwebapp.DB2WebQuery.autoreloadinterval=0

webapp.DB2WebQuery.filemapping=/

webapp.DB2WebQuery.jspmapping=*.jsp

webapp.DB2WebQuery.jsplevel=0.91

webapp.DB2WebQuery.servlet.WebQuery.servletmapping=/WebQuery

webapp.DB2WebQuery.servlet.WebQuery.code=com.ibm.db2.WebQueryToo l.WebQuery

webapp.DB2WebQuery.servlet.WebQuery.initargs=installRoot=<installRoot>,webRoot=/DB2Tools/DB2WebQuery,appRoot=/DB2Tools/WebQuery,wqUserId=<user>,wqUserPass=<password>,emailHost=<mail.company.com>,hostName=<wqhost.company.com>,dbDriver<n>=<name>|<jdbc driver Name>|<jdbc url root>|<connection pool name>

webapp.DB2WebQuery.servlet.WebQuery.autostart=true

# ================================================================== #

# END DB2 Web Query

# ================================================================== #

Here is an example of values that can be used for the initArgs section of the above.

 

webapp.DB2WebQuery.servlet.WebQuery.initargs=installRoot=/usr/lpp/DB2WebQuery,webRoot=/DB2Tools/DB2WebQuery,appRoot=/DB2Tools/WebQuery,wqUserId=xxxxxx,wqUserPass=xxxxxx,emailHost=172.16.37.17,hostName=rs11.rocketsoftware.com,SMTPPort=25,queryTimeout=0,queryRowLimit=0,daysSaved=7,dbDriver1=OS390-DB2-V6|COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver|jdbc:db2os390:|jdbc/db2wqt

 

5.         In the text that you just added to was.conf:

a)    Replace installRoot with the path where DB2 Web Query was installed

b)    Replace user with the actual name of the user who administers the OS/390 OR Z/OS system

c)    Replace password by the administrative user's password.

d)    Replace mail.company.com with the name of your SMTP/POP E-mail server.

e)    Replace wqhost.company.com with the name of the host that runs DB2WebQuery.

f)     Optional: If you do not want DB2 Web Query to load when you start IMWEBSRV (the web server process that runs on OS/390 OR Z/OS), set webapp.DB2WebQuery.servlet.WebQuery.autostart to false. In this case, DB2 Web Query will load the first time that it is called.

g)    Set the following parameters as appropriate for your system.

jdbcconnpool.DB2WebQuery.waitforconnectiontimeoutmilliseconds=30000

jdbcconnpool.DB2WebQuery.idleconnectiontimeoutmilliseconds=1800000

jdbcconnpool.DB2WebQuery.inuseconnectiontimeoutmilliseconds=1800000

jdbcconnpool.DB2WebQuery.jdbcdriver=ibm.sql.DB2Driver

jdbcconnpool.DB2WebQuery.databaseurl=jdbc.db2os390.<database name>

jdbcconnpool.DB2WebQuery.datasourcename=jdbc/db2wqt

jdbcconnpool.DB2WebQuery.databaseurl=jdbc:db2os390:<database name>

h)    Set any DB2 Web Query parameters necessary on the following line in was.conf:

webapp.DB2WebQuery.servlet.WebQuery.initargs=installRoot=<installRoo t>,webRoot=/DB2Tools/DB2WebQuery,appRoot=/DB2Tools/WebQuery,wqUserId =user,wqUserPass=password,emailHost=mail.company.com,hostName=wqhost .company.com ,dbDriver1=OS390-DB2-V6|COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver|jdbc:db2os390:|jdbc/db2wqt

 

Information on the DB2 Web Query parameters is available from the parameter list.

Note: The above line has been broken for printing purposes, but it should be entered as one line in was.conf.

6.         In your WebSphere Application Server installation directory, locate and open the file named httpd.conf

Note: If the suggested directory structure was used during install, the file will be located in the following path:/etc.

7.         Add the following line to httpd.conf::

Service /DB2Tools/* /usr/lpp/WebSphere/AppServer/bin/was302plugin.so:service_ exit

Note: The previous line has been broken for readability. When you add it to the file it should be added as one line.

8.         Ensure that IMWEBSRV has read and search access to the following directories and their contents (including subdirectories and files):

·       <installroot>/servlet

·       <installroot>/web

9.         Ensure that IMWEBSRV has read/write access to the following directories:

·       <installroot>/logs

·       <installroot>/users

10.      From the SDSF (System Display and Search Facility) prompt, stop and start the IMWEBSRV service.