Drop Database Components
Before dropping, shut down all products that are connected to the database component and back up the database component.
You cannot drop the Component Tracker database component using the configurator; you must use a script. For instructions, see
Use the Database Scripts.
This command drops the latest ProcessAudit and ProcessEngine database components from Oracle:
dbConfigurator -a drop -d oracle -c processaudit,processengine -v latest
-l jdbc:wm:oracle://myserver:1521;serviceName=myservicename -u webmuser
-p w3bmpass
This command drops the latest versions of all database components from SQL Server:
dbConfigurator.bat -a drop -d sqlserver -c core -v latest
-l jdbc:wm:sqlserver://myserver:1433;databaseName=webmdb -u webmuser -p w3bmpass
The command drops the latest version of the Analysis database component from DB2 for LUW:
dbConfigurator.bat -a drop -d db2luw -c analysis -v latest
-l jdbc:wm:db2://DBserver:50000;databaseName=webmdb -u webmuser -p w3bmpass
This command drops the latest version of the Analysis database component from DB2 when dropping from ALTSCHEMA rather than the default schema for the specified database user:
dbConfigurator.bat -a drop -d db2luw -c analysis -v latest
-l jdbc:wm:db2://DBserver:50000;databaseName=webmdb;AlternateId=ALTSCHEMA
;"InitializationString=(SET CURRENT PATH=current_path,ALTSCHEMA)" -u webmuser
-p w3bmpass