Bookshelf v7.5: About Creating or Modifying the Database Layout

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > 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. 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 1 because it only requires use of customary DB2 tools. This method does not require manipulation of the storage control file.

Method 2. 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 (see 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.

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.