Release Notes
Abstract
This document provides the list of APARs fixed in InfoSphere Data Architect version 9.1.3.
Content
| APAR | APAR Number | PMR Number | Description |
|---|---|---|---|
|
Special Patch
|
01198,618,618
|
Creation of an UML model fails in InfoSphere Data Architect v9.1.3. | |
|
APAR 10
|
JR58222
|
When we use publish for web functionality on a package other than the root package, the diagrams are not clickable | |
|
JR58198
|
Constraints displayed in duplicity in Data source explorer | ||
|
JR58198
|
Table Constraint Issue | ||
|
JR56307
|
IDA does not generate Delta DDL Script as expected | ||
|
JR58095
|
Facing issue to generate 'comment' column in MySQL when transforming logic model to physical model | ||
|
JR58233
|
IDA, Generate DDL with dependent views out of sequence | ||
|
JR58376
|
Data types defined in the *.ddm incorrectly map in json schema | ||
|
JR58240
|
Incorrect sequence of insert into statement in Generate DDL in Oracle | ||
|
JR58456
|
MaxItems: -1 is not according to JSON schema specification, LDM to JSON | ||
|
APAR 9
|
JR56531
|
IDA generating SQL with syntax error on PostgreSQL. In Delta DDL a syntax errors occurs, putting twice the symbol ';' in the end of line that correspond to the index change. | |
|
JR57852
|
IDA is adding Alternate keys to existing relationship and generalizations in a logical model additional to the existing primary keys automatically. | ||
|
JR54496
|
Generated value not get set in the publish model. | ||
|
JR58099
|
Generate expression for temporary table DB2 Z/OS. | ||
|
JR58007
|
Cannot generate DDL for tables with XML columns in DB2 Z/OS. | ||
|
JR57572
|
In Dimension Model when adding dependency, the Dependency Type is not being saved. | ||
|
JR58014
|
With table organization set as ‘COLUMN’, I get the following error for all unique constraints in the model when running the ‘Analyse Model’ function. | ||
|
JR57790
|
If on a specialization, an AK is defined and the implementation of the specialization is a roll down, then the Unique constraints in the PDM have a name that deviates from the standards set in the naming convention. | ||
|
JR58002
|
Maximum length specification error (MaxItem: -1) when transforming a PDM to JSON Schema in Data Architect. | ||
|
JR58221
|
IDA unable to connect to DM server and unable to publish the models to DM server. | ||
|
APAR 8
|
JR56143
|
Addresses the issue wherein SQL generate the PK/UK and its index in wrong order. | |
|
JR57573
|
Addresses the issue wherein Oracle SQL generates wrong DDL of the Sequence. | ||
|
JR57577
|
Addresses the issue wherein Oracle wrong DDL of the Sequence is generated in correct delete index statements. | ||
|
JR57579
|
Addresses the issue wherein Oracle IOT table Delta DDL generation problem. | ||
|
JR57578
|
Addresses the issue wherein Oracle do not disable check constraint correctly. | ||
|
JR57580
|
Addresses the issue wherein generate DDL for view, does not generate the labels. | ||
|
APAR 7
|
JR56698
|
Addresses the issue wherein a SQL syntax error occurs when an Oracle model is compared. | |
|
JR56770
|
Addresses the issue wherein PostgreSQL FK constraints from the Data Source Explorer failed to show the UK of the parent table in the details view. | ||
|
JR56521
|
Addresses the issue wherein the creation of the index was missing in the deltaDDL usecase for Oracle. | ||
|
JR56771
|
Addresses the issue wherein the Oracle system partitions show up in data source explorer. | ||
|
JR56579
|
Addresses the issue wherein the unique key exceeds 30 characters in length for an Oracle data model. | ||
|
60689,999,631
|
Addresses the issue wherein the DDL is not generated for an index on temporary table. | ||
|
61755,999,631
|
Addresses the issue wherein there was a difference in deltaDDL when synchronizing at schema level vs table level. | ||
| [Misc] - Support of DB2 for z/OS v12. | |||
|
APAR 6
|
JR56309
|
Addresses an empty delta DDL issue with physical data model changes against Oracle database. | |
|
JR56530
|
Addresses an issue whereas DDL is not generated for index on Oracle temporary table. | ||
|
JR56137
|
Addresses an issue of LDM to PDM transformation where only one auxiliary table was created for more than one table with LOB columns. | ||
|
JR56139
|
Addresses an issue in Data Source Explorer where unique keys in PostgreSQL are shown incorrectly. | ||
|
JR56512
|
Addresses an issue wherein the partition does not show using oracle 12 driver. | ||
|
JR56117
|
Addresses an issue of LDM to PDM transformation on required attributes. | ||
|
JR56489
|
Addresses an issue of delta DDL generation for changes to an Oracle table with partitioned indexes. | ||
|
JR56166
|
Addresses an issue with the Netezza delta DDL generator where ALTER TABLE is not generated for renamed nullable columns. | ||
| [PatchFix 92034] - Addresses an issue of validation where OracleLocalIndexPartitionKeyColumnsCheck could not be found. | |||
|
APAR 5
|
JR55657
|
Addresses the issue of comparing a table that is partitioned by list. | |
|
JR55836
|
Addresses the issue of abbreviations not being defined properly on transformation. | ||
|
JR54685
|
Addresses the issue of wrong DDL of the PK index. | ||
|
JR55532
|
Addresses the issue of unhandled event loop exception. | ||
|
JR55519
|
Addresses the issue of modifying a PK in an IOT Table. | ||
|
JR55774
|
Addresses the issue of wrong order of DDL statements. | ||
|
JR55864
|
Addresses the issue of unnecessary drop view statement in the generated delta DDL. | ||
|
PI60816
|
Addresses the delta DDL issue on tables containing a LOB column with an auxiliary table and an auxiliary index. | ||
|
60250,999,631
|
Addresses the issue on transformation from LDM to PostgresSQL database. | ||
|
31833,075,724
|
IDA Reverse Engineering of a DB2 10.5 Database returns a corrupt DBM file. | ||
|
60147,999,631
|
Addresses the Oracle 10g partition issue. | ||
|
60269,999,631
|
Addresses an issue on differences about default value NULL . | ||
|
APAR 4
|
JR55260
|
Addresses the issue that appears while adding and removing columns in a Oracle PDM | |
|
JR54973
|
Addresses the issue wherein modification of the datatype in a column results in the related index and constraint being dropped. | ||
|
JR55628
|
Addresses the issue wherein incorrect alter index syntax is generated for an Oracle partitioned index | ||
|
JR55022
|
Addresses the issue of incorrect DDL for Index Organized Tables (IOT) | ||
|
JR54973
|
Addresses an issue of delta DDL generation wherein modifying a column causes drop and recreate | ||
|
JR54838
|
Addresses the issue related to super user in PostGreSQL while reading catalog objects. | ||
|
59634,999,631
|
Addresses the ClassCast issue that happens when the LDM is transformed to a PDM. | ||
|
APAR 3
|
JR55356
|
Addresses two more comparison issues involving Oracle partitioned tables. | |
|
JR55178
|
Addresses the issue of incorrect behavior when Alter Table of Oracle data source with constraints. | ||
|
JR54662
|
Addresses the issue of differences on default value NULL when comparing PDM and database. | ||
|
54223,999,631
|
Addresses the issue wherein the check constraint name is truncated incorrectly. | ||
|
57431,999,631
|
Addresses the issue wherein the DDL had more than 30 characters. | ||
| [PatchFix 84515] - Recognizes unsupported versions of LUW. | |||
|
APAR 2
|
JR54554
|
Addresses the issue wherein unexpected results were being shown in the compare editor | |
|
JR54866
|
Addresses the issue wherein incorrect DDL was being generated when a datatype or length of a column that represents a partition key of a partitioned Oracle table was changed. | ||
|
JR54996
|
Addresses the issue wherein duplicate check constraints for postgres were being shown. | ||
|
JR55015
|
Addresses a modeling issue on the length qualifier of Oracle character columns | ||
|
JR55045
|
Addresses the issue of single quotes in the generated DDL for Oracle columns of RAW data type with a default expression | ||
|
54223,999,631
|
Addresses the issue wherein the check constraint name was being truncated incorrectly during an LDM to PDM transformation. | ||
|
55295,999,631
|
Addresses the issue with the search conditions for check constraints. | ||
|
77594,082,000
|
Addresses the issue wherein the schema contents were not showing up in the data project explorer. | ||
|
APAR 1
|
JR54205
|
Added the ability of analyze model to detect foreign keys containing non-local attributes. | |
|
JR54556
|
Addresses the issue of empty delta DDL when compare and sync SQL expression of views. | ||
|
JR54476
|
Addresses the issue where the tablespace property of an index is not loaded from the database. | ||
|
JR54523
|
Addresses the issue in which empty delta DDL was generated for oracle models. | ||
|
JR54623
|
Addresses the issue with datatypes of Teradata during transformation. | ||
|
JR54673
|
Addresses the issue during transformation of logical atomic model to physical model. | ||
|
JR54754
|
Addresses the issue in which the items in data project explorer were not sorted properly. | ||
|
JR54586
|
Addresses the issue in which the oracle initTrans parameter was not loaded for partitioned tables. | ||
|
JR54554
|
Addresses the issue in which the interval partitioned table was missing the tablespace storage property. | ||
|
JR54699
|
Addresses the issue in which the reverse engineering of ddl was erroneous. | ||
|
JR54709
|
Addresses the issue with reverse engineering of teradata. | ||
|
JR54612
|
Addresses the issue with default value for timestamp columns for teradata. | ||
|
JR54333
|
Addresses the issue with trackMod attribute. | ||
|
58113, 999, 631
|
Addresses the issue in creation of local indexes for quantity partitioned tables. | ||
| [PatchFix 80438] - Addresses the issue in which a new PDM cannot be created in an EJB project. |
Related Information
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"ARM Category":[],"Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.1.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
03 April 2020
UID
ibm16152211