Use this task to enable your
database administrator to create the tables for the messaging engine
data store.Learn about how to create
the tables for the messaging engine data store manually.
About this task
Use the sibDDLGenerator command to generate
the DDL statements that the database administrator will need to create
the tables for the messaging engine data store:
Procedure
- At a command prompt, issue the sibDDLGenerator command
and redirect the output to a file. Refer to sibDDLGenerator command for a description of the sibDDLGenerator command.
Important: If you want 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 be terminated
with a semicolon, use -statementend ;
- Send the output file to your database administrator to
process the DDL statements that are generated. The DDL statements
can be ported across operating systems, for example you 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.
Attention:
- Your database administrator can modify the DDL statements, but must
not modify the table names or the column names in any way. Doing
so might cause the messaging engine to fail to start.
- If the DDL statements are to be run on the z/OS operating system, your 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.