IBM Support

JR33196: V7.2 CLIENTS CONNECTING TO Z/OS VIA V9.1 FP6 GATEWAY RECEIVE SQL30020N RSN CODE "0X1218" 00D31050

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Version 7 clients will receive the following error when trying
    to connect to a z/OS DB2 envirnoment via a DB2 Connect Version
    9.1 Fixpak 6 and higher gateway:
    
    SQL30020 Rsn Code "0x1218" 00D31050
    
    
    db2trc will show:
    
    1395 DB2 fnc_data      base_sys_utilities
    sqle_database_connect (1.35.5.380)
     pid 1620; tid 696; node 0; cpid 34; msec 3235812; tpoint 51
     5351 4c43 4120 2020 8800 0000 bc8a ffff SQLCA   ........
     0700 3078 3132 3138 ff20 2020 2020 2020 ..0x1218.
     2020 2020 2020 2020 2020 2020 2020 2020
     2020 2020 2020 2020 2020 2020 2020 2020
     2020 2020 2020 2020 2020 2020 2020 2020
     2020 2020 2020 2020 7371 6c6a 7265 726d         sqljrerm
     8300 3780 8300 0000 0000 0000 0000 0000 ..7.............
     0000 0000 0000 0000 2020 2020 2020 2020 ........
     2020 2020 2020 2020
    

Local fix

  • Use DB2 V9.1 fp5 for gateway or upgrade client to Version 8 or
    higher.
    

Problem summary

  • Users Affected:  Those using DB2 LU2 Version 7.2 clients to
    connect to z/OS DB2 via a V9.1 gateway
    
    Problem Description: V7.2 CLIENTS CONNECTING TO Z/OS VIA
    V9.1 FP6/FP7 GATEWAY RECEIVE SQL30020N RSN CODE "0X1218"
    00D31050
    
    Problem Summary:   V7.2 CLIENTS CONNECTING TO Z/OS VIA V9.1
    FP6/FP7 GATEWAY RECEIVE SQL30020N RSN CODE "0X1218" 00D31050
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fixpak 8 (s090823)
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33196

  • Reported component name

    DB2 CUE WINDOWS

  • Reported component ID

    5724B6201

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-01

  • Closed date

    2010-01-18

  • Last modified date

    2010-01-18

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    JR33471

Fix information

  • Fixed component name

    DB2 CUE WINDOWS

  • Fixed component ID

    5724B6201

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021