To enable your database administrator to create the data store
tables manually, you must generate data definition language (DDL) statements.
About this task
Use the sibDDLGenerator command to generate the
DDL statements that the database administrator needs 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 end 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.
The DDL statements can be processed by using
SPUFI.
Attention:
- 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, 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.