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

configEventServiceSQLServerDB command

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.

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:

• Use 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}
  

• Use 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]')
  

• Use 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:

• Use Jacl:

  $AdminTask configEventServiceSQLServerDB -interactive
  

• Use Jython string:

  AdminTask.configEventServiceSQLServerDB('[-interactive]')
  

• Use Jython list:

  AdminTask.configEventServiceSQLServerDB(['-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