IBM Support

IT30628: DB2 GET DB CFG RECEIVES SSQL5060N WHEN V11.1 CLIENT TO LOWER VERSION SERVER

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Db2 get db cfg receives SSQL5060N when V11.1 client to lower
    version server.
    The problem exists after V11.1.
    
    At the lower level server's db2diag.log, below messages are
    logged.
    -----
    2019-10-07-16.57.21.883647+540 I56239A549         LEVEL: Error
    PID     : 7929938              TID  : 2829        PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE
    APPHDL  : 0-8                  APPID: 192.168.0.0
    AUTHID  : db2inst1
    EDUID   : 2829                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, config/install, sqlfInitDbCfgParamForGet,
    probe:5160
    MESSAGE : SQL5060: sqlfGetDbCfg tok =
    DATA #1 : Hexdump, 4 bytes
    0x0000000110E787E0 : 0000 27BD
    ..'.
    
    2019-10-07-17.00.30.730240+540 E56789A808         LEVEL: Error
    (OS)
    PID     : 13369416             TID  : 772         PROC : db2acd
    0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 772                  EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, oper system services, sqloqualifydir,
    probe:20
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
              DIA8411C A file "" could not be found.
    CALLED  : OS, -, realpath
    OSERR   : ENOENT (2) "No such file or directory"
    DATA #1 : String, 20 bytes
    /home/db2inst1
    DATA #2 : unsigned integer, 8 bytes
    256
    DATA #3 : String, 0 bytes
    Object not dumped: Address: 0x00000001105B6918 Size: 0 Reason:
    Zero-length data
    DATA #4 : String, 105 bytes
    Search for ossError*Analysis probe point after this log entry
    for further
    self-diagnosis of this problem.
    -----
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 Version 11.1                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 Version 11.1 Mod 4 Fix Pack 6.                *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Db2 Version 11.1 Mod 4 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30628

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-17

  • Closed date

    2021-03-14

  • Last modified date

    2021-03-14

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
15 March 2021