DB2 FOR LUW / DB2FORLUW / 970 - DB2

Create nickname command reduces the length of DBCLOB column 
 
CREATE TABLE "TT123" ("C1" DBCLOB(536870915) ) 
OPTIONS(REMOTE_SERVER 'SERVER1', REMOTE_SCHEMA 'xxxx') 
DB20000I  The SQL command completed successfully. 
 
CREATE NICKNAME "NICK12" FOR "SERVER1"."xxxx"."TT123" 
DB20000I  The SQL command completed successfully. 
 
describe table "NICK12" 
 
                                Data type 
Column 
Column name                     schema    Data type name 
Length     Scale Nulls 
------------------------------- --------- ------------------- 
---------- ----- ------ 
C1                              SYSIBM    DBCLOB 
536870911     0 Yes 
 
  1 record(s) selected. 
 
Once the issue is fixed: 
 
describe table "NICK12" 
 
                                Data type 
Column 
Column name                     schema    Data type name 
Length     Scale Nulls 
------------------------------- --------- ------------------- 
---------- ----- ------ 
C1                              SYSIBM    DBCLOB 
1073741823     0 Yes 
 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL V9.7 FEDERATED SERVER USERS                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 9.                              * 
****************************************************************

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
 

Fixed in DB2 V9.7 Fix Pack 9

keiner bekannt / siehe Local-Fix

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

06.09.2013
16.06.2014
16.06.2014

9.7.FP9