Use the configEventServiceSQLServerDB command
to configure the Common Event Infrastructure using a SQL Server database.
Purpose
The
configEventServiceSQLServerDB command
is a
Common Event Infrastructure administrative
command 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
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
- 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/dbtype if
this parameter is 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.
- - 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.
The default database script output directory is profile_root/databases/event/node/server/dbscripts/sqlserver
if this parameter is not specified.
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}
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]')
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'])
Interactive mode example usage:
Using Jacl:
$AdminTask configEventServiceSQLServerDB -interactive
Using Jython string:
AdminTask.configEventServiceSQLServerDB('[-interactive]')
Using Jython list:
AdminTask.configEventServiceSQLServerDB(['-interactive'])