WebSphere WebSphere Application Server Version 6.1.x Feature Pack for Web Services Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

Enabling your database administrator to create the data store tables

Before you begin
Before you use this task, review the information in Planning the configuration of a messaging engine to use a data store, and ensure that your database administrator has taken any appropriate action.
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

  1. 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 ;

    For i5/OS platforms To access the i5/OS command line, or run an i5/OS command line program, use the STRQSH command to launch a Qshell session. For more information, see the topic "Configure Qshell to run WebSphere Application Server scripts".

  2. 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.

    For z/OS platforms The DDL statements can be processed 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. 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.
Related reference
The sibDDLGenerator command
Data store tables

Task topic

Terms of use | Feedback


Timestamp icon Last updated: 27 November 2008
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.pmc.wsfep.multiplatform.doc/tasks/tjm0100_.html

Copyright IBM Corporation 2004, 2008. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)