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

DB2 Universal Database response file for z/OS systems

A DB2 Universal Database response file specifies parameters for configuring a DB2 event database on a z/OS system.

A sample DB2 response file for z/OS systems, called DB2ZOSResponseFile.txt, is available in the install_root/event/dbconfig directory. This response file 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 and must be the name of an existing database. This parameter is optional. The default value is ceizos.
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 5027.
EXECUTE_SCRIPTS=[YES|NO]
Specifies whether the database configuration scripts are automatically run. If you are configuring the database on a z/OS system with UNIX System Services, set this value to NO.
DB_TYPE=DB2ZOS
The type of database to configure. For a DB2 for z/OS database, this must be DB2ZOS.
EVENT_DB_NAME=name
The database name for the event database. This name must be no longer than 8 characters. The default value is event.
CATALOG_DB_NAME=name
The database name for the event catalog database. This name must be no longer than 8 characters. The default value is eventcat.
STORAGE_GROUP=group
The storage group for the event database and catalog database. This must be the name of an existing storage group. The default value is sysdeflt.
BUFFER_POOL_4K=name
The name of the 4K buffer pool. The default value is BP9.
BUFFER_POOL_8K=name
The name of the 8K buffer pool. The default value is BP8K9.
BUFFER_POOL_16K=name
The name of the 16K buffer pool. The default value is BP16K9.
DAYS_TO_KEEP_EVENTS=days
The number of days that events are kept in the database before they are purged. Changes to this value significantly affect the amount of storage allocated for the table spaces that store event data. The default value is 1.
AVERAGE_EVENTS_PER_SECOND=events
The average number of events that are stored in the database each second. Changes to this value significantly affect the amount of storage allocated for the table spaces that store event data. The default value is 1.
AVERAGE_NUMBER_CONTEXT_PER_EVENT=number
The average number of context elements per event instance. The default value is 1.
AVERAGE_NUMBER_EXTENDED_DATA_ELEMENT_PER_EVENT=number
The average number of extended data elements per event instance. Changes to this value significantly affect the amount of storage allocated for the table spaces that store extended data element data. The default value is 5.
AVERAGE_NUMBER_EXTENDED_DATA_ELEMENT_ARRAY_ELEMENTS=number
The average number of values for extended data elements that are array data types. The default value is 5.
AVERAGE_NUMBER_MSG_TOKENS_PER_EVENT=number
The average number of message tokens per event. The default value is 1.
AVERAGE_ASSOCIATIONS_PER_EVENT=number
The average number of event associations per event. The default value is 2.
TABLESPACE_EXTENDED_BINARY_VALUE_PRIMARY=size
The primary allocation for the large object (LOB) table space that contains hexBinary extended data element values. This allocation can be small if events do not typically contain hexBinary extended data element values. The default value is 1000.
TABLESPACE_EXTENDED_BINARY_VALUE_SECONDARY=size
The secondary allocation for the large object (LOB) table space that contains hexBinary extended data element values. This allocation can be small if events do not typically contain hexBinary extended data element values. The default value is 200.
TABLESPACE_ANY_VALUE_PRIMARY=size
The primary allocation for the large object (LOB) table space that contains the values for the any element, which is a character large object (CLOB). This allocation can be small if events do not typically contain any elements. The default value is 1000.
TABLESPACE_ANY_VALUE_SECONDARY=size
The secondary allocation for the large object (LOB) table space that contains the values for the any element, which is a character large object (CLOB). This allocation can be small if events do not typically contain any elements. The default value is 200.
PERCENTAGE_FREE_SPACE=percent
The amount of free space, as a percentage, to leave on each page. Increase this value as the number of inserted rows increases. Free space makes updates more efficient, but a larger value uses more disk space. The default value is 20.
FREE_PAGE=pages
The number of pages to fill before leaving a free page. If this parameter is set to 0, free pages are not left. Set this parameter to a nonzero value if a large amount of SQL INSERT processing is expected. (A nonzero value uses more disk space.) The default value is 10.
NUMBER_EVENT_DEFINITIONS=definitions
The number of event definitions stored in the event catalog. The default value is 100.
AVERAGE_SOURCE_CATEGORY_PER_EVENT_DEFINITION=categories
The average number of source categories per event definition in the event catalog. The default value is 1.
AVERAGE_EXTENDED_DATA_ELEMENT_PER_EVENT_DEFINITION=definitions
The average number of extended data element descriptions for each event definition in the event catalog. The default value is 5.
AVERAGE_PROPERTY_DESCRIPTIONS_PER_EVENT_DEFINITION=definitions
The average number of property descriptions for each event definition in the event catalog. The default value is 5.
TABLESPACE_HEX_DEFAULT_PRIMARY=size
The primary allocation for the large object (LOB) table space that contains the default values for hexBinary extended data elements. The default value is 100.
TABLESPACE_HEX_DEFAULT_SECONDARY=size
The secondary allocation for the large object (LOB) table space that contains the default values for hexBinary extended data elements. The default value is 10.

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\tcei_install_zOSResponseFile.html

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