Implementing Siebel Business Applications on DB2 UDB for z/OS > Configuring the Database Layout > About 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:
- 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).
- 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 do not edit the Group property for tables provided in the Siebel application; doing so can cause operating anomalies in the application.
- 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
In release 8.0 of Siebel Business Applications, the value of the CURRENT RULES special register is set to STD, which causes DB2 to execute SQL statements in accordance with the rules of the SQL standard. As a result, DB2 implicitly creates auxiliary objects and assigns names to them. For information on the naming conventions used by DB2 when creating auxiliary objects, refer to the IBM DB2 for z/OS V8 documentation. Naming Conventions for Partitioning Triggers
Partitioning Trigger names comprise eight characters (for example, PTH0401) that consist of three elements in the following order:
- The leading two letters must be PT, to designate that this is a partitioning trigger.
- 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.
- 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.
|