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 Supported 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 your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services to help in 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

Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.