IBM Support

JR42934: INDEXES WITH TWO OR MORE COLUMNS OF "DESC" ORDERING ARE NOT EXTRACTED PROPERLY WHEN REVERSE-ENGINEERING AN ORACLE DATABASE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When an Oracle database in reverse-engineered in InfoSphere Data
    Architect, indexes which have two or more columns of DESC
    ordering get misinterpreted and instantiated in the resulting
    physical data model as indexes which all columns are copies of
    the last DESC column.
    The same phenomenon can be observed when browsing an Oracle
    database in "Data Source Explorer" view.
    

Local fix

Problem summary

  • Reverse-engineers Oracle database and then generates DDL from
    the resulting physical data model. If index has more than one
    DESC columns then all these column will be reverse-engineered as
     the duplications.
    

Problem conclusion

  • The issue is fixed.
    Please upgrade to the latest IBM InfoSphere Data Architect.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR42934

  • Reported component name

    INFO DATA ARCHI

  • Reported component ID

    5724V1500

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-24

  • Closed date

    2014-10-03

  • Last modified date

    2014-10-03

  • 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

    INFO DATA ARCHI

  • Fixed component ID

    5724V1500

Applicable component levels

  • R810 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 October 2014