Each DB2 Web Query configuration parameter is listed below with its definition. The default value of each parameter is shown in parenthesis after the parameter name.
(/Db2WebQuery) This is the sub-directory of the web server Document Root that contains the DB2 Web Query HTML documents. The default installation is recommended. This parameter should always begin with the character "/".
(/servlet/DB2WebQuery) This parameter describes how DB2 Web Query is called from the application server. The default installation is recommended. This should match the entry in the was.conf file.
(/usr/lpp/DB2WebQuery) This parameter indicates the file path location where DB2 Web Query is installed.
(no default) This is the full name of the JDBC driver that is used for the database to which you want to connect. If nothing is specified for the dbDriver parameter, DB2 Web Query will be unable to make any connections. The dbDriver parameter must be followed by a postfix to allow multiple drivers to be installed. For example: auxDriverName1. The postfix should be ordered sequentially starting from 1. The entry for the dbDriver parameter should be in the form of a | separated list as follows:
name|jdbc driver|url prefix|connection pool|aux
Where:
· name is a descriptive name give by the administrator (i.e., DB2)
· jdbc driver is the JDBC driver class name
· url prefix is the jdbc URL without the location
· connection pool is the connection pool that is used to connect to DB2. This is only used on the OS/390 or z/OS platform. On other platforms this variable is ignored. In IBM WebSphere Application Server Version 1.2, the connection pool name is the connection pool name that was configured in the file was.conf. In IBM WebSphere Application Server Version 3.x, the connection pool name is the JNDI name that was given to the defined connection pool in the file was.conf.
· aux is the string of additional URL parameters needed to connect. If you specify the auxiliary parameter, then a connection pool parameter must also be specified. If no connection pool is needed then a space is used for the connection pool parameter
For Example:
dbDriver1=NT-DB2|COM.ibm.db2.jdbc.app.DB2Driver|jdbc:db2:
dbDriver2=OS390-DB2(1.2)|COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver|jdbc:db2os390:|DB2WebQuery
dbDriver3=OS390-DB2(3.x)|COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver|jdbc:db2os390:|jdbc/db2wqt
dbDriver4=DB2/400-TB|com.ibm.as400.access.AS400JDBCDriver|jdbc:as400:
dbDriver5=DB2/400|com.ibm.db2.jdbc.app.DB2Driver|jdbc:db2:
dbDriver6=AIX-DB2|COM.ibm.db2.jdbc.app.DB2Driver|jdbc:db2:
dbDriver7=Linux-DB2|COM.ibm.db2.jdbc.app.DB2Driver|jdbc:db2:
dbDriver8=Informix|com.informix.jdbc.IfxDriver|jdbc:informix-sqli://informix:1526/| |:INFORMIXSERVER=ol_informix
(no default) This is the OS/390 OR Z/OS login ID for the user who administers the OS/390 OR Z/OS system. It will be used to control access to the DB2 Web Query catalogs. This parameter is optional. If noting is specified for this parameter, access to the DB2 Web Query catalogs will be disabled.
(no default) This is the OS/390 OR Z/OS password for the user who administers the OS/390 OR Z/OS system. It will be used to control access to the DB2 Web Query catalogs. This parameter is optional. If noting is specified for this parameter, access to the DB2 Web Query catalogs will be disabled.
(no default) This is the name of the host running DB2 Web Query. This parameter is mandatory.
(no default) This is the server, which runs the POP/SMTP services for the system. This parameter enables DB2 Web Query email features.
(7) Query results not saved to the DB2 Web Query Catalog are kept on the server file system for this number of days.
(60) This is the number of seconds to timeout when returning large query results.
(0) This is the maximum number of rows to return when returning large query results. The default of 0 indicates no limit.
(WebQuery) This is the name of the WebSphere DB Connection Pool to use for obtaining connections to the database.
(no default) The URL that points to the location of DB2 Table Editor on your web server.
(no default) This is the port that the DB2 JDBC applet server runs on. This parameter must be set in order for DB2 Table Editor to work with DB2 Web Query.
(25) This is the port to which the DB2 Web Query SMTP server binds. This parameter is used to enable the DB2 Web Query E-mail interface. Omitting this parameter will disable the DB2 Web Query E-mail interface. The IBM DB2 Web Query STMP server must use port 25.