IC86964: USING ANCHORED DATA TYPES CAN CAUSE AN UNEXPECTED ERROR WHEN THE ANCHOR OBJECT IS A TABLE WITH IMPLICITLY HIDDEN COLUMNS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • An anchored data type defines a data type based on another SQL
    object such as a column, global variable, SQL variable, SQL
    parameter, or the row of a table or view.  Unexpected errors
    including SQL0901N can occur when using anchored data types to
    anchor to the row of a table with implicitly hidden columns.
    
    Here is an example of the type of error that can occur when
    using these data types:
    
    create table tt1(c0 timestamp not null implicitly hidden
    generated always for each row on update as row change timestamp,
    c1 int, c2 varchar(10), c3 decimal(5,2))
    DB20000I  The SQL command completed successfully.
    
    create type r1 as row anchor row tt1
    DB20000I  The SQL command completed successfully.
    
    create type a1 as r1 array[]
    DB20000I  The SQL command completed successfully.
    
    create variable gv1 a1
    DB20000I  The SQL command completed successfully.
    
    set gv1[1] = null
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "Invalid
    collation ID".)
    SQLSTATE=58004
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to product version 9.7 fix pack 8.  Row data types   *
    * anchored to a table with implicitly hidden columns that were *
    * created on an earlier release will need to be dropped and    *
    * recreated.                                                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in version 9.7 fix pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC86964

  • 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-10-02

  • Closed date

    2013-04-01

  • Last modified date

    2013-04-01

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

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

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

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC86964

Modified date:

2013-04-01

Translate my page

Machine Translation

Content navigation