IBM Support

IC79340: DB2 DATABASE SERVER RUNS OUT OF ENTRIES IN RESYNC LIST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In a distributed unit of work (DUOW) environment, transactions
    which have been prepared but not yet committed are kept in a
    linked resync list. This list is used to recover from
    transaction commit or rollback failures due to network,
    hardware, or software failures. The resync list is stored in the
    resync heap with a fixed size, which is in the shared memory of
    the server.
    
    If there are a lot of outstanding DUOW transactions, DB2
    database server can run out of entries in Resync List during
    user activities or during crash recovery with the following
    message in db2diag.log:
    
    2011-09-23-15.08.39.785187-420 E1503306A441       LEVEL: Severe
    
    PID     : 758298               TID  : 110442      PROC : db2sysc
    0
    
    INSTANCE: test                NODE : 000         DB   : SAMPLE
    
    APPHDL  : 0-40210              APPID:
    
    USPCCW01.INA400.C86AD450D8A8
    
    AUTHID  : user
    
    EDUID   : 110442               EDUNAME: db2agent (SAMPLE) 0
    
    FUNCTION: DB2 UDB, base sys utilities, sqleAddEntryToResync,
    
    probe:20
    
    MESSAGE : Out of ResyncEntries!
    
    
    
    In case that crash recovery hits this symptom, crash recovery
    fails. In other cases, if APAR IC79235 has not been fixed yet,
    DB2 database server traps afterward, otherwise user's sql fails.
    

Local fix

  • Increase NUMDB in DBM CFG, restart DB2 database server and
    restart database.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 7                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79340

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-20

  • Closed date

    2012-12-31

  • Last modified date

    2012-12-31

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

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

    IC88637

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
31 December 2012