Get SQ30073 and invalid codepage when connecting from DB2 on AS400 with default CCSID - perform no data conversions (Doc ID 2166465.1)

Last updated on JULY 28, 2016

Applies to:

Oracle Database Provider for DRDA - Version 12.1.0.2 and later
Linux x86-64

Symptoms

Get SQ30073 when connecting from DB2 on AS400 v7.1
through DP4DRDA (Oracle Database Provider for DRDA) 12.1.0.2 on Linux x86-64 to Oracle Database 12c.

The DP4DRDA trace contains "codepage value 65535 is invalid for ccsidsbc".

pp_#####_drdaas.trc

-insvar 0035 "typdefovr"
--ovr 119C "ccsidsbc" -> 0xFFFF
codepage value 65535 is invalid for ccsidsbc
Generating ReplyMsg 1252 (VALNSPRM)
MyMemoryAlloc(4280) => 0x20f5540
Updating Severity Code to 8
Exiting dpsadraccrdb, RC= 1 at 2016-07-20 13:49:07.510503000
DSS: rc => 1, svrcod => 8

 

The SQL package creation fails on AS400 with code SQ30073, Distributed Data Management (DDM) parameter value X'119C' not supported.

AS400 Messages:

5770SS1 V7R1M0 100423 Create SQL package 07/20/16 11:18:34 Page 1
===
DIAGNOSTIC MESSAGES
MSG ID SEV RECORD TEXT

SQ30073 30 Distributed Data Management (DDM) parameter value X'119C' not supported.

SQL5056 SQL package creation for module RSQLTEST failed. Package name was to be RSQLTEST in xxxxx at ORACLERMT.

Message Summary
Total Info Warning Error Severe Terminal
1 0 0 0 1 0
30 level severity errors found in source

 

\QPJOBLOG_xxx_RSQLTEST.txt

SQ30073 Diagnostic 30 07/20/16 11:18:34.437230 QSQCONN QSYS *STMT QSQCONN QSYS *STMT
From module . . . . . . . . : QSQCONN
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 22579
To module . . . . . . . . . : QSQCONN
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 22579
Message . . . . : Distributed Data Management (DDM) parameter value X'119C' not supported.
Cause . . . . . : DDM parameter value X'119C' is not supported.

SQL9004 Diagnostic 30 07/20/16 11:18:34.444743 SSEXEC2 SDMIM 0165 IMCOMP SDMIM 08FF
Message . . . . : Create of SQL package failed.
Cause . . . . . : SQL create package processing has detected errors.

 

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