Slow PARCONV_UPG Phase for Copying Table DBTABLOG During ERP 6 Upgrade

61 Views

Hi,

I have the following question for you DB6 experts.

We're upgrade the system from 4.6C to ERP 6.0. Although the upgrade is still going on, the remaining batch job

RDDGENBB_0 for the PARCONV_UPG has been going on for around 30 hours, and has only copied 110 million

out of 557 million records from table QCMDBTABLOG to QCM8DBTABLOG with the following insert statement

on far:

SQL Statement

INSERT INTO "QCM8DBTABLOG" ( "LOGDATE" , "LOGTIME" , "LOGID" , "TABNAME" , "LOGKEY"

, "HOSTNAME" , "USERNAME" , "TCODE" , "PROGNAME" , "OPTYPE" , "VERSNO" ,

"LANGUAGE" , "DATALN" , "LOGDATA" ) VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? )

Access Plan Opt Level = 5 ; Parallelism = None

0 INSERT STATEMENT ( Estimated Costs = 7,564E+00 [timerons] )

1 RETURN

2 INSERT

3 TBSCAN GENROW

For our this R/3 system on DB2 UDB 9.7 database, is there a temporary index you could suggest for table DBTABLOG

to help us speed up the above upgrade process? I understand we can terminate the upgrade, create the temporary

index, resume the upgrade and drop the index when the above job finishes.

Thanks.