IBM Support

JR34447: HEALTH MONITOR FAILS WITH RC=-1 ON HMONSQLDISCONNECT()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Health monitor fails on hmonDisconnect() with RC=-1 if we have
    AUTOCOMMIT turned off in db2cli.ini
    
    db2cli.ini
    
    [DBNAME]
    AutoCommit=0
    
    The following messages could be observed in the db2diag.log
    
    2000-00-00-00.00.00.000000+120 I39325H346         LEVEL: Severe
    PID     : 3196                 TID  : 2096        PROC :
    db2fmp.exe
    INSTANCE: DB2                  NODE : 000
    APPID   : *LOCAL.DB2.00000000000
    EDUID   : 2096
    FUNCTION: DB2 UDB, Health Monitor, hmonSQLDisconnect, probe:10
    MESSAGE : SQLDisconnect error sqlRC=[-1] sqlcode=[0]
    
    2000-00-00-00.00.00.000000+120 I39673H367         LEVEL: Severe
    PID     : 0000                 TID  : 0000        PROC :
    db2fmp.exe
    INSTANCE: DB2                  NODE : 000
    APPID   : *LOCAL.DB2.00000000000
    EDUID   : 0000
    FUNCTION: DB2 UDB, base sys utilities, sqleFreeCtx, probe:50
    RETCODE : ZRC=0x8805006B=-2012938133=SQLE_ZRC_CTX_INUSE "Context
    is in use"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Health monitor fails on hmonDisconnect() with RC=-1 if       *
    * wehaveAUTOCOMMIT turned off in                               *
    * db2cli.inidb2cli.ini[DBNAME]AutoCommit=0The following        *
    * messages could be observed in the                            *
    * db2diag.log2000-00-00-00.00.00.000000+120 I39325H346         *
    * LEVEL:SeverePID    : 3196                TID  : 2096         *
    * PROC :db2fmp.exeINSTANCE: DB2                  NODE :        *
    * 000APPID  : *LOCAL.DB2.00000000000EDUID  : 2096FUNCTION: DB2 *
    * UDB, Health Monitor, hmonSQLDisconnect,probe:10MESSAGE :     *
    * SQLDisconnect error sqlRC=[-1]                               *
    * sqlcode=[0]2000-00-00-00.00.00.000000+120 I39673H367         *
    * LEVEL:SeverePID    : 0000                TID  : 0000         *
    * PROC :db2fmp.exeINSTANCE: DB2                  NODE :        *
    * 000APPID  : *LOCAL.DB2.00000000000EDUID  : 0000FUNCTION: DB2 *
    * UDB, base sys utilities, sqleFreeCtx, probe:50RETCODE :      *
    * ZRC=0x8805006B=-2012938133=SQLE_ZRC_CTX_INUSE"Contextis in   *
    * use"                                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 9.5 FP6                                           *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34447

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-01

  • Closed date

    2010-10-21

  • Last modified date

    2010-10-21

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

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

    JR34448 IC63513 IC66322 IC66323 IC66324 IC66325 IC66326 IC66327
    IC66329 IC66330 IC66331 IC66332 IC66333 IC66334 IC66335 IC66336
    IC66337 IC66338 IC66339 IC66340 IC66341 IC66342 IC66343 IC66344
    IC66345 IC66346 IC66347 IC66348 IC66349 IC66351 IC66352 IC66353
    IC66354 IC66355 IC66356 IC66357 IC66359 IC66360 IC66361 IC66363
    IC66364 IC66365 IC66366 IC66368 IC66369 IC66370 IC66371 IC66372
    IC66374 IC66375 IC66376 IC66377 IC66864

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 October 2010