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

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