Implementing Siebel Business Applications on DB2 UDB for z/OS > Configuring the Database Layout > Siebel Objects >

Table Space Naming Conventions

The table space naming convention applies to all Siebel table spaces, whether you create the table spaces or the table spaces are shipped as part of your Siebel Business Application.

Table spaces are named with eight characters (for example, H0401000), consisting of three elements in the following order:

1. A leading letter (H, V, or S) designates the product group that the table belongs to.
   • H represents Horizontal (also known as Core).
   • V represents Vertical (also known as Siebel Industry Applications or SIA).
   • S represents your custom tables and auxiliary indexes (those that you create for the Siebel application).
2. A four-digit number that is assigned to the base table and is stored in the GROUP_CD column of the S_TABLE table in the Siebel Repository, for example, 0401. (This number cascades down to table spaces, auxiliary tables, and auxiliary indexes.)

   Table names are stored in the repository table S_TABLE, and table numbers are stored in the Group Code column (GROUP_CD) in S_TABLE. You can view Table and Group names in Siebel Tools under Table > Object.

   CAUTION:  You can edit the Group property for tables you create but you should not edit the Group property for tables provided in the Siebel application; doing so can cause operating anomalies in the application.

3. The ending three-digit number which is always 000 for table spaces on the database storage layout.

NOTE:  When you create new custom tables and auxiliary indexes, use the prefix S, follow it with a unique four-digit number greater than 6000, then end with the three-zero suffix (000), for example, S6001000. Using this prefix and suffix maintains object naming conventions.

Naming Conventions for Auxiliary Objects

When naming auxiliary objects, such as character large objects (CLOBs), you must follow a naming convention that provides space for the auxiliary table, table space, and index for each partition of a partitioned CLOB.

Auxiliary object names comprise eight characters (for example, A0401000) that consist of three elements in the following order:

1. A leading letter designates the product group that the table belongs to. Use the following matrix to determine which prefix to use.

   	Tables	Table Spaces	Table Indexes
   Horizontal (H)	X	A	I
   SIA (V) and Custom (S)	Y	B	J
   Default Group Names Assigned to Objects with No Leading S	Z	C	K
2. A four-digit number that uniquely identifies the table space, for example, 0401.

   NOTE:  Default numbering of auxiliary objects starts from 0001.

3. The ending three-digit number must be all zeros: 000. (Every name ends in 000.)

Naming Conventions for Partitioning Triggers

Partitioning Trigger names comprise eight characters (for example, PTH0401) that consist of three elements in the following order:

1. The leading two letters must be PT, to designate that this is a partitioning trigger.
2. The third letter (H, V, or S) designates the product group or component that the trigger belongs to.
   • H represents Horizontal (also known as Core).
   • V represents Vertical (also known as Siebel Industry Applications or SIA).
   • S represents partitioning triggers used for Assignment Manager or other components.
3. The ending four-digit number uniquely identifies the trigger based on the table number, for example, 0401.

   The trigger name is normally related to a corresponding table space name; for example, the trigger name PTH0401 relates to the table space name H0401000.