After setup, it is necessary to manually create database tables required for the Service Integration Bus. WebSphere Application Server for z/OS 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.sh -system system -platform platform -schema username -database database_name -user username -statementend ; -create
Where
For example:
$WAS_HOME/bin/sibDDLGenerator.sh -system db2 -platform zos -schema db2admin -database curam -user db2admin -statementend ; -create
This command will output SQL statements to define the Service Integration Bus tables and these SQL statements must be executed on the target database.