DB2 FOR LUW / DB2FORLUW / 970 - DB2

If there are multiple comments attached to a table and its 
columns, and these comments exceed 1kB in size, 
OTM cannot be used to move the table.  ADMIN_MOVE_TABLE fails 
with a sytax error, since the COMMENT ON 
statement that copies the remarks gets truncated. 
 
The error will be seen if the length of the command to set the 
comments exceeds 1kb: 
 
COMMENT ON "SCHEMA"."TABLE" ("COL1" IS 'This is the comment for 
col1', "COL2" IS 'This is the comment on col2', ... etc.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of ADMIN_MOVE_TABLE with comments exceeding 1kb.       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ADMIN_MOVE_TABLE can fail with SQL0010N or a SQL0104N syntax * 
* error due to the length of comments.                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7.                       * 
****************************************************************

Shorten the length of comments on the table/columns.

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
 

First fixed in DB2 Version 9.7 Fix Pack 7.

Shorten the length of comments on the table/columns.

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

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

18.07.2012
24.10.2012
24.10.2012

9.7.FP7