IBM Support

IC71684: CRASH OCCURS ON UPGRADED DATABASE WHEN VIEWS QUERY COLUMNS CASTED TO LOB TYPES.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Crash may occur when views query columns which have been casted
    to LOB types,  after upgrading to v9.7. i.e ALL views that have
    the LOB type column "derived" by using the cast function on a
    varchar column.
    
    Upgrade logic is responsible for not preserving appropriate
    internal values, that can lead to under allocated memory,
    resulting in memory overwrites.
    

Local fix

  • 1) For databases that have not been upgraded, upgrading these
    databases using a fix pack containing this fix will avoid this
    issue.
    2) Databases that have already been upgraded to v97 Fix Pack 3
    or earlier may encounter this issue.  Dropping and recreating
    the views will fix the issue.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 V97                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * CRASH OCCURS ON UPGRADED DATABASE WHEN VIEWS QUERY COLUMNS   *
    * CASTED TO LOB TYPES.                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V97 FP4                                       *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 V97 FP4
    

Temporary fix

  • 1) For databases that have not been upgraded, upgrading these
    
    databases using a fix pack containing this fix will avoid this
    issue.
    2) Databases that have already been upgraded to v97 Fix Pack 3
    or earlier may encounter this issue.  Dropping and recreating
    the views will fix the issue.
    

Comments

APAR Information

  • APAR number

    IC71684

  • 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

    2010-10-05

  • Closed date

    2011-05-02

  • Last modified date

    2011-05-02

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

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

    IC71797

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC71684

Modified date: 02 May 2011