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.
Note: 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:
Using Jacl:
$AdminTask removeEventServiceSQLServerDB {-removeDB true -nodeName nodename
-serverName servername -dbUser ceiuser -saUser sa -saPassword sapassword
-dbServerName sqlservername}
Using Jython string:
AdminTask.removeEventServiceSQLServerDB('[-removeDB true -nodeName nodename
-serverName servername -dbUser ceiuser -saUser sa -saPassword sapassword
-dbServerName sqlservername]')
Using Jython list:
AdminTask.removeEventServiceSQLServerDB(['-removeDB', 'true', '-nodeName',
'nodename', '-serverName', 'servername', '-dbUser', 'ceiuser', '-saUser','sa',
'-saPassword', 'sapassword', '-dbServerName', 'sqlservername'])
Interactive mode example usage:
Using Jacl:
$AdminTask removeEventServiceSQLServerDB -interactive
Using Jython string:
AdminTask.removeEventServiceSQLServerDB('[-interactive]')
Using Jython list:
AdminTask.removeEventServiceSQLServerDB(['-interactive'])