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.