DB2 FOR LUW / DB2FORLUW / 970 - DB2

When you do the following sequence of actions: 
 
 1. Start Control Center. 
 2. Expand the Databases list and pick a database to connect to. 
 3. Expand the Tables folder or the Views folder. 
 4. Double click (or Open or Query) on any row in which the 
    table name or view name appears in double quotes. 
 
 
then you get an error which includes this text: 
 
 SQL0104N  An unexpected token """" was found following 
 
 
An example of the full text of an error message you might get is 
this: 
 
   com.ibm.db.DataException: A database manager exception 
   occurred. : 
   [IBM]{CLI Driver][DB2/AIX64] SQL0104N An unexpected token "" 
   was 
   found following "ELECT * FROM SYSCAT.". Expected tokens may 
   include: 
   "<space>". SQLSTATE=42601 
 
 
Table names and view names that appear in double quotes in 
Control Center include: 
- those which are reserved words, such as 
   SYSCAT."REFERENCES" or SYSIBMADM."PRIVILEGES", 
- those which include lower case letters.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of Control Center with DB2 for Linux, UNIX and Windows * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************

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 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a 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
 

Problem was first fixed in Version 9.7 Fix Pack 2

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC64415 
Nachfolger : 

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

27.10.2009
25.01.2011
25.01.2011

9.7.FP2