After setup, it is necessary to manually create database tables required for the Service Integration Bus. WebSphere Application Server provides a utility to generate the SQL for creating these tables, the SIB DDL Generator.
The generator can be run by executing the following command:
WAS_HOME /bin/sibDDLGenerator.bat -system system -platform platform -schema username -database database_name -user username -statementend ; -create
Where
For example:
c:/Websphere/AppServer/bin/sibDDLGenerator.bat -system db2 -platform windows -schema db2admin -database curam -user db2admin -statementend ; -create
This command will output some SQL statements and this output should then be executed on the target database.