Replicat Is Slow On DB2 Luw Due To CLI Tracing Running Even When Not Enabled
Last updated on APRIL 19, 2017
Applies to:Oracle GoldenGate - Version 188.8.131.52.1 to 184.108.40.206.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.
Using GG version 220.127.116.11.0 for DB2 LUW version 10, replication runs very slowly
replicat was processing at ~ 137 ops/sec (report file).
trace2 analysis shows that during that time, SQL executions take average of 7ms/op which match to 137 ops/sec.
Based on this, we know that replicat spends most of it's time executing SQL including when there are conflicts
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms