Siebel 21.4 Update PostInstallDBSetup Utility Is Modifying DESC Sort Indexes to ASC (Doc ID 2789946.1)

Last updated on OCTOBER 01, 2023

Applies to:

Symptoms

The Siebel 21.4 PostInstallDBSetup utility was executed and it took 6 hours to run in the Performance Testing environment.
It was noticed that many indexes were modified by verifying the import_cus_schema.log file.
The indexes modified in this log were all indexes that have  DESC sort order columns and these indexes modification took around 5 hours to execute.

It seems that PostInstallDBSetup is modifying the indexes from DESC to ASC sort, because the ddlimp utility does not have the /9 Y switch parameter.




STEPS
-----------------------
The issue can be reproduced as following:

1. Run Siebel Postinstalldbsetup manually (Instructions to run postinstalldbsetup can be found in

Siebel Database Upgrade Guide> Chapter 10 Upgrading the Siebel Database> Rerunning Post Installation Database Update);

Check each setup.ini parameter meaning in Siebel Database Upgrade Guide > Chapter 10 Upgrading the Siebel Database > Post Installation Database Update);

2. Check Siebel-root\siebsrvr\log\PostInstallDBSetup_<date-time>\SeedSchemaManifest_<date-time>\Common\import_cus_schema.log file. These indexes contain columns in DESC order and were recreated in ascending order, which may affect performance. (This log snippet shows an execution in a standard environment. The S_EVT_ACT table did not contain many records.)

Changes

 Siebel SES update 21.4 (or above) binaries installation.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.