IBM Support

IT29398: DUMP FILE GENERATED AFTER "UNEXPECTED ISVALID() STATUS. RECOVERING." MESSAGE IN DB2DIAG.LOG

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

  • This problem only occurs in pureScale.  There is no impact to
    applications, but sometimes these messages can occur multiple
    times, producing many dump files in the db2dump directory.
    
    The following is an example:
    
    2019-03-16-22.20.37.048680+540 I55828528A2166       LEVEL:
    Severe
    PID     : 18022522             TID : 29864          PROC :
    db2sysc 1
    INSTANCE: db2inst1               NODE : 001           DB   : DB1
    HOSTNAME: hostname
    EDUID   : 29864                EDUNAME: db2loggw (DB1) 1
    FUNCTION: <0>, <0>, <0>, probe:700
    MESSAGE : Unexpected isValid() status. Recovering.
    DATA #1 : Hex integer, 4 bytes
    0xCFA2C0A4
    DATA #2 : SQLP_LRB, PD_TYPE_SQLP_LRB, 128 bytes
    state Hu (0x82) next 0 rsInfoIdx 0
    lockname 000E0000000000000000000076 SQLP_VALLOCK
    (SQLP_GLFH_NAME)
    groupmode .IN lrbHeaderFlag 0x0000 lrbHeaderFlag2 0x00 numConv 0
    notAwareAttributes 0x00 numSLSInFlight 0 numAgentsWithoutLrb 0
    holdingLLM 1
    cmrrIID 0 aggregatedrrIID 0
    lastGranted a00040016494fe0 lrb_list a00040016494fe0 hash_ptr
    a000400025b9c40 &#160;PLockDataPtr a000400001af1e8
    &#160; &#160; currentALS &#160;: seq=1200634, ss=1, H=.IN, G=.IN,
    SLSInFlags1=00(........), bcp=0, cma=00, coa=00, SLSOutFlags=00,
    ALSPad=00 00 00 00, SLSInFlags2=00, CH=NON, F=.IN, C=.IN, M=.IN,
    p=2, fa=00, ca=00
    &#160; inTransitALS &#160;: seq=1200634, ss=0, H=.IN, G=.IN,
    SLSInFlags1=00(........), bcp=0, cma=00, coa=00, SLSOutFlags=02,
    ALSPad=00 00 00 00, SLSInFlags2=00, CH=..S, F=.IN, C=.IN, M=.IN,
    p=2, fa=00, ca=00
    &#160; confirmedALS &#160;: seq=1200634, ss=1, H=.IN, G=.IN,
    SLSInFlags1=00(........)
    DATA #3 : SQLP_LRB, PD_TYPE_SQLP_LRB, 128 bytes
    state Lu (0x84) next 0 rsInfoIdx 0
    prev 0 tranChainPrev 0
    status G (0x01) mode .IN dur 1 convMode NON tran_handl 1
    holdcount 0 wantrrIID 0 &#160;rrIID 0 &#160;lrbFlag 0x0 chainNum 0
    lsoFeedback 0
    tran_chain 0 head_ptr a00040016494f60 awb_ptr 0
    cursorBitmap 0x40000000 hashResult 531305 wantAttributes 00
    priority 2 pad2 00
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    &#160; [0] 0x090000000D98A5CC
    get__17@157@sqlpValLotchFCUlT1CPCiCPCcT1 + 0x560
    ...
    
    
    2019-03-16-22.20.37.070959+540 I55834915A504 &#160; &#160; &#160; &#160;LEVEL: Info
    PID &#160; &#160; : 18022522 &#160; &#160; &#160; &#160; &#160; &#160; TID : 29864 &#160; &#160; &#160; &#160; &#160;PROC :
    db2sysc 1
    INSTANCE: db2inst1 &#160; &#160; &#160; &#160; &#160; &#160; &#160; NODE : 001 &#160; &#160; &#160; &#160; &#160; DB &#160; : DB1
    HOSTNAME: hostname
    EDUID &#160; : 29864 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;EDUNAME: db2loggw (DB1) 1
    FUNCTION: DB2 UDB, lock manager, sqlpLMERDumpOnEvent, probe:400
    MESSAGE : LMEVENTS successfully dumped to file
    DATA #1 : String, 86 bytes
    /log/db2dump/DIAG0001/18022522.001.DB1.2019-03-16-22.20.
    37.049780.lmevents.bin
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29398

  • 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-06-11

  • Closed date

    2020-01-18

  • Last modified date

    2020-01-18

  • 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

  • RB10 PSN

       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":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 January 2020