Generating the DDL statements needed to create data store tables manually

 

Overview

To enable the database administrator to create the data store tables manually, generate data definition language (DDL) statements.

Before you start this task, review the information in Plan the configuration of a messaging engine to use a data store, and ensure that the database administrator has taken any appropriate action.

Use sibDDLGenerator to generate the DDL statements that the database administrator needs to create the tables for the messaging engine data store.

 

Generate DDL

1. At a command prompt, issue the sibDDLGenerator command and redirect the output to a file. To process the DDL statements with a command line processor that requires the statements to conform to a specific format, use the optional parameters that control the format of the DDL statements.

   For example, if each statement must end with a semicolon, use...

   -statementend ;

2. Send the output file to the database administrator to process the DDL statements that are generated. The DDL statements can be ported across operating systems, for example, we can generate the DDL statements on a machine running the Windows operating system and then run them on a machine running the z/OS operating system.

   • Your database administrator can modify the DDL statements, but must not modify the table names or the column names in any way because doing so might prevent the messaging engine from starting.

   • If the DDL statements are to be run on the z/OS operating system, the database administrator must change the VCAT name in the first line of the DDL statements (the create storage group statement) to a valid high-level qualifier for their system.

Last updated Dec 15, 2010 8:14:22 PM CST