IC89495: INCORRECT RESULTS ON RANGE PARTITIONED TABLE WITH XML COLUMN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Background Information:
    
    1) Table partitioning allows for the efficient roll-in and
    roll-out of table data. The ALTER TABLE statement with the
    ATTACH PARTITION clause makes data roll-in very easy. It takes
    an existing table (source table) and attaches it to the target
    table as a new data partition. The newly attached data partition
    is unavailable to queries initially after the attach statement
    is complete, while the rest of the table remains online after
    attach. SET INTEGRITY is required to perform range checking,
    constraint checking, and maintenance of the non-partitioned
    indexes before bringing the partition online.
    
    2)  Whenever you create an XML column, an XML path index is
    automatically created by the DB2 software on the XML column.
    The XML path index records all unique paths which exist within
    XML documents stored in an XML column.
    
    3) Certain database operations, such as a rollforward through a
    create index that was not fully logged, can cause an index
    object to become invalid. This is because the index is not
    created during the rollforward operation.  When the database
    manager detects that an index is no longer valid, it
    automatically attempts to rebuild it.  When the rebuild takes
    place, it is controlled by the indexrec parameter of the
    database or database manager configuration file.
    
    Problem Details:
    
    The XML path index on a range partitioned table might be rebuilt
    through the REORG command, or because it was previously marked
    invalid and DB2 has decided to rebuild it. If this occurs while
    there exists a partition that has been attached but not brought
    online using SET INTEGRITY, then the XML path index is rebuilt
    without including the paths from the newly attached partition.
    This can result in incorrect results when scanning an XML values
    index, if the newly attached partition contains paths that are
    not found in any of the other partitions.
    

Local fix

  • Run SET INTEGRITY on the table and then rebuild the indexes
    with the REORG INDEXES command.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of partitioned tables with XML columns             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7.0.8.                              *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in DB2 version 9.7.0.8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89495

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-11

  • Closed date

    2013-03-25

  • Last modified date

    2013-03-26

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

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

    IC89818

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC89495

Modified date:

2013-03-26

Translate my page

Machine Translation

Content navigation