1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Siebel Tables with LONG Columns That Are Created as CLOBs

Siebel Tables with LONG Columns That Are Created as CLOBs

The following Siebel tables have columns defined as LONG that are converted to CLOB columns on z/OS (Clobs is set to Yes in the storage control file definition of the table). Siebel CRM uses CLOB columns for these tables to avoid the in-memory sort limit of DB2 for z/OS.

These tables belong to the Siebel Repository and are not read or updated frequently so the performance issues associated with using CLOB columns, described in Issues in Using CLOB Columns Instead of LONG VARCHAR Columns, are not relevant:

  • S_BITMAP_DATA

  • S_DMND_CRTN_PRG

  • S_EVT_MAIL

  • S_NOTE

  • S_NOTE_ACCNT

  • S_NOTE_CON

  • S_NOTE_OPTY

  • S_SCHMST_DBSCPT

  • S_SCHMSTEP_SCPT

  • S_SERVICE_SCRPT

If appropriate for your environment, you can enable CLOB columns for Siebel tables other than those listed. For information on this task, see Converting LONG VARCHAR Columns to CLOB Columns.