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

About Table Space Naming Conventions

The table space naming convention applies to all Siebel tables, whether you created the tables or the tables were shipped as part of your Siebel eBusiness Application.

Table spaces are named with eight characters (for example, H0401000) that consist 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. The four-digit number that was assigned to the base table and is stored in GROUP_CD column of S_TABLE table in 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 the table number is stored in the Group Code column (GROUP_CD) in S_TABLE. Table and Group names can be viewed in Siebel Tools under Table > Object.

   NOTE:  The Group property for tables is editable for those tables created by you. You should not edit Group for the tables provided in the Siebel application.

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

CAUTION:  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. This maintains object naming conventions, and prevents custom objects from being created with random names.

About Naming Conventions for Auxiliary Object

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

Auxiliary objects are named with 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	X	A	I
   SIA 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.)

About Partitioning Triggers

Partitioning Triggers are named with 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.