|
Problem IT03516
|
Status: Closed |
DB2 ALTOBJ FAILS TO RECREATE FOREIGN KEY WHICH REFERENCES PRIMARY KEY ON SAME TABLE AND SCHEMA NAME IS 8 CHARACTERS |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When running ALTOBJ on a table which has a Foreign Key which
references the Primary Key on the same table, the Foreign Key
will not be recreated if the schema name is eight characters
long. If the schema name is less than eight characters then the
Foreign Key will be recreated successfully.
In both cases the ALTOBJ command will report an SQL0204N error,
but this related to trying to drop the Foreign Key after it has
already been dropped when the Primary Key was dropped. This
message is not related to the Foreign Key not being recreated
successfully. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW 10.5 FixPack 5 *
**************************************************************** |
| Local Fix: |
Manually recreate Foreign Key. |
| Solution |
Fixed in DB2 LUW 10.5 FixPack 5 |
| Workaround |
see LOCAL fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.07.2014
18.05.2017
18.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
