DB2 FOR LUW / DB2FORLUW / A50 - DB2

Running db2look on a database that has 
DB2_COMPATIBILITY_VECTOR=ORA set could fail with an SQL0407N 
error. 
 
For example: 
 
$ db2 "grant dbadm without accessctrl on database to user 
zurbie" 
DB20000I  The SQL command completed successfully. 
 
$ db2look -d test -e -a -ct -l -td @ -x -o db2look.sql 
-- Generate statistics for all creators 
-- Creating DDL for table(s) 
-- Output is sent to file: db2look.sql 
 
$ more db2look.sql 
-- This CLP file was created using DB2LOOK Version "10.5" 
-- Timestamp: Thu 20 Mar 2014 05:30:30 PM EDT 
-- Database Name: TEST 
-- Database Manager Version: DB2/LINUXZ64 Version 10.5.2 
-- Database Codepage: 1208 
-- Database Collating Sequence is: IDENTITY 
 
CONNECT TO TEST@ 
 
Call DB2LK_GENERATE_DDL failed, sqlcode is -443@ 
 
*RATE_DDLﾘﾘSQL0407 Reason code or token: TBSPACEID=3, TABLEID=7, 
COLNOSQLERFRP@

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher.                                           * 
****************************************************************

n/a

Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4)

keiner bekannt / siehe Local-Fix

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

21.03.2014
06.10.2014
06.10.2014