Verifying IBM DB2 Sort Order for a Siebel Upgrade

Environments: Development, Test and Production.

Databases: IBM DB2 only.

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, then 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 in the Siebel database:

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

2. Review the result.

   • If sort order is correct, then the result is as follows:

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

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

     COLLATE USING IDENTITY