My Oracle Support Banner

CHAR Are Triple Size If The DRDA Listener Is Started With SRVCTL Command (Doc ID 1402243.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms


Whether the gateway listener is started with LSNRCTL or SRVCTL, CHAR columns got tripled size via DG4DRDA or DG4DB2.
Example

====>With LSNRCTL to start the gateway listener, one column is CHAR(2)
Gateway trace file shows:

HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=46
HOCXU_DRV_NCHAR=873
HOCXU_DB_CSET=46
HS_LANGUAGE not specified
LANG=en_US.UTF-8
....
DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
 3 DECIMAL N         10         10   8/  0    0   0   0 DRIFER
 1 CHAR    N          2          2   0/  0    0   0 200 CNAZTIT
 1 CHAR    N          9          9   0/  0    0   0 200 CSPTIT
 3 DECIMAL N          3          3   1/  0    0   0   0 CHKDGTIT
 3 DECIMAL N         21         21  18/ 15    0   0   0 QCOEVNT
 1 CHAR    N         26         26   0/  0    0   0 200 WTIMEINS




===>With SRVCTL to start the gateway listener, the same column becomes CHAR(6)
 

HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=873
HOCXU_DRV_NCHAR=873
HOCXU_DB_CSET=46
HS_LANGUAGE not specified
LANG=en_US.UTF-8
...
DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
 3 DECIMAL N         10         10   8/  0    0   0   0 DRIFER
 1 CHAR    N          6          6   0/  0    0   0 200 CNAZTIT
 1 CHAR    N         27         27   0/  0    0   0 200 CSPTIT
 3 DECIMAL N          3          3   1/  0    0   0   0 CHKDGTIT
 3 DECIMAL N         21         21  18/ 15    0   0   0 QCOEVNT
 1 CHAR    N         26         26   0/  0    0   0 200 WTIMEINS

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.