|
Problem IC64635
|
Status: Closed |
VISUAL EXPLAIN FAILS WITH DBA3065E(SNAPSHOT CANNOT BE PROCESSED DUE TO A CLI ERROR) WHEN QUERY ACCESS PLAN HAS A MERGE JOIN |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
When trying to get access plan via DB2 Visual Explain, you might
encounter DBA3065E(Snapshot cannot be processed due to a CLI
error) when query access plan has a merge join operator.
This problem was introduced into V91 FP7, V95 FP4 and V97 GA.
To confirm this problem when Visual Explain encountered
DBA3065E, you can use "db2exfmt" tool to manually get the access
plan from Explain Facility and then check if there is a MSJOIN
operator in the plan.
The fix of this problem should be applied to the DB2 server
side. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of version 9.5 on Linux, Unix and *
* Windowsplatforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When trying to get an access plan via DB2 Visual Explain,you *
* might encounter the error DBA3065E (Snapshot *
* cannotbeprocessed due to a CLI error) when the query access *
* planhas a Merge Join operator in it.This problem was *
* introduced into V91 FP7, V95 FP4 and V97GA.To confirm this *
* fix will correct the DBA3065E error fromVisual Explain, you *
* can use the "db2exfmt" tool to manuallyget the access plan *
* from the Explain Facility and then checkif there is a MSJOIN *
* operator in the plan by examining theoutput from *
* "db2exfmt".The fix for this problem should be applied to the *
* DB2 serverside. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.5 FixPak 6 or higher levels. *
**************************************************************** |
| Local Fix: |
View the access plan with the Explain Facility and the db2exfmt
tool. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.5 FixPak 6. |
| Workaround |
View the access plan with the Explain Facility and the db2exfmt
tool. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC64733 IC64734
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2009
10.06.2010
10.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
