Use the configEventServiceDB2iSeriesDB command
to configure the Common Event Infrastructure using a DB2® for iSeries® database.
Purpose
The
configEventServiceDB2iSeriesDB command
is a
Common Event Infrastructure administrative
command is available for the AdminTask object. Use it to generate
the DDL database scripts for use on remote database servers, create
the event service database for DB2 iSeries on a local server, and
creates data sources on a server or cluster. For more information
about the AdminTask object, refer to the
WebSphere® Application Server
Network Deployment, version 6.1 documentation.
Note: The product uses a Jython version that does not support Microsoft® Windows® 2003 or Windows Vista 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 parameters 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.
- - toolboxJdbcClassPath
- The path to the IBM® Toolbox for Java™ DB2 JDBC driver. Specify only the
path to the driver file; do not include the file name. You must specify
either this parameter or the jdbcClassPath parameter.
Note: You
must specify toolboxJdbcClassPath path if you
are creating the database on an iSeries server.
- - nativeJdbcClassPath
- The path to the DB2 for iSeries native JDBC driver.
Specify only the path to the driver file; do not include the file
name in the path. You must specify either this parameter or the toolboxJdbcClassPath parameter.
Note: You
must specify the nativeJdbcClassPath if you are
using an iSeries server
to create the database on a non-iSeries server. Specify the DB2 Universal Driver if you are
creating the database on DB2 Universal Database™ for
multiplatforms or DB2
Universal Database for z/OS®.
Specify a type 4 driver if you are creating the database on Informix®, Oracle, or Microsoft SQL Server.
- - dbHostName
- The host name of the server where the DB2 for iSeries database
server is installed. This parameter is required if you are using the IBM Toolbox for Java DB2 JDBC
driver.
- - dbName
- The DB2 for iSeries database name. The default value
is *LOCAL if not specified.
- - collection
- DB2 for iSeries library SQL collection. The maximum
length for the collection name is 10 characters. The default value
is an empty string if not specified.
- - dbUser
- DB2 user ID that has privileges
to create and drop the databases. This parameter is required.
- - dbPassword
- Password of the database user ID. This parameter is required.
- - outputScriptDir
- 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/db2iseries
if this parameter is not specified.
Sample
Batch mode example usage:
Using Jacl:
$AdminTask configEventServiceDB2iSeriesDB {createDB true
-overrideDataSource true
-nodeName nodename
-serverName servername
-dbUser db2user
-dbPassword dbpassword
-nativeJdbcClassPath /myDB2ClassPath
-collection event}
Using Jython string:
AdminTask.configEventServiceDB2iSeriesDB('[-createDB true
-overrideDataSource true
-nodeName nodename
-serverName servername
-nativeJdbcClassPath /myDB2ClassPath
-collection event]')
Using Jython list:
AdminTask.configEventServiceDB2iSeriesDB(['-createDB', 'true',
'-overrideDataSource', 'true',
'-nodeName', 'nodename',
'-serverName', 'servername',
'-nativeJdbcClassPath', '/myDB2ClassPath',
'-collection', 'event'])
Interactive mode example usage:
Using Jacl:
$AdminTask configEventServiceDB2iSeriesDB -interactive
Using Jython string:
AdminTask.configEventServiceDB2iSeriesDB('[-interactive]')
Using Jython list:
AdminTask.configEventServiceDB2iSeriesDB(['-interactive'])