My Oracle Support Banner

SQLCODE = -30073 when connecting to DB2 via Oracle Database Provider for DRDA (ODP4DRDA) (Doc ID 2857956.1)

Last updated on MAY 17, 2022

Applies to:

Oracle Database Provider for DRDA - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When trying to connect to the database the following errors occurred on the DB2 message log:

08.50.19 STC28773 DSNL031I -DBT1 DSNLZDJN DRDA EXCEPTION CONDITION IN 058
  058 RESPONSE FROM SERVER LOCATION=PRDSLDEV FOR THREAD WITH
  058 LUWID=NETCPCW.DB2TH.DB3DE5881978=45595
  058 REASON=00D3530C
  058 ERROR ID=DSNLZRPY010C
  058 CORRELATION ID=G186
  058 CONNECTION ID=TSO
  058 IFCID=0191
  058 SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000001

DSNT408I SQLCODE = -30073, ERROR: 1149:0100 PARAMETER VALUE NOT SUPPORTED
  ERROR
DSNT418I SQLSTATE = 58017 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNLZRSQ SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

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.