IBM Support

IC85568: DB2LOOK & SYSDATAPARTITIONS(LOWVALUE & HIGHVALUE) CAN PRODUCE INCORRECT STRING REPRESENTATION FOR PARTITIONING RANGE VALUES.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • db2look & SYSDATAPARTITIONS(LOWVALUE & HIGHVALUE) can produce
    incorrect string representation for partitioning range values.
    This issue has only been see using "FOR BIT DATA" on the DATA
    PARTITIONS columns.
    
    Example:
    
    create table t1 (c1 varchar(4) for bit data not null) partition
    by range (c1) (part p0 starting (X'00000000'), part p1 starting
    (X'10000000'), part p2 starting (X'20000000') ending
    (X'FFFFFFFF'))
    
    P0 (X'00000000 - X'0FFFFFFF)
    P1 (X'10000000 - X'1FFFFFFF)
    P2 (X'20000000 - X'FFFFFFFF)
    
    Proposal:
    
    create table t1 (c1 varchar(4) for bit data not null) partition
    by range (c1) (part p0 starting MINVALUE inclusive ending
    (X'0FFFFFFF') inclusive, part p1 starting (X'0FFFFFFF')
    exclusive ending (X'1FFFFFFF') inclusive, part p2 starting
    (X'1FFFFFFF') exclusive ending (X'FFFFFFFF'))
    
    P0 (MINVALUE - X'0FFFFFFF)
    P1 (X'10000000 - X'1FFFFFFF)
    P2 (X'20000000 - X'FFFFFFFF)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7 Fixpack 7 or Higher                          *
    ****************************************************************
    

Problem conclusion

  • First Fixed in v9.7 Fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85568

  • 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

    2012-07-27

  • Closed date

    2012-10-30

  • Last modified date

    2012-10-30

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

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

    IC88634

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 #: IC85568

Modified date: 30 October 2012