Connect Using DG4DRDA Fails With DB2 Sqlcode=-551, Sqlstate=42501 (Doc ID 229024.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 14-Mars-2008
Checked for relevance on 28-Sept-2009


Symptoms

Using TG4DRDA or DG4DRDA against DB2 UDB gives an error similar to this -


ORA-28500: connection from ORACLE to a non-Oracle system returned
this message:
TG4DRDA v10.2.0.4 grc=0, drc=-30020 (839C,0000), errp=GDJMRCALyyy.
sqlcode=-551, sqlstate=42501, errd=FFFFFF2E,0,0,FFFFFFFF,0,0
errmc=124c
ORA-02063: "preceding %s%s from %s%s"

Cause

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