My Oracle Support Banner

DB2 Z/OS Sending Huge Bytes of Data to Extract with Low Volume while using Stored Procedure (Doc ID 2818455.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


Customer is using stored procedure which was a part of the installation zip file for 19.1 for extracting from DB2 Z/OS.
There are 2 extracts using same stored procedure.
Even when there is no change happening on the mainframe, many bytes of data being sent to the extract.
The issue they are facing is that , the count of data inserts on the DB2 tables matches with the stats on extract , but on mainframe total bytes send is upto 73MB/sec , 2 to 3 invocations per second and this is causing high MIPS usage which isn't matching the extracted low volume.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.