IBM Support

Fixed APARs in IBM InfoSphere Data Architect 9.1.4

Product Documentation


Abstract

This document provides the list of APARs fixed in Data Architect 9.1.4.

Content

The following tables give details of the APARs fixed in InfoSphere Data Architect 9.1.4:
  • Authorized Program Analysis Reports (APAR)
  • Program Management Record Number (PMR)
Table 11: Fixes in APAR 11 (released in March 2022)
Sr. No. Fix type Number Case / PMR Number Description
1 Internal defect Not applicable Not applicable Added support to be able to configure the user interface for BigSQL database.
2 Internal defect Not applicable Not applicable Fixed issues related to View and generating DDL for the Generic JDBC driver.
Table 10: Fixes in APAR 10 (released in January 2022)
Sr. No. Fix type Number Case / PMR Number Description
1 Security fix Not applicable Not applicable
CVE-2021-4104: Addressed Log4j related vulnerability
Table 9: Fixes in APAR 9 (released in January 2021)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR58202 TS000888100 Fixed issues related to the Oracle 12 identity feature.
2 APAR JR61649 TS002233950 Fixed the identity relationship creation issue in overview diagrams.
3 APAR JR62165 TS002801879 Fixed the Data Source Explorer (DSE) display issue for the PostgreSQL table index with more than one member.
4 APAR IT34186 TS003872580
MySQL 5.1: While transforming a model from logical to physical, the default value of 'TIMESTAMP' datatypes gets changed to 'CURRENT TIMESTAMP'.
5 APAR IT34187 TS003761824 MS SQL Server 2014: The constraints are not visible when a database name contains a hyphen (-).
6 APAR IT34237 TS003846863 SQL run in Data Studio does not pick up embedded OPTGUIDELINES.
7 APAR IT35344 TS003872580 For the Db2 z/OS database, the publish model with the full option gives an error.
8 APAR IT35345 TS003436818 Fixed issue in updating and deleting subpartitions templates for Physical Data Model (PDM).
9 Enhancement Not applicable Not applicable Added support for SQL Server 2017.
10 Internal defect Not applicable Not applicable
Removed support for Big SQL. The existing Big SQL data models and data assets are no longer supported.
11 Internal defect Not applicable TS003970449 The Partition clause is missing while generating DDL for a ‘ranged partitioned’ table.
12 Internal defect Not applicable TS003024049 When switching between the Driver Properties and z/OS Server Connect Properties connection wizard screens, the connection fails with a Null password.
Table 8: Fixes in APAR 8 (released in September 2019)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR60587 65949999631 Added support for recognizing GIST and GIN index types in the PostgreSQL database.
2 APAR JR61442 TS002599437 Added support for Implicitly hidden (property) column.
3 APAR JR61493 65047999631
Added support for exception handling while doing schema comparison between the physical data model and PostgreSQL database.
 
Error: column "tgisinternal" does not exist
4 Enhancement Not applicable DB24LUW-I-252 Added support for Db2 Column Organized Tables in a partitioned environment.
5 Enhancement Not applicable Not applicable Added support for Db2 LUW 11.5.
6 Internal defect Not applicable Not applicable Corrected the populated value of the Default Schema field in the Data Development Project wizard.
7 Internal defect Not applicable Not applicable Corrected the incorrect Delta DDL in the following scenarios:
  • When it is generated the first time Data Architect loads
  • For eliminating Check Constraints creation
8 Internal defect Not applicable Not applicable Added support for performing arithmetic operations on SQL results in bidirectional (BIDI) settings.
9 Internal defect Not applicable Not applicable Added support for generating appropriate DDL after updating tablespaces.
Table 7: Fixes in APAR 7 (released in July 2019)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR59365 TS002233157 Collateral issue after APAR6 - missing parenthesis.
2 APAR JR59447 Not applicable Clause INCLUDE of SQL Server indexes is not considered on reverse engineering and connections on Data Source Explorer.
3 APAR IT26495 23704070724 Storage Group cannot be added to Model.
4 APAR IT28855 Not applicable Using the outline view to select SQL statements not working properly.
5 APAR IT29320 TS002262529 Wrong DDL generated for the unique constraint by USING Clause.
6 Enhancement 101026 Not applicable
Added support for Teradata 15 and 16 and MergeblockRatio.
7 Enhancement 120179 Not applicable
Added support for SSL Connection Parameter for PostgresSQL.
8 Enhancement Not applicable Not applicable
Added support for PostgreSQL 10 and PostgreSQL 11.
9 Enhancement Not applicable Not applicable
Added support JSONB datatype for PostgreSQL.
10 Internal defect Not applicable TS000883545 Collateral issue after APAR6 - Handled constraints related scenario.
11 Internal defect Not applicable TS002233794 Collateral issue after APAR6 - Fixed performance issue in model x database comparison.
Table 6: Fixes in APAR 6 (released in March 2019)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR58540 Not applicable In IoT, physical properties should be the same as the primary key properties.
2 APAR JR58700 Not applicable Exclude all individual partitions from a table in the Oracle database.
3 APAR JR59365 Not applicable Data Architect reads the wrong default values from the PostgreSQL database.
4 APAR JR60518 Not applicable Updated Partition Strategy for Table in Oracle.
5 Internal defect Not applicable Not applicable
Data Architect shows incorrect results of compare operation in the structural changes window.
6 Internal defect Not applicable Not applicable Improved Oracle database related code.
Table 5: Fixes in APAR 5 (released in December 2018)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR60359 Not applicable Allow user to set the default value for 'Migrate primary key attribute properties' to True.
2 APAR IT26806 Not applicable Two connections in the backend for one connection in Data Studio for Db2 LUW database.
3 Enhancement 114724 Not applicable
Added support for SQL Server 2016.
4 Internal enhancement Not applicable Not applicable
Added support for Db2 for i table partitions.
5 Internal defect Not applicable Not applicable Problem while opening a DBM file.
Table 4: Fixes in APAR 4 (released in October 2018)
Sr. No. Fix type Number Case / PMR Number Description
1 Internal defect Not applicable Not applicable Incorrect Drop statement present when we select the backup option.
2 Internal defect Not applicable Not applicable Incorrect SQL statement generated while updating Partitioned table to Non-partitioned table.
3 Internal defect Not applicable Not applicable Entity Label name defined in Naming Stand Configuration not recognized while Transformation.
4 Internal defect Not applicable Not applicable Invalid drop statement added while updating PCTFree and initTrans without a Backup option.
5 Internal defect Not applicable Not applicable Blank DDL generated while removing members of the PK constraint and index for a table with a backup table option.
6 Internal defect Not applicable Not applicable MITI import and export functionality not working in Data Architect 9.1.4 APAR 3.
Table 3: Fixes in APAR 3 (released in August 2018)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR56307 30585082000 Data Architect does not generate Delta DDL Script as expected.
2 APAR JR58540 TS000883545 Data Architect does not read the initrans property in Index Organized Tables (IOT) correctly.
3 APAR JR58621 TS000883533 Differences in the default value NULL when compared to PDM.
4 APAR JR58700 TS000800020 Excludes all individual partitions from a table on the Oracle database.
5 APAR JR58716 TS000799975 Data Architect generates the wrong delta DDL for an index with PCTFREE value.
6 APAR JR59677 TS000927251 The custom filter does not work for the Oracle Tablespace on Column.
7 APAR JR59677 TS000861957 Differences in PDM vs Oracle Database related to DomainName.
8
Enhancement
 60924 Not applicable
Added support for Materialized View.
9 Enhancement 103312 Not applicable Scoped request for Db2 i support to 7.3.
Table 2: Fixes in APAR 2 (released in June 2018)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR58240 61304999631 Wrong Delta DDL generates with the 'backup table' after a comparison between a PDM and a DB.
2 APAR JR58540 60436999631 Data Architect does not read the pctfree and InitTrans property for Index Organized Tables (IOT) correctly.
3 APAR JR58737 63415999631 Data Architect does not allow creating a filter for tablespace of the subpartition.
4 APAR JR58773 65033999631 Unable to update tablespace to partitioned table.
5 APAR JR58775 63472999631 Drop of the index of the primary key before dropping PK.
6 APAR JR59169 65469999631 Data Architect generates DDL of FK before PK constraint for PostgreSQL database.
7 APAR JR59619 55692800624 MITI: Failed to import Erwin models into Data Architect.
8
Enhancement
 121096 Not applicable ING specific requirement changes. Provided new features to ING.
9
Internal defect
 106758 Not applicable APPScan CWE ID#73 High Priority PathTraversal.
10
Internal defect
 106759 Not applicable APPScan CWE ID#20 High Priority Input Validation.
Table 1: Fixes in APAR 1 (released in March 2018)
Sr. No. Fix type Number Case / PMR Number Description
1 APAR JR58099 26199010618 Generate expression for a temporary table.
2 APAR JR58615 65106999631 Data Architect does not recognize domain objects like a datatype of the attribute on the database side.
3 APAR JR58683 78133057649 Data Architect generates a wrong DDL in the Tera Data server for data and timestamp fields.
4 APAR JR58709 29322211788 While transforming PDM to JSON, Column does not get generated for the Integer data type while transforming from oracle PDM to JSON.
5 APAR JR58718 Not applicable Properties are not generated in JSON schema when the convert space in the name option is set to lowerCamelCase.
6 APAR JR58737 63415999631 Data Architect does not allow creating a filter for tablespace of the subpartition.
7 APAR JR58774 64144999631 Bad performance to compare PDM and Oracle database.
8 APAR JR58776 65039999631 Wrong DDL of the PK Constraint for PostgreSQL database.
9 APAR JR59058 64781999631 Data Architect generates empty DDL while comparing between PDM x database.
10 APAR JR59354 29595211788 The cardinality of the relationship is incorrectly converted to JSON schema.
11 Enhancement 107340 63414999631 Data Architect filter does not work correctly at the column level filter.

[{"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.1.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 March 2022

UID

swg27050690

Page Feedback