Skip to Content

Cluster tables (KONV,BSEG) Replication to Oralce

Hi

SLT Version: DMIS 2011_1_731 0008

BSEG Table having  1.7 Billion records and taking 5 days (30 hours to read and 90 hours to load) to complete the initial load.  Even though more background process assigned, it is using only 3 process while reading and loading also. 

Reading Type : 4

Is there any restriction on using the background process for cluster tables.

Please suggest, how to improve the initial load performance. 

Thank you

Murali

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 22, 2015 at 03:09 PM

    Hi Murali,

    How many jobs did you define at the connection level (replication jobs/initial load jobs/calculation jobs) and at the table level ?

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

    • On which table did you set the performance options : the logical table (BSEG) or the physical (RFBLG) ? It seems (according to the doc)  that you have to use the logical one for the options of the initial load and the physical for the delta.

      How many batch processes are available on the SLT side and dialog processes on the ECC side ?

      Regards,

      Frederic