DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

User's affected: All 
Problem summary: View of the Access Plan of an explainable 
statement generated the error  DBA3065E .

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
 

First fixed in v9.7 fp1

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.10.2009
15.01.2010
15.01.2010

9.7.FP1