DDLsync - Unnecessarily Rebuilding Indexes For Tables
Last updated on AUGUST 31, 2017
Applies to:Siebel System Software - Version 126.96.36.199 SIA  to 188.8.131.52  [Release V8]
Siebel CRM - Version 184.108.40.206 SIA to 220.127.116.11 SIA [Release V8]
Information in this document applies to any platform.
DDLSYNC rebuilds all clustered indexes whether they have changed or not.
Since our upgrade to Siebel 18.104.22.168 (SIA) the DDLsync functionality causes unwanted behaviour:
We use the following command to start the DDL sync: <SES install directory>\Config\config.bat -mode dbsrvr (for example: D:\Ses\config\config.bat -mode dbsrvr)
repimexp -> works just as we expected.
ddldict -> works just as we expected.
ddlimp -> During the 'ddlimp' process the indexes for our tables are rebuild (rebuilding indexes for tables because clustering index has changed), although nothing has changed in the indexes. This slows down the entire DDLsync process and may be expensive in production environment, as it takes hours to create/rebuild the indexes.
Example from the ddlsync1_01.log (see attachment):
2012-09-04 08:47:40 Rebuilding indexes for S_CONTROL because clustering index has changed
2012-09-04 08:50:47 Dropping index S_CONTROL_P1 ... 3:06.094m
2012-09-04 09:00:34 Creating index S_CONTROL_P1 ... 9:47.625m
2012-09-04 09:00:34 Granting table S_CONTROL ... 0.109s
2012-09-04 09:00:34 Merging table S_CONTROL_INTL ...
Fast assistence is required in this, since we plan to roll-out our next release (and 22.214.171.124) in the coming weeks.
This issue occurs in 126.96.36.199FP and affects MSSQL Server, Oracle and DB2LUW. Please note that DB2LUW is impacted when using the "allow reverse scans" attribute which affects 46 indexes in the current schema by default.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms