|
Problem IC81060
|
Status: Closed |
NEED A NEW REASON CODE FOR SQL0270N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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. |
| 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. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
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." |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88328
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.01.2012
10.12.2012
10.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
