DB2 FOR LUW / DB2FORLUW / 970 - DB2

Problem recreation : 
 
a. Create table A 
b. Create table B 
C. Run RUNSTATS on the tables 
d. Create view using two tables 
e. Tried to drop some column on table A  and got: 
 
DB21034E  The command was processed as an SQL statement because 
it was not a valid Command Line Processor command.  During SQL 
processing it returned: 
SQL0901N  The SQL statement failed because of a non-severe 
system error.Subsequent SQL statements can be processed. 
(Reason "column number out of range".)  SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* Unknown                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL0901N "COLUMN NUMBER OUT OF RANGE" WHEN DROPPING A        * 
* COLUMNProblem recreation :a. Create table Ab. Create table   * 
* BC. Run RUNSTATS on the tablesd. Create view using two       * 
* tablese. Tried to drop some column on table A  and           * 
* got:DB21034E  The command was processed as an SQL            * 
* statementbecauseit was not a valid Command Line Processor    * 
* command.  DuringSQLprocessing it returned:SQL0901N  The SQL  * 
* statement failed because of a non-severesystem               * 
* error.Subsequent SQL statements can be processed.(Reason     * 
* "column number out of range".)  SQLSTATE=58004               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 2.                       * 
****************************************************************

N/A

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 DB2 Version 9.7 Fix Pack 2.

keiner bekannt / siehe Local-Fix

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

22.10.2009
29.06.2010
29.06.2010

9.7.FP2