IBM Support

IC75285: TRAP DURING REDISTRIBUTE ON AN MDC TABLE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During redistribution of an MDC table it is possible
    redistribute traps.
    
    The db2diag.log will have an entry similar to:
    
    2010-06-24-03.52.37.811838-240 I47542751A1762     LEVEL: Severe
    PID     : 155970               TID  : 15011       PROC : db2sysc
    220
    INSTANCE: bcuaix               NODE : 220         DB   : VLDB
    APPHDL  : 0-303                APPID: *N0.DB2.100624004151
    AUTHID  : BCUAIX
    EDUID   : 15011                EDUNAME: db2rcont 220
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:10
    MESSAGE : Possible memory corruption detected.
    DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x820F0002
    DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8
    bytes
    0x07000000d856f0e0
    DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes
    0x07000000D856F0C8 : FAB0 7000 000D 8560 2934 9619 008C FB2B
    ..p....`)4.....+
    0x07000000D856F0D8 : FAB0 7000 000D 8560
    ..p....`
    DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes
    0x07000000D856F0E0 : 0900 1000 A0C4 FD50 0000 0000 0000 0000
    .......P........
    0x07000000D856F0F0 : 0700 0000 D856 F0E0 0900 1000 A0C4 FDB8
    .....V..........
    0x07000000D856F100 : 0000 0000 0000 0000 0700 0000 C987 91A0
    ................
    CALLSTCK:
      [0] 0x09000000018634DC pdLog + 0xF8
      [1] 0x0900000001B2613C
    @79@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x14C
      [2] 0x0900000001921EF4 sqlofmblkEx + 0x58
      [3] 0x0900000000FEB99C zTrimToSize__22sqlucCDoublyLinkedListFv
    + 0x124
      [4] 0x0900000001D6AF5C zCleanUp__22sqlucCDoublyLinkedListFv +
    0xB4
      [5] 0x0900000002EDE1A8 zCleanUp__15sqlucCHashTableFv + 0xD0
      [6] 0x0900000001D824B0 zCleanUp__19sqlurCObjectManagerFv +
    0x430
      [7] 0x0900000002F37088 zCleanUp__23sqlurCObjectManagerListFv +
    0x498
      [8] 0x09000000041D7104
    zCleanUpTableCBs__27sqlurCSourceTargetPartitionFv + 0x1B4
      [9] 0x09000000041D5AE4
    zCleanUp__27sqlurCSourceTargetPartitionFv + 0xE8
    
    This APAR only affects MDC tables.
    

Local fix

  • Issue a REDISTRIBUTE CONTINUE command.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Redistribute                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V97 FP5.                                      *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 V97 FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75285

  • 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-03-25

  • Closed date

    2011-12-09

  • Last modified date

    2011-12-09

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

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

    IC75715

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC75285

Modified date: 09 December 2011