IBM Support

PM44288: FAILURE TO CREATE FOREIGN KEY INDEXES ON ORACLE

Fixes are available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Failure to create foreign key indexes on Oracle
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    By default, Oracle does not create indexes on foreign keys.
    They must be created manually, and failure to do so, could
    lead to slower ClearQuest performance.
    

Problem conclusion

  • A fix is available in ClearQuest 8.0.0.10 and 8.0.1.3.
    
    ClearQuest now explicitly creates the indexes for foreign
    keys on Oracle databases.  This is now consistent with our
    other database vendors (DB2 and SQL Server).
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM44288

  • Reported component name

    CQ&CQ MSITE UNI

  • Reported component ID

    5724G3801

  • Reported release

    711

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-22

  • Closed date

    2014-03-25

  • Last modified date

    2014-03-25

  • 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

    CQ&CQ MSITE UNI

  • Fixed component ID

    5724G3801

Applicable component levels

  • R711 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
25 March 2014