IBM Business Process Manager, V8.0.1, All platforms > Reference > Commands and scripts > Commands (wsadmin scripting)

configEventServiceDB2ZOSDB command

Use the configEventServiceDB2ZOSDB command to configure the Common Event Infrastructure using a DB2 for z/OS database.

Purpose

The configEventServiceDB2ZOSDB command is a Common Event Infrastructure administrative command, which is available for the AdminTask object. Use this command to create the event service database and data sources for DB2 z/OS on a server or cluster. For more information about the AdminTask object, see the WebSphere Application Server Information Center.

The product uses a Jython version that does not support Microsoft Windows 2003, Windows Vista, or Windows 7 operating systems.

Parameters

- createDB

The command generates the DDL database scripts and creates the database when this parameter is set to true. The command only generates the DDL database scripts when this parameter is set to false. To create the database, the current server must be already configured to run the database commands. The default value is false if not specified.

- overrideDataSource

When this parameter is set to true, the command removes any existing event service data source at the specified scope before creating a new one. When this parameter is set to false, the command does not create an event service data source at the specified scope if another event service data source is found at the same scope. The default value is false if not specified.

- nodeName

The name of the node that contains the server where the event service data source should be created. If this parameter is specified, then the serverName parameter must be set. You must not specify this parameter if the clusterName parameter is specified.

- serverName

The name of the server where the event service data source should be created. If this parameter is specified without the nodeName parameter, the command will use the node name of the current WebSphere profile. You must not specify this parameter if the clusterName parameter is specified.

- clusterName

The name of the cluster where the event service data source should be created. If this parameter is specified, then the serverName and nodeName parameters must not be set. You must not specify this parameter if the serverName and nodeName parameters are specified.

- jdbcClassPath

The path to the JDBC driver. Specify only the path to the driver file; do not include the file name in the path. This parameter is required.

- dbHostName

The host name of the server where the database is installed. This parameter is required.

- dbPort

The DB2 for z/OS instance port. The default value is 5027 if not specified.

- dbAliasName

The name of the cataloged database on the DB2 client workstation. This parameter is required when the -createDB parameter is set to true.

- dbSubSystemName

The DB2 subsystem name. This parameter is required.

- eventDBName

The event database name to be created. The default value is event if not specified .

- eventCatalogDBName

The event catalog database to be created. The default value is eventcat if not specified.

- dbDiskSizeInMB

The disk size in MB for the event service database. This value must be at least 10 MB. The default value is 100 MB if not specified.

- dbUser

The DB2 user ID that has privileges to create and drop the databases. This parameter is required.

- dbPassword

The password of the database user ID. This parameter is required.

- storageGroup

The storage group for the event database and the event catalog database. The storage group must already be created and active.

- bufferPool4K

The name of the 4K buffer pool. This buffer pool must be active before the database DDL scripts can be run.

- bufferPool8K

The name of the 8K buffer pool. This buffer pool must be active before the database DDL scripts can be run.

- bufferPool16K

The name of the 16K buffer pool. This buffer pool must be active before the database DDL scripts can be run.

- outputScriptDir

An optional database script output directory. When this parameter is specified, the command generates the event service database scripts in the specified directory. If the specified directory does not contain a full path, the command creates the specified directory in profile_root/bin. The default database script output directory is profile_root/databases/event/node/server/dbscripts/db2zos if this parameter is not specified.

- jdbcDriverVersion

The JDBC driver version.

Sample

Batch mode example usage:

$AdminTask configEventServiceDB2ZOSDB {-clusterName Test2Cluster -jdbcClassPath /usr/lpp/db2v10/jdbc/classes -dbUser wsadmin -dbPassword admn4was -dbHostName server.site.ibm.com -dbPort 30200 -dbSubSystemName DSNM10DD -storageGroup T5DBSTO -eventDBName T5CELLDB -eventCatalogDBName T5CELLDB -bufferPool4K BP1 -bufferPool8K BP8K0 -bufferPool16K BP16K0 -outputScriptDir /u/healdr/CEIDDL}

Interactive mode example usage:

$AdminTask configEventServiceDB2ZOSDB -interactive

Sample

Batch mode example usage:

• Use Jacl:

  $AdminTask configEventServiceDB2ZOSDB {-createDB true -overrideDataSource true
   -nodeName nodename -serverName servername -jdbcClassPath c:\sqllib\java
   -dbUser db2user -dbPassword dbpassword -dbHostName host_name -dbPort 5027
   -storageGroup sysdeflt -bufferPool4K BP9 -bufferPool8K BP8K9
   -bufferPool16K BP16K9}
  

• Use Jython string:

  AdminTask.configEventServiceDB2ZOSDB('[-createDB true -overrideDataSource true
   -nodeName nodename -serverName servername -jdbcClassPath c:\sqllib\java
   -dbUser db2user -dbPassword dbpassword -dbHostName host_name -dbPort 5027
   -storageGroup sysdeflt -bufferPool4K BP9 -bufferPool8K BP8K9
   -bufferPool16K BP16K9]')
  

• Use Jython list:

  AdminTask.configEventServiceDB2ZOSDB(['-createDB', 'true', '-overrideDataSource',  'true', '-nodeName', 'nodename', '-serverName', 'servername', '-jdbcClassPath',  'c:\sqllib\java', '-dbUser', 'db2user', '-dbPassword', 'dbpassword',  '-dbHostName', 'host_name', '-dbPort', '5027', '-storageGroup', 'sysdeflt',  '-bufferPool4K', 'BP9', '-bufferPool8K', 'BP8K9', '-bufferPool16K', 'BP16K9'])
  

Interactive mode example usage:

• Use Jacl:

  $AdminTask configEventServiceDB2ZOSDB -interactive
  

• Use Jython string:

  AdminTask.configEventServiceDB2ZOSDB('[-interactive]')
  

• Use Jython list:

  AdminTask.configEventServiceDB2ZOSDB ['-interactive'])
  

Parent topic: Commands (wsadmin scripting)

Related information:

Obtaining online help using wsadmin scripting
Administrative command invocation syntax using wsadmin scripting
Use the wsadmin scripting tool
Jython script library