My Oracle Support Banner

IBM DB2 z/OS Extract Abends With OGG-00551 ( Function OGGREADB Issue) (Doc ID 3017163.1)

Last updated on MAY 23, 2024

Applies to:

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

Symptoms

Facing below errors frequently in Goldengate extract for DB2 for z/OS issue .
Both errors are occurring frequently in extract

Error#1
--------
extract <extract_name>
.....
2024-02-15 23:20:48 ERROR OGG-00551 Database operation failed: read func - execute. Called from ifi_read:960. ODBC error: SQLSTATE 58004 native database error -901. [IBM][CLI Driver][DB2] SQL0430N User defined function "FUNCTION" (specific name "<name>.OGGREADB") has abnormally terminated. SQLSTATE=38503[IBM][CLI Driver][DB2] SQL0901N The SQL statement or command failed because of a database system error. (Reason "".) SQLSTATE=58004.

Error#2

----------
extract <extract_name>
...
2024-02-23 14:07:59 ERROR OGG-00551 Database operation failed: read func - execute. Called from ifi_read:960. ODBC error: SQLSTATE 55023 native database error -471. [IBM][CLI Driver][DB2] SQL0471N Invocation of routine "<name>.OGGREADB" failed due to reason "00E79001". SQLSTATE=55023.

 

Cause

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
Symptoms
Cause
Solution
References


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