Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Understanding Siebel Partitioning >

About Prepartitioned Siebel Tables


Siebel eBusiness Applications Release 7.7 provides the following partitioned tables in storage control file templates.

The tables identified in Table 12 represent partitioned Core product tables; seven exceptions are identified as Siebel Industry Applications (SIA) product tables.

Table 12.  Prepartitioned Siebel Tables with Physical Columns
Table
Index
Indexed Columns
Trigger Logic

S_ACT_EMP

S_ACT_EMP_P99

PARTITION_COLUMN, EMP_ID

" WHEN (N.IMP_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.EMP_ID,2);

END "

S_ADDR_ORG

S_ADDR_ORG_P99

PARTITION_COLUMN, OU_ID

" WHEN (N.OU_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.OU_ID,2);

END "

S_ADDR_PER

S_ADDR_PER_P99

PARTITION_COLUMN, PER_ID

" WHEN (N.PER_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.PER_ID,2);

END "

S_APPLD_CVRG

Siebel Industry Applications (SIA) table

S_APPLD_CVRG_P99

PARTITION_COLUMN, ASSET_ID

WHEN (N.ASSET_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);

END "

S_ASSET

S_ASSET_P99

PARTITION_COLUMN, ROW_ID

"WHEN (N.ROW_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);

END "

S_ASSET

S_ASSET_CON

S_ASSET_CON_P99

PARTITION_COLUMN,ASSET_ID

"WHEN (N.ASSET_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);

END "

S_ASSET_POSTN

Siebel Industry Applications (SIA) table

S_ASSET_POSTN_P99

PARTITION_COLUMN,ASSET_ID

"WHEN (N.ASSET_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);

END "

S_COMMUNICATION

S_COMUNICATION_P99

PARTITION_COLUMN,ROW_ID

"WHEN (N.ROW_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);

END "

S_CONTACT

S_CONTACT_M12

LAST_NAME, FST_NAME, PRIV_FLG, ALIAS_NAME

N/A

S_EVT_ACT

S_EVT_ACT_P99

PARTITION_COLUMN,OPTY_ID

"WHEN (N.ROW_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.OPTY_ID,2);

END "

S_EXP_ITEM

S_EXP_ITEM_P99

PARTITION_COLUMN, OWNER_EMP_ID

"WHEN (N.OWNER_EMP_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.OWNER_EMP_ID,2);

END "

S_FN_ACCNT_TXN

Siebel Industry Applications (SIA) table

S_FN_ACCNT_TXN_P99

PARTITION_COLUMN, ACCNT_ID

"WHEN (N.ACCNT_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ACCNT_ID,2);

END "

S_FNCVRG_ELMNTS

Siebel Industry Applications (SIA) table

S_FNCVRG_ELMNTSP99

PARTITION_COLUMN,APPLD_CVRG_ID

"WHEN (N.APPLD_CVRG_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.APPLD_CVRG_ID,2);

END "

S_INS_CLAIM

Siebel Industry Applications (SIA) table

S_INS_CLAIM_P99

PARTITION_COLUMN,INSCLAIM_NUM

"WHEN (N.INSCLAIM_NUM IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.INSCLAIM_NUM,2);

END "

S_INS_ITEM

Siebel Industry Applications (SIA) table

S_INS_ITEM_P99

PARTITION_COLUM, ASSET_ID

"WHEN (N.ASSET_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);

END "

S_INSCLM_ELMNT

Siebel Industry Applications (SIA) table

S_INSCLM_ELMNT_P99

PARTITION_COLUMN,INSCLM_ID

"WHEN (N.INSCLM_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.INSCLM_ID,2);

END "

S_OPTY

S_OPTY_U1

NAME, PR_DEPT_OU_ID, BU_ID, CONFLICT_ID

N/A

S_OPTY_POSTN

S_OPTY_POSTN_P99

PARTITION_COLUMN,OPTY_ID

"WHEN (N.OPTY_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.OPTY_ID,2);

END "

S_ORG_EXT

S_ORG_EXT_U1

NAME, LOC, BU_ID, CONFLICT_ID

N/A

S_PARTY

S_PARTY_P99

PARTITION_COLUMN,ROW_ID

"WHEN (N.ROW_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);

END "

S_PARTY_REL

S_PARTY_REL_P99

PARTITION_COLUMN,PARTY_ID

"WHEN (N.PARTY_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.PARTY_ID,2);

END "

S_POSTN_CON

S_POSTN_CON_P99

PARTITION_COLUMN,POSTN_ID

"WHEN (N.POSTN_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.POSTN_ID,2);

END "

S_REVN

S_REVN_P99

PARTITION_COLUMN,ROW_ID

"WHEN (N.ROW_ID IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);

END "

S_SRV_REQ

S_SRV_REQ_P99

PARTITION_COLUMN,SR_NUM

"WHEN (N.SR_NUM IS NOT NULL)

BEGIN ATOMIC

SET N.PARTITION_COLUMN = RIGHT(N.SR_NUM,2);

END "

Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390