IBM Support

IC75364: Z/OS: EDM CREATION FAILS IF A PRIMARY KEY WITH SAME NAME EXIST IN ANOTHER TABLE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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")
    ) !
    

Local fix

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.                         *
    ****************************************************************
    

Problem conclusion

  • 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.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75364

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-29

  • Closed date

    2011-03-29

  • Last modified date

    2011-03-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC75364

Modified date: 29 March 2011