Ddl2Pds.sh script

Syntax

Ddl2Pds.sh
   -Source <Directory containing source files>
   -PDS    <Target PDS name>
   -Component <Files to transfer WPS/BPC/BSP/BPS/BDW/file name/ALL>
   -Prefix <2-character PDS member name prefix> (default AA)
   -WorkDir <Work directory> (default /tmp)
   -ConvertCodepage <Convert codepage y/n> (default use file suffix)

Required parameters

<Component>

A specification of the DDL to copy over together with the name of a specific SQL file name ending in .ddl or .sql. The specification can be made by component or by individual file. For a component specification, only the DDL to create the databases is copied out. For the upgrade DDL, copy the files over individually.

This parameter requires one of the following values:

• WPS - Copy over all SQL files associated with creating the Common database.
• BPC - Copy over all SQL files associated with creating the Business Process Choreographer database.
• BSP - Copy over all SQL files associated with creating the Business Space database.
• BPS - Copy over all SQL files associated with creating the IBM® BPM Process Server database.
• BDW - Copy over all SQL files associated with creating the IBM BPM Performance Data Warehouse database.
• ALL - Copy over all files with a suffix of .ddl or .sql.
• file_name - Copy over a specific file with a suffix of .ddl or .sql.

<PDS>

A prefix to apply to the member names which are created in the PDS. The prefix has a maximum length of two characters. The default value is AA.

<Source directory>

The UNIX System Services file system directory containing the .sql and .ddl files to copy out.

Optional parameters

<Codepage conversion flag>

A flag to specify whether to convert the code page of the SQL files. A value of y specifies that an ASCII to EBCDIC conversion should be performed as the files are copied into the PDS. A value of n specifies that no code page conversion should occur. If no value is provided for this parameter, conversion is performed based on the suffix of the file:

• .ddl files are assumed to already be in EBCDIC and are not converted
• .sql files are assumed to be in ASCII and are converted

The default value is on suffix.

<Prefix>

Two-character PDS member name prefix. The default value is AA. This value is used to prefix the names of the PDS members that are created. The value of this parameter is arbitrary, so you can assign any meaning to it. For example, you might use it to indicate the component to which the PDS members belong; for example, CO for Common DB and BP for BPC. Alternatively, you might assign it the value of a two-character cell identifier.

<Work directory>

The location of a work directory in the UNIX System Services file system. This directory must exist. The default location is /tmp.

Function

Run the script in a UNIX System Services environment. The script displays the parameter values, then asks whether it is safe to proceed.

If the PDS does not exist, the script attempts to create it. If the PDS exists, the script prompts for confirmation that it can reuse the existing PDS. The script aborts if it cannot reuse an existing PDS.

As members are copied over, if an identically-named member is found to exist in the PDS, the script prompts you to confirm whether to overwrite the existing member. The file is skipped if the existing member cannot be overwritten.

Finally, the script creates a <Prefix> README member that contains a log of which SQL files were copied into the PDS.