Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 18, 2005 at 02:33 PM

    I suggest that you create an Index for that particular table with the mentioned fields as key elements, this will speed up the Read process.

    However index itself would be somewhat huge, but then the reading should speed up.

    Regards,

    siddhesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Probably if you are using something like ESS, you might consider moving your data files for the tablespace containing that particular table to different physical disks.

      So that when the read happens, all disks work in parallel and the disk performance improves.

      Other than that, I am not aware of any solution, maybe someone else knows, I would be glad to know if any ?

      Regards,

      Siddhesh

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2005 at 07:41 PM

    Hello,

    In standard cluster table RFBLG have 5 tables:

    BSEC

    BSED

    BSEG

    BSES

    BSET

    In this installation RFBLG have 6 tables:

    BSEC

    BSED

    BSEG

    BSES

    BSET

    YBSEG - local development

    Table YBSEG was created by local development.

    Phase PARCONV_UPG try to convert table YBSEG and in the first step background jon RDDGENBB_0 try to read cluster table RFBLG.

    Maybe someone have experience about delete one table from cluster table?

    Tomasz.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.