SAP Knowledge Base Article - Preview

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

Symptom

You are updating your system to BBPCRM 714.

Execution Phase PARCONV_UPG kept running for about 10 hours to create large indexes.

In log-file <DIR_PUT>/log/>PD<timstamp>.<SID>, the runtime of creation of 3 M* indexes can be found - total time = 10:42:17:

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  

The system tried to create new index M1, M2 and M3 on table 'CRMD_AUSP_HIST' which has several hundred million entries.


Read more...

Environment

Netweaver based systems

Product

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

Keywords

PARCONV_UPG, create large index, "No database index", "For selected database systems", SE14, Created with Import, SE11 , KBA , BC-DWB-DIC-AC , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.