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