Bookshelf Home | Contents | Index | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Preparing for Implementation on the DB2 Host > Setting Up the Subsystem > Choosing the Database CCSIDSiebel Systems supports both ASCII- and EBCDIC-based coded character set IDs (CCSIDs) on DB2 UDB for z/OS and OS/390. The sort order used in list applets, among others, depends on the database CCSID. Review the Release Notes on Siebel SupportWeb for information about known restrictions; for example, the following features are not supported on databases with EBCDIC code pages: You should run development databases with ASCII code pages, because databases with EBCDIC code pages do not support the following procedures in a development environment upgrade:
You can partition table spaces on a database with either an ASCII or an EBCDIC code page, so that limit keys reflect the sort sequence difference between ASCII and EBCDIC. For more information, see Configuring the Database Layout. You can deploy either an ASCII- or an EBCDIC-based CCSID to create your Siebel Schema, but it is generally recommended that you use ASCII.
CAUTION: DB2 version 7 only supports a single code page for tables referenced within a single SQL statement. Setting the CCSIDThe CCSIDs must be configured in the fields ASCII CODED CHAR SET or EBCDIC CODED CHAR SET on the DB2 installation panel DSNTIPF. The field DEF ENCODING SCHEME on the same panel determines whether the default encoding scheme is ASCII or EBCDIC. NOTE: The field MIXED DATA on DSNTIPF should equal NO for all supported languages except Japanese. |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 |