IBM Support

JR34448: 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 conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34448

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-01

  • Closed date

    2010-05-11

  • Last modified date

    2010-05-11

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

    JR34447

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

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