Create Database Components

Command Syntax

To create a database component:

sagcc exec administration product local DatabaseComponentConfigurator  
database create 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 create the database components for a product:

sagcc exec administration product local DatabaseComponentConfigurator  
database create 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

Usage Notes

The value of the version parameter for database components is specific for each component. IBM recommends that you specify version=latest to create the latest version of a database component.

The value of the version parameter for a product is the four number sequence of the product release version, for example 9.10.0.0. You can also specify latest as the version value in a product command, in which case the configurator will create database components for the latest release version of the product.

Examples

To create 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 create 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 create 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”, and for the database user “webmuser” with password “webmpass”:
```
sagcc exec administration product local DatabaseComponentConfigurator  
database create 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”
```