DDLsync - Unnecessarily Rebuilding Indexes For Tables (Doc ID 1494393.1)

Last updated on AUGUST 31, 2017

Applies to:

Siebel System Software - Version 8.1.1.8 SIA [23012] to 8.1.1.9 [23016] [Release V8]
Siebel CRM - Version 8.2.2.1 SIA[23012] to 8.2.2.2 SIA[23016] [Release V8]
Information in this document applies to any platform.
DDLSYNC rebuilds all clustered indexes whether they have changed or not.

Symptoms

Since our upgrade to Siebel 8.1.1.8 (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 8.1.1.8) in the coming weeks.

Changes

This issue occurs in 8.1.1.8FP 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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms