Hi,
I have setup integrated replicat in one of the environment , where It is taking 15 mins or more to process a single trail file having size 100M . while running the health check report it is showing waiting for memory , I have configured stream pool size of 45GB. Is this something related to memory or any other way to improve the performance of the integrated replicat. my database size is 50TB.
++++++++++++++++++++++++++++++++
USERID ogguser, PASSWORD ogguser123
DBOPTIONS LOBWRITESIZE 1048576
DBOPTIONS INTEGRATEDPARAMS (COMMIT_SERIALIZATION FULL,eager_size 64000, PARALLELISM 4)
BATCHSQL
--GROUPTRANSOPS 1
--MAXSQLSTATEMENTS 250
--INSERTMISSINGUPDATES
--BATCHSQL BATCHESPERQUEUE 1000,BATCHTRANSOPS 100000, OPSPERBATCH 100000,OPSPERQUEUE 5000
ASSUMETARGETDEFS
APPLYNOOPUPDATES
-- Error Handling Parameters
REPERROR default, abend
reperror (0001, discard)
DISCARDFILE ./dirrpt/repa2.rpt, append
REPORTCOUNT EVERY 60 SECONDS, RATE
--HANDLECOLLISIONS
-- INSERTAPPEND
-- BATCHSQL
-- DBOPTIONS SUPPRESSTRIGGERS
-- DDL Parameters
DDL INCLUDE MAPPED
DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5
DDLOPTIONS report
TABLEEXCLUDE CRP_DW.FACET_ACCT_1112;
TABLEEXCLUDE CRP_DW.FACET_ACCT;
TABLEEXCLUDE CRP_DW.EDI;
TABLEEXCLUDE CRP_DW.MEMBER_OPPORTUNITY_NOTE;
MAP CRP_DW.*,TARGET CRP_DW.*;