|
Problem IC64733
|
Status: Geschlossen |
VISUAL EXPLAIN FAILS WITH DBA3065E(SNAPSHOT CANNOT BE PROCESSED DUE TO A CLI ERROR) WHEN QUERY ACCESS PLAN HAS A MERGE JOIN |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
When trying to get an access plan via DB2 Visual Explain, you
might encounter the error DBA3065E (Snapshot cannot beprocessed
due to a CLI error) when the query access plan has a Merge Join
operator in it.
This problem was introduced into V91 FP7, V95 FP4 and V97 GA.
To confirm this fix will correct the DBA3065E error from Visual
Explain, you can use the "db2exfmt" tool to manually get the
access plan from the Explain Facility and then check if there is
a MSJOIN operator in the plan by examining the output from
"db2exfmt".
The fix for this problem should be applied to the DB2 server
side. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users of version 9.1 on Linux, Unix andWindowsplatforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When trying to get an access plan via DB2 Visual Explain,you *
* might encounter the error DBA3065E (Snapshot cannot *
* beprocessed due to a CLI error) when the query access plan *
* has a Merge Join operator in it. This problem was introduced *
* into V91 FP7, V95 FP4 and V97 GA. To confirm this fix will *
* correct the DBA3065E error from Visual Explain, you can use *
* the "db2exfmt" tool to manually get the access plan from the *
* Explain Facility and then check if there is a MSJOIN *
* operator in the plan by examining the output from"db2exfmt". *
* The fix for this problem should be applied to the DB2 *
* serverside. *
****************************************************************
* RECOMMENDATION: *
* Upgrade the server to DB2 Linux, Unix and Windows, *
* Version9.1 FixPak 9 or higher levels. *
**************************************************************** |
| Local-Fix: |
View the access plan with the Explain Facility and the db2exfmt
tool. |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
First fixed in DB2 Linux, Unix and Windows, Version 9.1 FixPak
9. |
| Workaround |
View the access plan with the Explain Facility and the db2exfmt
tool. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.11.2009
03.05.2010
03.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.0.,
9.1.
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.9
|
 |
