WebSphere

configEventServiceSQLServerDB command

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.
Icon indicating Vista platform 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:

Interactive mode example usage:


reference Reference topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/rcei_configeventservicesqlserverdb.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).