Service Integration Bus Database Tables

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

• system is the database that is to be used, e.g. db2;
• platform is the operating system, e.g. zos;
• username is the username required for accessing the database;
• database_name is the name of the database to be used.

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.