|
Problem IC64734
|
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 / 970 - 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.7 on Linux, Unix and Windows *
* platforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When trying to get an access plan via DB2 Visual *
* Explain,you might encounter the error DBA3065E *
* (Snapshot cannot be processed 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 V97GA.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 *
* theDB2 server side. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.7 FixPak 2 or higher levels. *
**************************************************************** |
| Local Fix: |
View the access plan with the Explain Facility and the db2exfmt
tool. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.7 FixPak 2. |
| Workaround |
View the access plan with the Explain Facility and the db2exfmt
tool. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.11.2009
25.05.2010
03.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
