|
Problem IT00496
|
Status: Closed |
RUNNING DB2LOOK WITH "-X" AND "-CT" OPTIONS WHEN USING DB2_COMPATIBILITY_VECTOR=ORA COULD FAIL WITH AN SQL0407N ERROR. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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@ |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
n/a |
| Solution |
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.03.2014
06.10.2014
06.10.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
