|
Problem IT00502
|
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 / A10 - 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 Version 10.1, Fixpack 5 *
**************************************************************** |
| Local Fix: |
n/a |
| Solution |
First fixed in DB2 Version 10.1, Fixpack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.03.2014
14.07.2015
14.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
