IBM Support

IC95786: -901 IN REDISTRIBUTE ABORT AFTER SUCCESSFUL REDISTRIBUTE ABORT/CONTINUE WITH EXCLUDE KEYWORD.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The problem is specific to EXCLUDE clause on ABORT/CONTINUE
    operation.
    There are two similar problems, both lead to complete table
    data loss.
    
    1. If two tables have to be recovered, then a successful
    recovery of just one (second is EXCLUDEd) clears recovery info
    about the second one. The second table is left in limbo - it
    can't be
    recovered from redistribute, and can't be accessed.
    
    2. If two tables have to be recovered, but one failed when
    redistribute was going in CONTINUE direction and another failed
    when redistribute was going in ABORT direction, then
    redistribute recovery can't recover one of the two.
    
    
    ==
    Sample scenario (assume two tables, t1 and t2):
    REDISTRIBUTE ADD NODE - failed while redistributing table t1
    REDISTRIBUTE ABORT EXCLUDE T1 - failed while redistributing t2
    
    At this point both tables require redistribute recovery, and
    either recovery info from one of them will be removed (if
    EXCLUDE clause is specified), or only one is recovered (if no
    EXCLUDE clause is specified).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DPF environment only, after running REDISTRIBUTE             *
    * ABORT/CONTINUE command with EXCLUDE option.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 97 fix pack 9                         *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in v97 fix pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95786

  • 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

    2013-09-06

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

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

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

    IC95947 IC95948

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC95786

Modified date: 17 December 2013