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 = No

The 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_REQ
S_ESCL_LOG
S_ESCL_REQ
S_DOCK_TXN_LOG
S_DOCK_TXN_LOGT
S_DOCK_TXN_SET
S_DOCK_TXN_SETT

NOTE:  LockSize is not defined on the table level, but in the corresponding table space.

Table 11 lists tables that use table-level locking.

Table 11.  Tables with Table-Level Locking

Table-Level Locking
S_DOCK_INIT_ITEM
S_DOCK_INITM_XX

Bookshelf Home | Contents | Index | Search | PDF