Drop Database Components
Before dropping, shut down all products that are connected to the database component and back up the database component.
The command drops the latest version of the Analysis database component from DB2:
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
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
This command drops the latest ProcessAudit and ProcessEngine database components from Tibero:
dbConfigurator -a drop -d tibero -c processaudit,processengine -v latest
-l jjdbc:tibero:thin:@DBServer:8629:mydbname -u webmuser
-p w3bmpass