WebSphere WebSphere Enterprise Service Bus, Version 6.0.1 Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

DB2 database response file for Linux, UNIX, and Windows systems

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.

Concept topic

Terms of Use | Rate this page

Timestamp iconLast updated: 13 Dec 2005
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.websphere.wesb.doc\doc\ccei_install_db2responsefile.html

(C) Copyright IBM Corporation 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)