Symptom
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...
Environment
NetWeaver based systems
Product
Keywords
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.