A DB2 database response file for Linux, UNIX, and Windows systems
specifies parameters for configuring a DB2 event database that runs on any
of these operating systems.
A sample DB2 database response file for Linux, UNIX, and Windows, called DB2ResponseFile.txt,
is available in the install_root/event/dbconfig directory.
This response file for Linux, UNIX, and Windows systems specifies the following
parameters:
- WAS_SERVER=server
- The name of the WebSphere ESB where the database is installed.
This parameter is applicable only if the SHARE_DB parameter
is set to server. If you do not specify a server
name, the default value is server1.
- SHARE_DB=[server|node|cell]
- The scope in which the configured database is shared. This is the scope
in which Java database connectivity (JDBC) data sources are created. This
parameter is optional. The default value is server.
- DB_NAME=name
- The name of the event database. This name must be no longer than 8 characters.
This parameter is optional; the default value is event.
- DB_NODE_NAME=name
- The database server node name. This parameter is required only if the
database server is remote; it is not required if the database server is on
the local machine.
- JDBC_PROVIDER=provider
- The name of the JDBC provider to configure. The value must be the name
of a JDBC driver supported by WebSphere ESB Version 5.1, and later.
The following drivers are recommended:
- DB2 Universal JDBC Driver Provider (XA)
- DB2 Legacy CLI-based Type 2 JDBC Provider (XA)
- JDBC_CLASSPATH=path
- The path to the JDBC driver (not including file name). This should be
one of the following:
- For DB2 Universal JDBC Driver Provider (XA): the path to the db2jcc_license_cu.jar and db2jcc_license_cisuz.jar files
- For DB2 Legacy CLI-based Type 2 JDBC Driver (XA), the path to the db2java.zip file
- UNIVERSAL_JDBC_CLASSPATH=path
- For DB2 Universal JDBC Driver Provider or DB2 Universal JDBC Driver Provider
(XA), the path to the JDBC driver (not including file name). This should be
the path to the db2jcc_license_cu.jar file. This parameter is optional.
- JDBC_DRIVER_TYPE=type
- The JDBC driver type. This should be either 2 or 4.
- DB_HOST_NAME=hostname
- The database server host name. This parameter is required if JDBC_DRIVER_TYPE is
set to 4. The default value is localhost.
- DB_INSTANCE_PORT=port
- The database instance port number. This parameter is required if JDBC_DRIVER_TYPE is
set to 4. The default port number is 50000.
- EXECUTE_SCRIPTS=[YES|NO]
- Specifies whether the database configuration scripts are automatically
run. If this parameter is set to NO, the scripts
for configuring the database are generated but do not run.
- DB_TYPE=DB2
- The type of database to configure. For a DB2 database, this must be DB2.
- PAGE_SIZE_4K_BUFFER_POOL=size
- The database 4K buffer pool size, in KB. The default value is 1500.
- PAGE_SIZE_8K_BUFFER_POOL=size
- The database 8K buffer pool size, in KB. The default value is 1500.
- PAGE_SIZE_16K_BUFFER_POOL=size
- The database 16K buffer pool page size, in KB. The default value is 1000.
- LOG_FILE_SIZE=size
- The size of the primary and secondary log files, in 4 KB pages. This parameter
is optional. The default value is 1000.
- NUM_PRIMARY_LOG=n
- The number of primary log files to use. This parameter is optional. The
default value is 3.
- NUM_SECONDARY_LOG=n
- The number of primary log files to use. This parameter is optional. The
default value is 2.
- TRANSACTION_LOG_FILE=path
- The path to the location where the transaction log files are written.
If you place the database transaction logs on a different disk from the event
database tables and indexes, this can significantly improve performance. This
parameter is optional. If no value is specified, the default location is used.