Installer 10.15 | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products On Premises | Installing Products, Creating Database Components, and Connecting Products to Database Components | Installing Products Using Software AG Installer and Creating Database Components Using Database Component Configurator | Create Database Components Using Database Component Configurator | Examples | Drop the Storage and Revoke Database User Permissions
 
Drop the Storage and Revoke Database User Permissions
If you drop all database components in a schema, you can drop the storage and revoke the database user permissions.
This command drops the buffer pool and tablespaces (default names), and revokes permissions for DB2:
dbConfigurator.bat -a drop -d db2luw -c storage -v latest
-l jdbc:wm:db2://vmxpdb01:50000;databaseName=amol -u webmuser -au adminuser
-ap admin_password -t tablespace_dir
This command drops the buffer pool and tablespaces (custom names), and revokes permissions for DB2:
dbConfigurator.bat -a drop -d db2luw -c storage -v latest
-l jdbc:wm:db2://vmxpdb01:50000;databaseName=amol -u webmuser -au adminuser
-ap admin_password -t tablespace_dir -tsdata MYDATA -tsindex MYINDEX
-tsblob MYBLOB -b MYBUFF
This command drops the two tablespaces (default names) for Oracle:
dbConfigurator.bat -a drop -d oracle -c storage -v latest
-l jdbc:wm:oracle://DBserver:1521;serviceName=myservicename -au adminuser
-ap adminpass -u webmuser -p w3bmpass -t tablespace_dir
This command drops the two tablespaces (custom names) for Oracle:
dbConfigurator.bat -a drop -d oracle -c storage -v latest
-l jdbc:wm:oracle://DBserver:1521;serviceName=myservicename -au adminuser
-ap adminpass -u webmuser -p w3bmpass -t tablespace_dir -tsdata MYDATA
-tsindex MYINDEX
This command drops the database for SQL Server:
dbConfigurator.bat -a drop -d sqlserver -c storage -v latest
-l jdbc:wm:sqlserver://DBserver:1433;databaseName=master -u webmuser
-p w3bmpass -au sa -ap sa_password -n webmdb
This command drops the two tablespaces (default names) for Tibero:
dbConfigurator.bat -a drop -d tibero -c storage -v latest
-l jdbc:tibero:thin:@DBServer:8629:mydbname -au adminuser
-ap adminpass -u webmuser -p w3bmpass -t tablespace_dir
This command drops the two tablespaces (custom names) for Tibero:
dbConfigurator.bat -a drop -d tibero -c storage -v latest
-l jdbc:tibero:thin:@DBServer:8629:mydbname -au adminuser
-ap adminpass -u webmuser -p w3bmpass -t tablespace_dir -tsdata MYDATA
-tsindex MYINDEX