Command Central 10.11 | Using the Command Line Interface | Managing Database Components Using CLI Commands | Drop Database Components
 
Drop Database Components
Command Syntax
*To drop a database component:
sagcc exec administration product local DatabaseComponentConfigurator 
database drop db.type=db_type component=componentID version=db_version 
db.username=db_username db.password=db_password db.name=db_name 
db.url=db_url db.admin.username=db_admin_username 
db.admin.password=db_admin_password 
db.tablespace.dir=db_tablespace_dir 
db.tablespace.data=data_tablespace_name 
db.tablespace.index=index_tablespace_name
*To drop the database components for a product:
sagcc exec administration product local DatabaseComponentConfigurator 
database drop db.type=db_type product=productID 
version=db_version db.username=db_username 
db.password=db_password db.name=db_name db.url=db_url 
db.admin.username=db_admin_username db.admin.password=db_admin_password
Examples
*To drop a database component in the local Platform Manager installation for the component with code “STR” and version “latest”, on the SQL server at URL “jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB”, for the database user “webmuser” with password “webmpass”, and the specified operating system administrator:
sagcc exec administration product local DatabaseComponentConfigurator 
database drop db.type=sqlserver component=STR 
version=latest db.username=webmuser 
db.password=webmpass db.name=TESTDB 
db.url=“jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB” 
db.admin.username=adminuser db.admin.password=adminpass
*To drop a database with name “TESTDB” in the local Platform Manager installation for the product with ID “IS” and version “9.10.0.0”, on the SQL server at URL “jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB”, for the database user “webmuser” with password “webmpass”, and the specified operating system administrator:
sagcc exec administration product local DatabaseComponentConfigurator 
database drop db.type=sqlserver product=IS 
version=9.10.0.0 db.username=webmuser 
db.password=webmpass db.name=TESTDB 
db.url=“jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB”
db.admin.username=adminuser db.admin.password=adminpass