|
Problem IC63935
|
Status: Closed |
IN CONTROL CENTER WHEN TRYING TO VIEW THE ACCESS PLAN OF AN EXPLAINABLE STATEMENT RECEIVE THE FOLLOWING ERROR: DBA3065E |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In Control Center when you try to view the Access Plan of an
Explainable Statement a DBA3065E error is returned.
DBA3065E Snapshot cannot be processed due to a CLI error.
From control center:
1. Click on Application Objects/packages under the database you
want to connect to
2. Locate a package which you know has been bound with the
explain yes and explain snapshot yes options
3. Right click and select Show explainable statements
4. Statement are listed and show a total cost value (which
confirms that they were bound with explain yes)
5. Select one row with a right click and select 'Show Access
Plan'
6. get the DBA3065E error. Click close
7. get another error with this text
[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "." was
found following ".SECTNOFROM VCSTSTNT". Expected tokens may
include: ",".
SQLSTATE=42601 |
| Problem Summary: |
User's affected: All
Problem summary: View of the Access Plan of an explainable
statement generated the error DBA3065E . |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 v9.7 fp1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
15.01.2010
15.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
