Use the configEventServiceSQLServerDB command
to configure the Common Event Infrastructure (CEI) using a SQL Server
database.
Purpose
The
configEventServiceSQLServerDB command
is a CEI administrative command that is available for the AdminTask
object. Use this command to create the event service database and
data sources for SQL Server on a server or cluster.
For more information
about the AdminTask object, see the WebSphere Application Server documentation.
Note: 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 generates only 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
- 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.
If
this parameter is not specified, the database script output directory
is profile_root/databases/event/node/server/dbscripts/dbtype.
- - nodeName
- The name of the node that contains the server where the event
service data source should be created. If this parameter is specified,
the serverName parameter must be set.
Do 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.
Do 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, the serverName and nodeName parameters
must not be set.
Do not specify this parameter if the serverName and nodeName parameters
are specified.
- - dbServerName
- The server name of the SQL Server database. This parameter must
be set when the parameter createDB is set to true.
- - dbHostName
- The host name of the server where the SQL Server database is running.
- - dbPort
- SQL Server port. The default value is 1433 if not specified.
- - dbName
- The database name to be created. The default value is event if
not specified.
- - dbUser
- The SQL Server user ID that will own the event service tables.
The default value is ceiuser if not specified.
- - dbPassword
- The password of the SQL Server user ID specified by the dbUser parameter.
This parameter is required.
- - saUser
- User ID that has privileges to create and drop databases and users.
This parameter is required when the createDB parameter
is set to true. The default value is sa if
not specified.
- - saPassword
- The sa password. You must not specify this parameter if the sa
user ID does not have a password.
- - ceiInstancePrefix
- The command uses the event service instance name to group the
database files in a directory with unique names. The default value
is ceiinst1 if not specified.
- - 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.
If
this parameter is not specified, the database script output directory
is profile_root/databases/event/node/server/dbscripts/sqlserver.
- - jdbcDriverVersion
- Specifies the version of the Microsoft JDBC driver to use, which
can be one of the following values:
- 1.2, which configures CEI to use the Microsoft
SQL Server JDBC 1.2 driver (sqljdbc.jar). This is the default value.
- 2.0, which configures CEI to use the Microsoft
SQL Server JDBC 2.0 driver (sqljdbc4.jar).
- 3.0, which configures CEI to use the Microsoft
SQL Server JDBC 3.0 driver (sqljdbc4.jar)
This parameter is valid only if you are using the Microsoft JDBC
driver.
Sample
Batch mode example usage:
Using Jacl:
$AdminTask configEventServiceSQLServerDB {-createDB true
-overrideDataSource true
-nodeName nodename
-serverName servername
-dbUser ceiuser
-dbPassword ceipassword
-dbServerName sqlservername
-dbHostName host_name
-dbPort 1433
-saUser sa
-saPassword sapassword
-jdbcDriverVersion 3.0}
Using Jython string:
AdminTask.configEventServiceSQLServerDB('[-createDB true
-overrideDataSource true
-nodeName nodename
-serverName servername
-dbUser ceiuser
-dbPassword ceipassword
-dbServerName sqlservername
-dbHostName host_name
-dbPort 1433
-saUser sa
-saPassword sapassword
-jdbcDriverVersion 3.0]')
Using Jython list:
AdminTask.configEventServiceSQLServerDB(['-createDB', 'true',
'-overrideDataSource', 'true',
'-nodeName', 'nodename',
'-serverName', 'servername',
'-dbUser', 'ceiuser'
'-dbPassword', 'ceipassword',
'-dbServerName', 'sqlservername',
'-dbHostName', 'host_name',
'-dbPort', '1433',
'-saUser', 'sa',
'-saPassword', 'sapassword',
'-jdbcDriverVersion', '3.0'])
Interactive mode example usage:
Using Jacl:
$AdminTask configEventServiceSQLServerDB -interactive
Using Jython string:
AdminTask.configEventServiceSQLServerDB('[-interactive]')
Using Jython list:
AdminTask.configEventServiceSQLServerDB(['-interactive'])