Skip to Content
0
Former Member
Aug 18, 2005 at 02:19 PM

Upgrade from 4.6B to R.3 Enterprise Ext Set 2.0

22 Views

Hello,

I doing upgrade on QAS system (copy PRD system).

HP-UX 11i, rp4440 serwer with 4 processors and 16 GB RAM, Oracle 9.2.0.6.0 and 2 TB dbsize.

I have problem with phase:

UPGRADE/NEWBAS: PHASE PARCONV_UPG

In this faze background job RDDGENBB_0 try to read table RFBLG, I see this in SM50 in details of process:

SELECT "MANDT" , "BUKRS" , "BELNR" , "GJAHR" , "PAGENO" , "TIMESTMP" , "PAGELG" , "VARDATA"

FROM "RFBLG"

ORDER BY "MANDT" , "BUKRS" , "BELNR" , "GJAHR" , "PAGENO" #

RFBLG table have about 70GB and 105 000 000 rows.

In my estimate time to end read RFBLG table is about 175 hours. I didn't incremental conversion in ICNVREQ phase (ICNV transaction).

How to speed up this phase ???????

Please help me.

Best Regards,

Tomasz.