Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >

Verifying IBM DB2 Sort Order for a Siebel Upgrade

Upgrades from: All Siebel releases.

Environments: Development, production test, production.

Databases: IBM DB2 only.

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

Binary sort order is required for the development environment upgrade and is strongly recommended for the production environment upgrades.

Sort order is specified during creation of the database. If you find that your IBM DB2 development database was not created using Identity sort order, you must re-create your database using the option COLLATE USING IDENTITY.

If sort order is correct, but you are still encountering errors, contact Oracle's Siebel Technical Services for further analysis.

To verify that your database was created using Identity sort order

1. Run the following query on Siebel database:

   select count (*) from SIEBEL.S_APP_VER where '$' > '/'

2. Review the result.
   • If sort order is correct, the result is

   1
--------------
0
(1) record selected.

   • If sort order is incorrect, you must re-create the database, using this option:

   COLLATE USING IDENTITY

Related Topics

About Database Sort Order in the Siebel Environment