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

removeEventServiceSQLServerDB command

Use the removeEventServiceSQLServerDB command to remove the event service and, optionally, the associated SQL Server event database.

Purpose

The removeEventServiceSQLServerDB command is a Common Event Infrastructure administrative command is available for the AdminTask object. Use this command to remove the event service database and data sources for SQL Server from 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

- removeDB

The command removes the database when this parameter is set to true and does not remove the database when set to false. To remove the database, the current server must already configured to run the database commands.

- nodeName

The name of the node that contains the server where the event service data source should be removed. 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 removed. If this parameter 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 removed. 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 removeDB is set to true.

- dbUser

SQL Server user ID that owns the event service tables. The default value is ceiuser if not specified.

- saUser

User ID that has privileges to drop the databases and users. The default value is sa if not specified.

- saPassword

The password specified by the saUser parameter. This parameter is required when the parameter removeDB is set to true.

- dbScriptDir

The directory containing the database scripts generated by the event service database configuration command. If specified, the command will run the scripts in this directory to remove the event service database. The default database script output directory is profile_root/databases/event/node/server/dbscripts/sqlserver.

Sample

Batch mode example usage:

• Use Jacl:

  $AdminTask removeEventServiceSQLServerDB {-removeDB true -nodeName nodename
   -serverName servername -dbUser ceiuser -saUser sa -saPassword sapassword
   -dbServerName sqlservername}
  

• Use Jython string:

  AdminTask.removeEventServiceSQLServerDB('[-removeDB true -nodeName nodename
   -serverName servername -dbUser ceiuser -saUser sa -saPassword sapassword
   -dbServerName sqlservername]')
  

• Use Jython list:

  AdminTask.removeEventServiceSQLServerDB(['-removeDB', 'true', '-nodeName',  'nodename', '-serverName', 'servername', '-dbUser', 'ceiuser', '-saUser','sa',  '-saPassword', 'sapassword', '-dbServerName', 'sqlservername'])
  

Interactive mode example usage:

• Use Jacl:

  $AdminTask removeEventServiceSQLServerDB -interactive
  

• Use Jython string:

  AdminTask.removeEventServiceSQLServerDB('[-interactive]')
  

• Use Jython list:

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