Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Siebel Schema Installation on the DB2 Host > Creating and Executing the DDL >

Splitting the DDL

---

To split the DDL into multiple members in a PDS, you will use Rexx DDLSPLIT (filename ddlsplit.txt). The input files for REXX DDLSPLIT are the DDL files generated by the installation process. The output from ddlsplit are multiple members in a PDS.

DDLSPLIT creates the following members:

DB - Create database statements.
TS - Create table-space statements.
TB - Create table and index statements.
GRANT - All grant statements.

When you are ready to execute DDLSPLIT, use the following command:

TSO DDLSPLIT

If the REXX is not in a dataset allocated to sysproc or sysexec, then the entire dataset name must be specified; for example:

TSO EXEC 'SIEBEL.EXEC(DDLSPLIT)'

DDLSPLIT will prompt for the input dataset and the commit frequency. (The default commit frequency is 10.) It will remove the existing commit statement, and it will commit at the specified frequency. If no frequency is specified, it will default to one (1). The DDLSPLIT rexx exec process dynamically allocates the output partitioned dataset.

After you create the storage control file, you are ready to run the database installation to create the DDL.

Bookshelf Home | Contents | Index | Search | PDF