Cluster tables (KONV,BSEG) Replication to Oralce

[former_member204828]

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

[FCI]

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

[former_member204828]

Hi Frederic

I am using the below config at Connection level and Table level\

Replication jobs: 25

Initial Load job: 20

Calculation Jobs:20

Table Level : 20  in Advanced Replication settings - Performance option.

Thank you

MURALI

[FCI]

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