1. Database Upgrade Guide for DB2 for z/OS
  2. Converting LONG VARCHAR Columns to CLOB Columns

Converting LONG VARCHAR Columns to CLOB Columns

Upgrades: Releases 7.5.3, 7.7.

Environments: All environments

This topic is part of an upgrade process. See Performing a Siebel Database Upgrade.

In Siebel CRM Release 8.x and 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

Before upgrading to Siebel CRM 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.8x 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 dropping and re-creating the table. Ask your DBA to perform this task or create a service request (SR). You can log service requests by accessing My Oracle Support (Service Request tab), or by using your existing phone support numbers to contact Oracle Global Customer Support.