Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Configuring the Database Layout >

About Creating or Modifying the Database Layout

There are two methods by which you can modify the database storage layout for your deployment:

  • Method 1. Adjust the Storage Control File to Reflect Your Database Layout. Adjust the object definitions and options in the storage control file to reflect your database storage layout. When you subsequently perform a customized database installation (Performing a Custom Installation) or when you use database utilities, select your new storage control file when you are prompted for the storage control file input parameter. The resulting output file, schema.sql, contains the DDL that reflects your modifications.

    If this method is used, it will be necessary to generate an updated version of the storage.ctl file before running any of the database configuration utilities that require this file as input, for example, Synchronize Schema Definition (ddlsync) and Migrate Repository (dev2prod) database configuration utilities.

    An updated version of the storage.ctl file can be generated by selecting Run Database Utilities > Configure Database > Extract Storage Control File option in the Siebel Software Configuration Utility - DB Server Configuration wizard (dbsrvr_config.ksh in UNIX).

  • Method 2. Modify Generated DDL Using DB2 Tools. Perform a standard installation (see Performing a Standard Installation), and choose the installation mechanism Generate DDL into Files. After the Siebel Upgrade Wizard generates the DDL (to a file named schema.sql), your DBA can directly edit the output DDL using native DB2 tools.

    Some DBAs prefer using Method 2 because it only requires use of customary DB2 tools. This method does not require manipulation of the storage control file.

    The storage control file should then be extracted to keep this in line with what is on the mainframe. This will save you time as there will be less manual work needed when running database utilities such as dev2prod.

You can use either of the following approaches to adjust the storage control file:

  • Open the storage control file with a text editor program and edit the storage control file directly to adjust object definitions or options. This approach is useful for making minor adjustments to the database layout.

    CAUTION:  Do not use a text editor to edit the storage control file unless you have a thorough understanding of the storage control file structure.

  • Use a Siebel-provided tool called the Siebel Database Storage Configurator (dbconf.xls) to view and edit storage control files and templates. This approach provides flexibility and ease of customization to DBAs who are customizing and managing Siebel DB2 object definitions. For more information about this tool, see About the Siebel Database Storage Configurator.

    NOTE:  If your installation is in UNIX, you must transfer dbconf.xls and the storage control file that you want to configure to your Microsoft Windows environment. Use BINARY FTP to transfer the dbconf.xls file.

Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390