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

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Linux x86-64
RDBMS 11.2.0.1 linux x86-64 RHEL 5 or EL 5
DG4DB2 11.2.0.1 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


Symptoms

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.

Changes

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


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