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 >
Tables
The following example illustrates what the Table object looks like in the storage control file.
[Object 2247]
Type = Table
Name = S_ORG_EXT
Database = SIEBDB01
Tablespace = H1465000
Clobs = NoThe Table object illustrated above translates into the following DDL output:
CREATE TABLE SIEBTO.S_ORG_EXT (
ROW_ID VARCHAR(15) NOT NULL,
CREATED TIMESTAMP DEFAULT NOT NULL,
CREATED_BY VARCHAR(15) NOT NULL,
...VAT_REGN_NUM VARCHAR(30),
DIRECTIONS LONG VARCHAR) IN SIEBTO.H1465000 /Siebel eBusiness Applications include two templates per encoding scheme for one table per table space and two templates per encoding scheme for multiple tables per table space.
- One table per table space. The one-table-per-table space model defines each table in its own table space with no regard to other tables sharing similar functionality. In all other respects these tables are the same as those in the multiple tables per table space template.
- Multiple tables per table space. In the multiple tables per table space model, Siebel tables are grouped within databases and table spaces based on functionality. For example, all Activities- or Contacts-related tables are grouped together.
An advantage of the multiple tables per table space configuration is that fewer underlying physical datasets are created, compared to the one table per table space model. You should consider performance and the granularity of backup and recovery when choosing a template for your deployment.
Most tables use page-level locking by default, but a few exceptions use row-level locking. Table 10 lists tables that use row-level locking.
Table 10. Tables with Row-Level Locking Row-Level Locking S_ESCL_ACTN_REQS_ESCL_LOG
S_ESCL_REQ S_DOCK_TXN_LOG S_DOCK_TXN_LOGT S_DOCK_TXN_SET S_DOCK_TXN_SETTNOTE: LockSize is not defined on the table level, but in the corresponding table space.
Table 11 lists tables that use table-level locking.
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |