Siebel Database Upgrade Guide for DB2 for z/OS > Planning a Siebel Database Upgrade >

Considering Code Page Support

Siebel CRM 8.x supports ASCII-, EBCDIC-, and Unicode-based coded character set IDs (CCSIDs) on DB2 for z/OS. Development databases, however, cannot use EBCDIC code pages, because databases with EBCDIC code pages do not support two critical procedures in a development environment upgrade:

• Merging prior configuration changes into a new custom configuration repository
• Compiling a new Siebel repository file (.srf file) from the new repository

Additional limitations on databases with EBCDIC code pages include the following:

• Siebel Web Client migration is not supported
• Siebel Dun & Bradstreet server components are not supported

Before you conduct an upgrade, carefully read Siebel Release Notes on My Oracle Support for information about known restrictions. For guidelines about choosing the code page for your subsystem, see Implementing Siebel Business Applications on DB2 for z/OS. In addition, make sure you follow the rules specified by IBM for character conversion as described in the IBM DB2 installation documentation.

About Code Page Conversion

Siebel CRM supports the ASCII 5348 and EBCDIC 1140 code pages on DB2 for z/OS. If your current Siebel CRM release runs on a different code page, you must migrate to one of the supported code pages before upgrading to the current Siebel release.

Since Siebel CRM 7.5, Siebel Business Applications has supported the Unicode character set. On the z/OS platform, Siebel Business Applications only support the Unicode character set on DB2 for z/OS version 8 running in New Function Mode or later releases. Character conversions from Unicode code pages to ASCII and EBCDIC code pages on the z/OS host are performed by the z/OS Unicode Services; these conversions are required if Siebel Business Applications are to function correctly. For information on setting up the z/OS Unicode Services, see the IBM document about using Unicode Services on the IBM z/OS information center Web site at

http://publib.boulder.ibm.com/infocenter/zos/v1r9/index.jsp

Check the Siebel schema code page before starting the Siebel upgrade to ensure characters on the target schema will display correctly. Schedule sufficient time to perform and test the code page conversion before beginning the upgrade. For advice and assistance on converting DB2 code pages, contact IBM.

NOTE:  To ensure the euro symbol is implemented correctly in the Siebel database on the z/OS host, enable support for the euro symbol by setting the DB2 Connect system environment variable, DB2CONNECT_ENABLE_EURO_CODEPAGE, to YES on all DB2 Connect computers used to connect to the Siebel CRM database. For additional information on the DB2CONNECT_ENABLE_EURO_CODEPAGE variable, see the relevant IBM documentation.