Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 for z/OS > Configuring the Siebel Database Layout > About Siebel Objects > Table Space Naming ConventionsThe 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:
NOTE: When defining a new table space for 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 ObjectsIn the current release 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 documentation. Naming Conventions for Partitioning TriggersPartitioning Trigger names comprise eight characters (for example, PTH0401) that consist of three elements in the following order:
|
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |