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

Databases


Siebel eBusiness Applications ship with up to 24 databases. The number of databases you receive depends on which modules your organization purchased. You can regroup databases or add new databases, as required for your enterprise.

The following example illustrates what a Database object looks like in the storage control file.

[Object 4]
Type = Database
Name = SIEBDB01
LockSize = Page

The Database object illustrated above translates into the following DDL output:

CREATE DATABASE SIEBDB01 CCSID ASCII BUFFERPOOL BP1 /

In Siebel eBusiness Applications, CCSID is defined on the database level only. CCSID is always taken from the Defaults object.

There is no LockSize used in the CREATE DATABASE statement, because LockSize is a default value for all table spaces that belong to a given database.

The names of databases in storage control files are comprised of two parts. The first part of the name is a variable, $DbnamePrefix. The second part of the name is a two-digit number. You can substitute the database name prefix with a literal value up to six characters long (for example, SIEBDB) that conforms to your organization's naming convention. You can change the value of the database name prefix either during the installation process or by changing it in the storage control file.

The following example illustrates database numbering for certain common databases. It is normal for a gap to exist in database numbering, because the sequence and number of databases you receive depend on the Siebel application that you are implementing.

00 - Default
12 - Siebel Seed Tables
15 - DOCKING Tables
16 - Siebel Repository
17 - EIM
18 - Data Warehouse
19 - 22 Verticals


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003