DB2 z/OS extract: SQL0440N No authorized routine named "OGGIFI0001.OGGINITB" of type "" having compatible arguments was found. SQLSTATE=42884
(Doc ID 2570353.1)
Last updated on JUNE 01, 2020
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
User in this case installed OGG 19.1 for Linux for DB2 z/OSand was getting below error:
Oracle GoldenGate Capture for DB2
Version 22.214.171.124.1 OGGCORE_126.96.36.199.0_PLATFORMS_190524.2201
Linux, x64, 64bit (optimized), IBM DB2 z/OS on May 25 2019 05:22:50
2019-07-24T07:02:28.477+0200 ERROR OGG-00551 Oracle GoldenGate Capture for DB2, ext.prm: Database operation failed: init sp - execute. ODBC error: SQLSTATE 42884 native database error -440. [IBM][CLI Driver][DB2] SQL0440N No authorized routine named "OGGIFI0001.OGGINITB" of type "" having compatible arguments was found. SQLSTATE=42884.
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