IBM Support

IT25572: UPGRADE FROM 10.1 FP5 TO 11.1 MAY CRASH ENGINE DURING DATABASE ACTIVATION

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

  • The instance may crash during database activation during upgrade
    with error message below:
    
    2018-02-11-02.45.27.769513-240 E8681168A1928        LEVEL:
    Severe
    PID     : 15728880             TID : 11567          PROC :
    db2sysc 0
    INSTANCE: xxxxx               NODE : 000           DB   :
    CMA01D
    APPHDL  : 0-26                 APPID: *LOCAL.DB2.180211064515
    AUTHID  : DB2CMA               HOSTNAME: xxxx
    EDUID   : 11567                EDUNAME: db2pkgrb (CMA01D) 0
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:999
    MESSAGE : Memory validation failure, diagnostic file dumped.
    DATA #1 : String, 28 bytes
    Corrupt pool free tree node.
    DATA #2 : File name, 34 bytes
    15728880.11567.mem_diagnostics.txt
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x090000001C855FE8
    diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb +
    0x4E8
      [1] 0x090000001C85E15C
    MemTreePut__13SQLO_MEM_POOLFP8SMemNodeUlP17SqloChunkSubgroup +
    0x6DC
      [2] 0x090000001C7F1868 sqlofmblkEx + 0xDE8
      [3] 0x0900000021721EA8
    sqlnxCreateHints__FP13sqlnxPlanInfoPvPP10sqlnxHintsUi + 0x1A8
      [4] 0x09000000228C2F8C
    sqlra_get_hints_for_all_sects__FP8sqlrr_cbPUciT2T3T2bPP15sqlra_s
    ect_hintPUl + 0x84C
      [5] 0x090000001F602C84
    sqlra_recreate_pkg__FP8sqlrr_cbiT2cP15sqlra_func_pathUc + 0x6D44
      [6] 0x09000000228C18F4
    sqlra_rebind_pkg__FP8sqlrr_cbPUcsT2T3T2iT7cP15sqlra_func_pathb +
    0x574
      [7] 0x090000001F6141B8
    sqlraFindInvalidPackagesAndRebindThem__FP8sqlrr_cb + 0x718
      [8] 0x090000001F612D34
    sqlraPackageRebinderDaemonInnerMain__FP8sqeAgent + 0x354
      [9] 0x090000001F61113C
    sqlraPackageRebinderDaemonOuterMain__FP8sqeAgent + 0x2BC
      [10] 0x090000002096D838
    sqleIndCoordProcessRequest__FP8sqeAgent + 0x2638
      [11] 0x090000001C8F90E8 RunEDU__8sqeAgentFv + 0xAA8
      [12] 0x090000001C8DBD20 EDUDriver__9sqzEDUObjFv + 0x2E0
      [13] 0x090000001C7CAC14 sqloEDUEntry + 0x374
      [14] 0x0900000000514E10 _pthread_body + 0xF0
      [15] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    

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

    IT25572

  • 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

    2018-07-03

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

  • 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":"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:
16 January 2020