Siebel Tables Defined with CLOB Columns

The following Siebel tables have columns that are defined as CLOB columns in the Siebel Repository. Activity on these tables is quite high, but these tables cannot be stored in 32-KB table spaces because they have very large columns (greater than 128 KB) and so could encounter the in-memory sort limit of DB2 for z/OS:

• EIM_AUDIT_ITEM

• EIM_AUDIT_READ

• S_AUDIT_ITEM

• S_AUDIT_READ

• S_BR_GBL_BINARY

• S_BR_MODULE_BIN

• S_DOCK_TXN_LOG

• S_TU_LOG

• S_TU_LOG_X_01

• S_TU_LOG_X_02

• S_TU_LOG_X_03

• S_TU_LOG_X_04

• S_TU_LOG_X_05

• S_WEBCHNL_SES

• S_WEBCHNL_SNSVC

If appropriate for your environment, you can also define new extension columns for tables as CLOB data types. For information on this task, see About Defining New Extension Columns as CLOB Data Types.