Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Configuring the Database Layout > About Siebel Objects >
Object Naming Conventions
When you work with Siebel objects you must understand Siebel object naming conventions. An understanding of object naming conventions allows you to keep track of existing Siebel objects and to successfully create and maintain your own objects.
If you understand Siebel naming conventions, you can more easily identify underlying datasets (VSAM files); for example, the name of the underlying datasets for H0401000 table space might look like Q10E.DSNDBC.SIEBTO.H0401000.I0001.A001 where the fourth node represents the table space name.
NOTE: Siebel utilities are able to recognize and use custom objects only if they follow Siebel naming conventions; therefore, it is strongly recommended that you use the Siebel naming conventions for objects that you create.
Table Space Names
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.
Tables are named with eight characters (for example, H0401000) that consist of three elements (in the following order):
- A leading letter (H, V, F, 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).
- F specifically represents Siebel Financial Services.
- S represents your custom tables and auxiliary indexes (those that you create for the Siebel application).
- The four-digit number that was assigned to the base table when you created it, for example, 0401. (This number cascades down to table spaces, auxiliary tables, and auxiliary indexes.)
NOTE: For custom tables, use a four-digit number greater than 6000.
- The ending three-digit number depends on the database storage layout and size of the buffer pool. Use the following matrix to determine which prefix to use.
One table per table space Multiple tables per table space Partitioned 000 000 Nonpartitioned 000 004016032
- If your storage control file is based on the one table per table space model, the suffix is always 000, whether the table space is partitioned or not.
- If your storage control file is based on the multiple tables per table space model:
- The suffix for partitioned table spaces is 000.
- The suffix for segmented table spaces is 004, 016, or 032, depending on whether you use a 4-KB buffer pool, 16-KB buffer pool, or 32-KB buffer pool.
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.
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 names can be viewed in Siebel Tools under Table > Object.
Auxiliary Object Names
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):
- 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- A four-digit number that uniquely identifies the table space, for example, 0401.
NOTE: Default numbering of auxiliary objects starts from 0001.
- The ending three-digit number must be all zeros: 000. (Every name ends in 000.)
Triggers
Partitioning Triggers are named with 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, F, 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).
- F specifically represents Siebel Financial Services.
- 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.
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |