Use this task to enable your database administrator to create the
tables for the messaging engine data store.
Before you use this task, decide whether you want your database administrator
to create the tables.
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:
- At a command prompt, issue the sibDDLGenerator command
and redirect the output to a file. Refer to The 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.