Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Configuring the Database Layout > About Siebel Objects >

About Tables in Storage Control Files

The following example illustrates what the Table object looks like in the storage control file.

[Object 7149]
Type = Table
Name = S_ORG_EXT
Database = SIDB1465
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 one template per encoding scheme when partitioning is used and one template per encoding scheme for non-partitioning.

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.

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

Table 11 lists tables that use table-level locking.