2100132 - upgrade phase PARCONV_UPG running for extremely long time due to large indexes creation

During a system upgrade using SUM, execution phase PARCONV_UPG kept running for about 10 hours to create large indexes. For example,

In log-file <DIR_PUT>/log/>PD<timstamp>.<SID>, the runtime of creation of some indexes can be found with total time about 10 hours:

3 ETP379X02:24:15: activating Nametab "CRMD_AUSP_HIST":

3 ETP355Xstatements:

3 ETP000 >>>>>>>>> UNCRITICAL DIPGNTAB <<<<<<<<<

3 ETP000 CREATE

3 ETP000 INDEX [CRMD_AUSP_HIST~M1] ON [CRMD_AUSP_HIST]

3 ETP000 ( [MANDT] ,

3 ETP000 [ATINN] ,

3 ETP000 [CHANGED_AT] )

3 ETP000 WITH ( PAD_INDEX = OFF

3 ETP000 , ONLINE = OFF

3 ETP000 , DATA_COMPRESSION = PAGE

3 ETP000 )

3 ETP000

3 ETP356 executed ( "03:36:13" )

2 ETP000                  DB-COMMIT()

3 ETP000 DELETE FROM DDSTORAGE

3 ETP000 WHERE DBSYSABBR = 'MSS'

3 ETP000 AND TABNAME = 'CRMD_AUSP_HIST'

3 ETP000 AND INDEXNAME = 'M1'

3 ETP000

3 ETP356 executed ( "00:00:00" )

2 ETP000                  DB-COMMIT()

3 ETP000 >>>>>>>>> UNCRITICAL DIPGNTAB <<<<<<<<<

3 ETP000 CREATE

3 ETP000 INDEX [CRMD_AUSP_HIST~M2] ON [CRMD_AUSP_HIST]

3 ETP000 ( [MANDT] ,

3 ETP000 [CHANGED_AT] ,

3 ETP000 [PARTNER_GUID] )

3 ETP000 WITH ( PAD_INDEX = OFF

3 ETP000 , ONLINE = OFF

3 ETP000 , DATA_COMPRESSION = PAGE

3 ETP000 )

3 ETP000

3 ETP356 executed ( "03:40:32" )

2 ETP000                  DB-COMMIT()

3 ETP000 DELETE FROM DDSTORAGE

3 ETP000 WHERE DBSYSABBR = 'MSS'

3 ETP000 AND TABNAME = 'CRMD_AUSP_HIST'

3 ETP000 AND INDEXNAME = 'M2'

3 ETP000

3 ETP356 executed ( "00:00:00" )

2 ETP000                  DB-COMMIT()

3 ETP000 >>>>>>>>> UNCRITICAL DIPGNTAB <<<<<<<<<

3 ETP000 CREATE

3 ETP000 INDEX [CRMD_AUSP_HIST~M3] ON [CRMD_AUSP_HIST]

3 ETP000 ( [MANDT] ,

3 ETP000 [PARTNER_GUID] ,

3 ETP000 [ATINN] ,

3 ETP000 [CHANGED_AT] ,

3 ETP000 [ADZHL] )

3 ETP000 WITH ( PAD_INDEX = OFF

3 ETP000 , ONLINE = OFF

3 ETP000 , DATA_COMPRESSION = PAGE

3 ETP000 )

3 ETP000

3 ETP356 executed ( "03:25:32" )

2 ETP000                  DB-COMMIT()

3 ETP000 DELETE FROM DDSTORAGE

3 ETP000 WHERE DBSYSABBR = 'MSS'

3 ETP000 AND TABNAME = 'CRMD_AUSP_HIST'

3 ETP000 AND INDEXNAME = 'M3'

3 ETP000

3 ETP356 executed ( "00:00:00" )

2 ETP000                  DB-COMMIT()

3 ETP378 13:06:32: succeeded,  DDL executed

3 ETP359 "CRMD_AUSP_HIST                " total time = 10:42:17

According to the log file, SUM tried to create new indexes M1, M2 and M3 on table 'CRMD_AUSP_HIST' which has several hundred million entries.

Read more...

NetWeaver based systems

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

PARCONV_UPG, create large index, "No database index", "For selected database systems", SE14, Created with Import, SE11, SPDD, index, long running, long runtime , KBA , BC-DWB-DIC-AC , ABAP Dictionary Activation and Conversion , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem