DB2 FOR LUW / DB2FORLUW / 970 - DB2

When trying to shrink the length of a VARCHAR type column, you 
may receive a SQL0901N. 
 
For example, 
create table t(c1 varchar(10)) 
 
insert into t(c1) values ('abcde     ') 
 
alter table t alter column c1 set data type varchar(5) 
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 "Unexpected data partitioning PD version number".) 
SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running DB2 Version 9.7 on Linux, Unix or Windows  * 
* platform and decreasing the length of a varchar              * 
* type column via alter table statement                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update the DB2 Version 9.7 Fix Pack 7.                       * 
****************************************************************

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

This problem is first fixed in DB2 Version 9.7 Fix Pack 7.

keiner bekannt / siehe Local-Fix

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

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

05.07.2012
20.10.2012
20.10.2012

9.7.FP7