IBM Support

LI74192: CONNECTION CONCENTRATOR AND PING HOSTS THEN CONNECT TO DATABASE RESULTS IN SQLJSROLLBACKBEFORECONNECTRESET ERROR IN DB2DIAG.LOG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After turning on Connection Concentrator all attempts to ping
    the hosts belonging to an instance and then try to connect to a
    database result in this message being written to the db2diag.log
    file:
    
    2009-02-05-03.13.49.833434-300 I356150756E504      LEVEL:
    Warning
    PID     : 12129                TID  : 220943346016 PROC :
    db2sysc 1
    INSTANCE: nyqxt150             NODE : 001          DB   : WISEQA
    APPHDL  : 1-47484              APPID: GAA33985.C0E6.073D55081349
    AUTHID  : MSDB2
    EDUID   : 16989                EDUNAME: db2agentg (WISEQA  ) 1
    FUNCTION: DB2 UDB, DRDA Application Server, sqljsDrdaAsDriver,
    probe:1
    DATA #1 : String, 57 bytes
    sqljsRollbackBeforeConnectReset:zDB2 Returned RLSCONV_NO.
    
    This message is written to the db2diag.log file in error.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * V9.1 GA version                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After turning on Connection Concentrator all attempts to     *
    * ping                                                         *
    * the hosts belonging to an instance and then try to connect   *
    * to a                                                         *
    * database result in this message being written to the         *
    * db2diag.logfile:                                             *
    *                                                              *
    *   2009-02-05-03.13.49.833434-300 I356150756E504              *
    * LEVEL:      Warning                                          *
    *      PID     : 12129     TID : 220943346016                  *
    * PROC :      db2sysc 1                                        *
    *      INSTANCE: nyqxt150     NODE : 001                       *
    * DB   : WISEQAAPPHDL  : 1-47484      APPID:                   *
    * GAA33985.C0E6.073D55081349AUTHID  : MSDB2                    *
    *     EDUID  : 16989  EDUNAME:                                 *
    * db2agentg (WISEQA  ) 1 FUNCTION: DB2 UDB, DRDA Application   *
    * Server, sqljsDrdaAsDriver,  probe:1                          *
    *       DATA #1 : String, 57 bytes                             *
    *      sqljsRollbackBeforeConnectReset:zDB2                    *
    * Returned RLSCONV_NO.                                         *
    *      This message is written to the                          *
    * db2diag.log file in error.                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * A special build was provided to customer.                    *
    ****************************************************************
    

Problem conclusion

  • Problem is fixed in V9.1 FP8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74192

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-18

  • Closed date

    2009-11-04

  • Last modified date

    2009-11-04

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

    LI74191

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSN

       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:
17 October 2021