Create Database Components
This command displays the database components that currently exist in DB2:
dbConfigurator.bat -a catalog -d db2luw
-l jdbc:wm:db2://DBserver:50000;databaseName=webmdb -u webmuser -p w3bmpass
This command creates the latest ProcessAudit and ProcessEngine database components in DB2 when creating in ALTSCHEMA rather than the default schema for the specified database user:
dbConfigurator.bat -a create -d db2luw -c processaudit,processengine -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 creates the latest versions of the ProcessAudit and ProcessEngine database components in Oracle:
dbConfigurator.bat -a create -d oracle -c processaudit,processengine -v latest
-l jdbc:wm:oracle://DBserver:1521;serviceName=myservicename
-u webmuser -p w3bmpass
This command creates the latest Trading Networks database components in PostgreSQL:
dbConfigurator.bat -a create -d pgsql -pr TN -v latest
-l jdbc:wm:postgresql://vmblrdb-4:5432;databaseName=dccpgdb
-u postgres –p manage
This command recreates (drops and then creates) the latest versions of the ProcessAudit and ProcessEngine database components in SQL Server:
dbConfigurator.bat -a recreate -d sqlserver -c processaudit,processengine -v latest
-l jdbc:wm:sqlserver://DBserver:1433;databaseName=webmdb -u webmuser -p w3bmpass
This command creates the latest versions of the ProcessAudit and ProcessEngine database components in Tibero:
dbConfigurator.bat -a create -d tibero -c processaudit,processengine -v latest
-l jdbc:tibero:thin:@DBServer:8629:mydbname
-u webmuser -p w3bmpass