Siebel Database Upgrade Guide for DB2 UDB for z/OS > Preparing Siebel Application Data for Upgrade >

Converting LONG VARCHAR Columns to CLOB Columns

Upgrades: Releases 6.x, 7.0.x, 7.5.x, 7.7.x

Environments: All environments.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

In Siebel 8.0 and Siebel 7.8.x, the LONG VARCHAR columns of the following Siebel tables are converted to CLOB columns on z/OS to make sure data truncation problems do not occur:

• 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 you are upgrading to Siebel 8.0 from a pre-7.8.x release of Siebel Business Applications, if any of these tables are already in 32 KB buffer pools, convert the LONG VARCHAR columns in these tables to CLOB data types to make sure the columns are not truncated if, for example, a column is added to the table during the upgrade.

CAUTION:  For pre-7.8.x upgrades, you must convert the SCRIPT column of the S_SERVICE_SCRPT table from a LONG VARCHAR data type to a CLOB data type before you begin the upgrade. If you do not, the repository merge process fails because the row length of the table exceeds the DB2 limit.

Changing the data type of the SCRIPT column in the S_SERVICE_SCRPT table involves deleting and re-creating the table. Ask your DBA to perform this task or create a service request (SR) on My Oracle Support requesting assistance.