IBM Support

IC81060: NEED A NEW REASON CODE FOR SQL0270N

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This defect relates to the defect 322376.
    
    In 322376, I will implement a fix to block a certain operation
    and report SQL0270N. We need a new reason code for this.
    
    The text for this new reason code should be
    
    "DELETE or UPDATE to a replicated materialized query table that
    includes FETCH FIRST n ROWS ONLY clause or any non-deterministic
    operation, which may result in a random set of rows are deleted
    or updated,  is not supported."
    
    This fix will be forwarded to db2_v97 too. It would be good to
    have the same reason code across releases.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of V9.7                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SQL0270N error code didn't return a good error description   *
    * for replicated materialized query table.                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to latest fix pack.                                  *
    ****************************************************************
    

Problem conclusion

  • Added new reasone code to SQL0270N.
    
    "DELETE or UPDATE to a replicated materialized query table
    that
    includes FETCH FIRST n ROWS ONLY clause or any
    non-deterministic
    operation, which may result in a random set of rows are
    deleted
    or updated,  is not supported."
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81060

  • 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-01-27

  • Closed date

    2012-12-10

  • Last modified date

    2012-12-10

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

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

    IC88328

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

Modified date: 10 December 2012