DB2 FOR LUW / DB2FORLUW / 950 - DB2

Control Center Visual Explain of a query involving index objects 
will fail when client is down level to a V97 server. 
 
For example, the following objects exists on a V9.7 server: 
server: 
create table s.t1 (i int); 
create index s.i1 on s.t1 (i); 
create table s.t2 (i int); 
 
From a down level client (such as V9.1 or V9.5) running Visual 
 
Explain from Control Center, 
- Explain of query "select * from s.t2" succeeds as the table 
has no indexes. 
- Explain of query "select * from s.t1" fails because the table 
has an index.  The error observed is "DBA3065E Snapshot cannot 
be processed due to a CLI error."

**************************************************************** 
* USERS AFFECTED:                                              * 
* Below v97                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* CONTROL CENTER VISUAL EXPLAIN OF A QUERY INVOLVING INDEX     * 
* OBJECTS FAILS WHEN CLIENT IS DOWN LEVEL TO A V97 SERVER      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.5 Fix Pack 6                                   * 
****************************************************************

Upgrade the client to V9.7.

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
 

Problem was first fixed in Version 9.5 Fix Pack 6.

keiner bekannt / siehe Local-Fix

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

20.04.2010
14.05.2010
14.05.2010

9.5.FP6