Service Integration Bus Database Tables

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

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

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.