IBM Support

IT21902: BACKGROUND DAEMONS MIGHT NOT START JUST AFTER TAKEOVER HADR DUE TO TIMING HOLE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Background daemons like db2wlmd, db2taskd might not start just
    after takeover HADR.
    There might be small timing hole to allow new connection before
    all the internal takeover state has been cleared.
    
    Users can see the following error if such connection takes
    metrics before starting db2wlmd.
    
    2016-01-27-12.15.32.062250+540 I99673A647         LEVEL: Error
    PID     : 35651692             TID : 6486         PROC : db2sysc
    INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE
    APPHDL  : 0-41260              APPID:
    *LOCAL.db2inst1.160127031615
    AUTHID  : db2inst1             HOSTNAME: irita
    EDUID   : 6486                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, WLM,
    sqlrwWlmStatsCollectionServices::requestWlmStatsCo, probe:20
    RETCODE : ZRC=0x870000CD=-2030042931=SQLZ_RC_UNEXPECTED_SYSERR
              "Unexpected System Error"
    DATA #1 : String, 66 bytes
    WLW stats collector not started. Unable to force stats
    collection.
    
    This APAR will change the return code from SYSTEM ERROR to
    SQL1632W.
    

Local fix

  • Please ignore the error. Background agents will be started by
    subsequent connection.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21902

  • 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

    2017-08-09

  • Closed date

    2017-10-24

  • Last modified date

    2017-10-24

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

    IT13860

  • 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

  • RB10 PSN

       UP

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

Document Information

Modified date:
24 October 2017