My Oracle Support Banner

Hang When Invoking As/400 Stored Procedure Using DG4DRDA (Doc ID 1247884.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database Gateway for DRDA - Version to [Release 11.2]
Linux x86-64
RDBMS linux x86-64 RHEL 5 or EL 5
DG4DB2 linux x86-64 RHEL 5 or EL 5
Connected to db2/400

The error seems to only happen with RHEL or EL v5 only, it does not reproduce on v4.
Other distributions have not been checked yet


While referencing a remote Stored Procedure on an AS400, either trying to describe the procedure or trying to execute it, then the gateway subsytem will hang.

The hang does not happen with all remote Stored Procedures.


The issueis caused by a specific version on drda driver:

I[ 0] ConnectionHandle :h0x0a607d10
I[ 1] InfoType : 7
O[ 2] InfoValue :(0x7fff8bb01600)
00: 30362E30 302E3031 33312028 42303039 [06.00.0131 (B009]
10: 372C2055 30303438 29 [7, U0048)]
I[ 3] BufferLength : 512

The attempt to describe proc is truncated in gatewy trace file like below

ENTER SQLProcedureColumns [9 args]
I[ 0] StatementHandle :h0x0a6fc210
I[ 1] szCatalogName :( (nil))
I[ 2] cbCatalogName : 0
I[ 3] szSchemaName :(0x0a6a6000)
0: 51535953 32 [QSYS2]
I[ 4] cbSchemaName : 5
I[ 5] szProcName :(0x0a6a7070)
0: 434F4D50 4152455F 4D4F4E49 544F52 [COMPARE_MONITOR]
I[ 6] cbProcName : 15
I[ 7] szColumnName :( (nil))
I[ 8] cbColumnName : 0


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

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