Changing the database schema sort order for Oracle and DB2
This procedure changes the default application database schema sort, and makes it compatible with your database type. If you are using Oracle or IBM DB2, you must perform this procedure.
If you do not change the sort order, database searches might return the wrong records or return results in an unpredictable way.
If your database is Microsoft SQL Server or Sybase, skip this procedure.
To change the schema sort order
- From the IT Home page, open the Application Administration Console.
- Click the Custom Configuration tab.
- Choose Foundation > Advanced Options > System Configuration Settings > Application Database Sort Order, and click Open.
- Search for all records. (Click Search without specifying any search criteria.)
- In the Functions area, select Oracle or DB2 for the Sort Order Type, depending on which database you are using.
Click Modify All.
You will see the changed sort order after you restart the BMC Remedy AR System server.