|
Problem IC75364
|
Status: Closed |
Z/OS: EDM CREATION FAILS IF A PRIMARY KEY WITH SAME NAME EXIST IN ANOTHER TABLE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
This problem happens only on z/OS
If more than one table exist in the database with "same primary
key name" then
EDM creation gives error saying "The item with identity 'ID'
already exists in the metadata collection."
Repro.
--------
Create the following two tables in the database and try to
create EDM by using one of the table.
CREATE TABLE "NEWTON"."AT1"
(
"ID" INTEGER NOT NULL,
"NAME" CHAR(12),
PRIMARY KEY ("ID")
) !
CREATE TABLE "NEWTON"."AT2"
(
"ID" INTEGER NOT NULL,
"NAME" CHAR(12),
PRIMARY KEY ("ID")
) ! |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users on .NET Entity Framework executing against DB2 for *
* z/OS. *
****************************************************************
* PROBLEM DESCRIPTION: *
* If more than one table exist in the database with Primary *
* Key consisting of columns with same names ( see table defs *
* below ) then *
* EDM creation gives error saying "The item with identity 'ID' *
* already exists in the metadata collection." *
* *
* Table Definition Example: *
* *
* CREATE TABLE "NEWTON"."AT1" *
* ( *
* "ID" INTEGER NOT NULL, *
* "NAME" CHAR(12), *
* PRIMARY KEY ("ID") *
* ) ! *
* *
* CREATE TABLE "NEWTON"."AT2" *
* ( *
* "ID" INTEGER NOT NULL, *
* "NAME" CHAR(12), *
* PRIMARY KEY ("ID") *
* ) ! *
****************************************************************
* RECOMMENDATION: *
* Upgrade the client to version 9.7.4. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 4. This fix
pack should be applied on the client in order to resolve the
issue. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.03.2011
29.03.2011
29.03.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.4,
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
