Product Documentation
Abstract
This document provides the list of APARs that are fixed in Data Studio 4.1.x.
Content
Note that APAR releases are cumulative in nature so, the latest fix always has the previous fixes.
IBM Data Studio 4.1.4
IBM Data Studio 4.1.3
IBM Data Studio 4.1.2
IBM Data Studio 4.1.4
For links to the most important and frequently used documents of Data Studio 4.1.4, refer to IBM Data Studio 4.1.4 publication library.
IBM Data Studio 4.1.4 APAR 2
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT39577 | The comment option for Accelerator is not recognized by the SQL editor. |
2 | IT39578 | The Explain functionality in Query Tuning does not work when SQLID is a numeric value. For example, 12345. |
3 | Enhancement | Upgraded the JDBC driver 4.31.10 from Type3 to Type4 for query tuning. |
4 | Internal defect | Accessibility issue - The screen reader does not read some field descriptions. |
5 | Internal defect | Accessibility issue - The screen reader does not read the Table Name in a new driver template. |
6 | Internal defect | Added a field named Max Partition in the tablespace for Db2 z/OS 12. |
7 | Internal defect | Removed logs that are generated after Data Studio is connected to a database. |
IBM Data Studio 4.1.4 APAR 1
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | Not applicable |
CVE-2021-4104: Addressed Log4j related vulnerability
|
IBM Data Studio 4.1.4
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT34185 | While doing query tuning, fixed a null pointer exception |
2 | IT34237 | SQL run in DataStudio does not pick up embedded OPTGUIDELINES |
3 | IT35341 | The last user ID in IBM Data Studio Users view changes to user ID SYSIBM |
4 | IT37011 | For database DB2 iSeries, run button on the SQL Editor not working when the Default Path register is set to value "*LIBL" |
5 | IT37142 | Query Tuning functionality is not working for Db2Woc 11.5.5 |
6 | IT37143 | Cannot generate access plan diagram in data studio |
7 | IT37144 | Statistics advisor summary report is not getting generated |
8 | IT38679 | Fixed issue related to generating DDL for Alias |
9 | IT38680 | Fixed issue while tuning SQL statement with GROUP BY clause |
10 | IT38681 | Fixed issue while Generation DDL for comment column MySQL |
11 | IT38682 | Fixed issue while generating DDL for Oracle while updating column name |
12 | Internal defect | The Partition clause is missing in the Create table query for the ranged partitioned table. |
13 | Internal defect | When switching between z/OS Server Connect Properties and Driver Properties, the connection is failing with a Null password. |
14 | Enhancement | Platform - IDA support for SQL Server 2017 |
15 | Enhancement | Platform - IDA support for SQL Server 2019 |
IBM Data Studio 4.1.3
IBM Data Studio 4.1.3 APAR 8
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | Not applicable |
CVE-2021-4104: Addressed Log4j related vulnerability
Technote: Technote: IBM Data Studio 4.1.3: Log4j vulnerability (CVE-2021-4104)
|
IBM Data Studio 4.1.3 APAR 7
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT28700 | Issue while extracting data from a table. |
2 | IT30179 | The SYSTOOLS Explain table shows an unknown format error during configuration. |
3 | IT31001 | Added support for ISO format timestamp value for loading data in Db2 LUW. |
4 | IT31040 | Query Tuning > Visual Explain fails for z/OS SSL environment |
5 | IT32201 | Query Tuning > Generate recommendations > Statistics Explain hangs. |
6 | IT32286 | Modifying table fails with SSL connection. |
7 | IT32288 | Added support for the FETCH FIRST clause in Delete statement in Db2 z/OS 12. |
8 | IT33295 | Generated DDL for Load in the Alter function is not compatible with the Db2 LUW parameter setup. |
9 | IT32482 | While configuring query tuning the DSN_Statement_Cache_Table appears in an unknown format in Db2 z/OS 12. |
10 | IT33418 | Data Studio is unable to differentiate between the Allow and Disallow Debug modes of different versions of a Stored Procedure. |
11 | Enhancement | Added support for Column Organized Tables property in a partitioned environment for Db2 LUW. |
12 | None | Qualified support for Db2 LUW 11.5.4. |
IBM Data Studio 4.1.3 APAR 6
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT29734 | The Instead Of parameter for Trigger is not shown properly after reverse engineering a model for a table. |
2 | IT29993 | Support for handling extra characters in Db2 NSP. |
3 | IT29578 | Data Studio 4.1.3 APAR 5 Multivariate Distribution does not work with APAR 5 and previous versions. |
4 | IT28629 | z/OS parser to offer 'Set Current Accelerator' statement validation. |
5 | IT29543 | In Administration explorer, in the Properties window of User / Role, in the Privileges tab, the names of Package and Schema appear blank. |
6 | Enhancement | Support for Data Studio for V11.5 version of Db2 LUW. |
7 | Internal Defect | The null pointer issue breaks QueryTuning for Db2 z/OS. |
8 | Internal Defect | DDL does not generate Create Procedure statements in Data Studio 4.1.3 Db2 z/OS 12. |
9 | Internal Defect | In IBM Db2 Data Studio QueryTuning with Workload gives an error with specific workload files or queries. |
IBM Data Studio 4.1.3 APAR 5 Hotfix
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT29901 | Add support for Salesforce Ticket while capturing statement’s environment. |
IBM Data Studio 4.1.3 APAR 5
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT28533 | Online Check during deployment. |
2 | IT27661 | DDL is not generated with the model for Db2 LUW. |
3 | IT28078 | Null Pointer exception while browsing table data, connection issue. |
4 | IT28403 | Data Studio DDL Generation for an ALIAS is not correct. |
5 | IT28432 | Data Studio does not show the data in the Privilege tab in Properties view. |
6 | IT25174 | Not able to use Explain option in Data Studio and getting an error: An internal Error occurred. |
7 | IT28142 | Data Studio is not supporting null input into individual array elements. |
8 | IT27813 | Comma can now be added in String array element as input in Db2 z/OS Native Stored Procedure in Data Studio. |
9 | IT23365 | Native SQL Stored Procedure is failing with array as a parameter when called via Data Studio. |
10 | IT26495 | Added support in Storage Group for the physical data model. |
IBM Data Studio 4.1.3 APAR 4
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT26807 | Data Studio is incorrectly generating unique indexes for Primary Key constraints with incorrect names. |
2 | IT26109 | IDAA Data Studio client issues with Db2 V12R1M502. |
3 | IT25174 | Not able to use Explain option in Data Studio and getting an error: An internal error occurred. |
4 | IT25175 | Data Studio is not generating Access Plan Graph for Db2 LUW v11.1. |
5 | IT27066 | Handle ParseNameException exception while generating Access Plan Graph in Data Studio 4.1.3. |
6 | IT26806 | Two connections seen in the back end for one connection in Data Studio for Db2 LUW database. |
7 | IT26314 | Japanese installation of Data Studio 4.1.3 is not showing characters in Japanese on the Japanese operating system. |
8 |
Enhancement
114724
|
Platform - Data Studio support for SQL Server 2016.
Note: Technote for this RFE has been published: IBM Data Studio introduces support for MS SQL Server 2016 |
9 |
Enhancement
97397
|
Security - Allow users to directly change passwords or ensure repeated connection attempts do not lock out passwords.
|
10 | Internal Enhancement | Added support for Db2 for i table partitions. Note: Technote for this RFE has been published: Support for table partition in Db2 for I database in Data Studio |
IBM Data Studio 4.1.3 APAR 3
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT26550 | DS and IDAA shell sharing issue for visual explain on Db2 zOS V12. |
2 | IT26548 | Special symbols in a SQL statement. |
3 | IT25794 | Data Studio filer does not work for Db2 ZOS. |
4 | IT25746 | User not able to view parameter marker window when sendDataAsIs property set to true. |
5 | IT22206 | When generating the DDL for a VIEW, DDL will incomplete. |
6 | IT25797 | Data Studio 4.1.3 and illegal timestamp format error when trying to open visual explain. |
7 | IT26018 | AUTONOMOUS is not considered as valid keyword in Db2 ZOS v11 and v12 parsers for DS 4.1.3. |
8 | Internal Defects | Breakpoints for SQLJ DS412 APAR3 hide related functions from the user interface. |
Failed to reflect currentSQLID schema value while SQL execution. |
IBM Data Studio 4.1.3 APAR 2
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT24983 | Parameters are not included in stored procedure deployment on Db2 for iSeries 7.2. |
2 | IT24738 |
The user is not able to set the default JDBC run option for all workspaces.
Note: The following technote for this defect has been published: Set the default JDBC Run Option globally for the SQL Editor configuration |
3 | IT25174 | Not able to use the Explain option in Data Studio and getting an error: An internal error occurred. |
4 | IT21676 | DDL generated for Db2 Z/OS database certain SCHEMA does not maintain the proper sequence of drop and create statements for user-defined functions according to dependent user-defined functions. |
5 |
Enhancement
97397
|
Allow users to directly change passwords or ensure repeated connection attempts do not lock out passwords.
Note: The following technote for this RFE has been published: Changing database password using IBM Data Studio |
6 |
Enhancement
103312
|
Update version property in Data Source Explorer for Db2 iSeries 7.3. |
IBM Data Studio 4.1.3 APAR 1
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IT24573 | Failed to reflect default schema value while sql execution. |
2 | JR59058 | Data Studio cannot batch-create federated nicknames. |
3 | IT24636 | Byte to char converter error.java 1.4 is getting used though the customer is using JDK 1.8. |
4 | IT24550 | Data Studio throwing Null pointer Error when attempting to filter browsing data on a table with column name "value". |
IBM Data Studio 4.1.2
IBM Data Studio 4.1.2 APAR 7
Sr. No. |
PMR Number
|
Description
|
---|---|---|
1 | 89458,122,000 | Fixed for Data Studio reverse engineering missing tables. |
2 | 00411,160,846 | Fixed for Pasting filter string into object list view does not work properly. |
3 | 44510,442,000 | Fixed for Data Studio 'WLM Environment' field length limitation. |
4 | 21467,082,000 | Fixed for Stored procedure call failed when proceeded with comment line in SQL script. |
5 | 86345,082,000 | Fixed for Version 4.1.2 does not display DPF partitioned table spaces correctly. |
6 | 62986,122,000 | Fixed for DEBUG source window shows the incorrect (inactive) version of the stored procedure in Data Studio for Db2 ZOS. |
7 | 05816,999,724 | Fixed IMS SQL Parser to support Java Application programming API. |
8 | 34340,442,000 | Fixed for failure to capture a workload on Db2 z/OS 11 in compatible mode. |
9 | 90697,442,000 | Fixed for show the original -553 error of setting CURRENT SQLID when tune query on Db2 z/OS. |
10 | 75238,057,649 | Fixed the -104 error when tuning a query contains “-“ character. |
11 | 93435,250,631 | Fixed the performance issue when tuning Workload Statistics Advisor. |
Fixed for IDz defect caused by DS package-duplicate namespace issue. | ||
Fixed for fail to tune workload from Query Monitor due to certificate file has expired. | ||
Fixed for tune Workload Statistics Advisor abend due to table columns count is bigger than 255. |
IBM Data Studio 4.1.2 APAR 6
Sr. No. |
PMR Number
|
Description
|
---|---|---|
1 | 13113,999,706 | Fixed for Data perspective - Edit/Update of Columns in IBM Rational Developer for z systems to work as expected. |
2 | 39801,230,631 | Fixed for Data Studio script execution stuck during export functionality |
3 | 87831,100,838 | Fixed for Backup and configure functionality not working for Db2 11.1 |
4 | 73154,004,000 | Fixed for Data Studio not returning complete error messages back when it is connected to Big SQL. |
5 | 90398,031,724 | Fixed for SQL QUERY BUILDER to avoid CURRENT TIMESTAMP being quoted in the where clause. |
6 | 11752,999,706 | Fixed for com.ibm.datatools.* plugin issue in RDZ from Data Studio. |
IBM Data Studio 4.1.2 APAR 5
Sr. No. |
PMR Number
|
Description
|
---|---|---|
1 | 53832,L6Q,000 | Fixed the issue that Data Studio 'reorg' option is grayed out when a table has xml column. |
2 | 32105,756,000 | Fixed the issue for getting an error when trying to select "configure" on a database (Db2 v11.1). |
3 | 88886,122,000 | Update the Db2 jdbc driver to Db2 Level: v11.1 FP1 (4.22.29 and 3.72.24). |
IBM Data Studio 4.1.2 APAR 4
Sr. No. |
PMR Number
|
Description |
---|---|---|
1 | Fixed wrong display and editing of complex expressions in SQL Builder Editor. | |
Support IMS V14 SQL Parser. | ||
Support parser validation for Db2 for z/OS V12. |
IBM Data Studio 4.1.2 APAR 3
Sr. No. |
PMR Number
|
Description
|
---|---|---|
1 | 71151,122,000 | Fixed the issue debugging for a native stored procedure on Db2 for z/OS. |
Fixed the issue of database statements generation for schema on Db2 for z/OS. |
IBM Data Studio 4.1.2 APAR 2
Sr. No. |
PMR Number
|
Description |
---|---|---|
1 | 09910,122,000 | Fixed the issue for 'Edit Data" when using SSL Connection. |
2 | 17286,010,678 | Fixed the issue for default schema is not honored when used in SQL script on Db2 for z/OS. |
3 | 15430,999,760 | Fixed the issue for the "Run" button is not enabled for IMPORT when specifying a valid path with a Japanese character. |
4 | 45900,060,678 | Support deleting a row using Data Studio with specific Column type (Column type is VARCHAR, data type is HEX). |
5 | 72660,250,631 | Support tuning statements, which contain expressions with OLAP specifications on Db2 for z/OS. |
6 | 43125,L6Q,000 | Support capturing query environment by using the global setting for SQLID and SCHEMA. |
7 | 70533,077,649 | Support tuning specific statements, which use a function with the alias as a select-clause item on Db2 for Linux, UNIX, and Windows. |
8 | 61526,077,724 | Support primaryAccess='P' for webVE. |
9 | 43125,L6Q,000 | Support tuning specific statement, which refers to the temporal table on Db2 for z/OS v11 environment. |
10 | 93151,122,000 | Fixed the issue for improper removal of WLM Environment statement for native SQL stored procedure for Db2 for z/OS. |
IBM Data Studio 4.1.2 APAR 1
Sr. No. |
PMR Number
|
Description |
---|---|---|
1 | 93151,122,000 | Fixed the issue for improper removal of WLM Environment statement for native SQL stored procedure for Db2 for z/OS. |
2 | 71074,7TD,000 | Support tuning specific statements on Db2 for z/OS environment, that use double quotes as the SQL delimiter. |
3 | 88386,7TD,000 | Support running Workload Analytics Acceleration Advisor for specific static statements. |
4 | 78422,122,000 | Support NON-SYSADM users to create explain tables automatically. |
5 | 21130,057,649 | Support showing commands of workload statistic advisor recommendations in the summary report when those commands are only recommended to collect complete statistics but not to repair problems. |
6 | 68100,072,649 | Support long query text for scheduling capture tasks from package cache. |
7 | 39230,033,724 | Support displaying cardinality of TBSCAN of a global temporary table. |
8 | 77846,122,000 | Support migration of workload control center view's privilege from Optim Query Workload Tuner 4.1.1. |
9 | 77846,122,000 | Support doing configuration for Db2 for z/OS by using JCL. |
10 | 81745,999,616 | Support tuning specific workload, which includes CREATE TEMPORARY table statement on Db2 for Linux, UNIX, and Windows. |
11 | 75336,122,000 | Support creating workload with query length between 3500 and 4000. |
IBM Data Studio 4.1.1
For issues fixed in InfoSphere Optim Query Workload Tuner 4.1.1 and the unlicensed tuning features in Data Studio (client) 4.1.1, refer to https://www.ibm.com/support/pages/node/605011.
Sr. No. |
APAR Number
|
Description
|
---|---|---|
1 | IC98973 | Data Studio does not drop inactive versions of stored procedures. |
2 | IC99118 | Data Studio SQL editor to allow the use of !! as concatenation. |
3 | IC99609 |
Debugging a UDF (deployed on Db2 for z/OS) that is using parameter CCSID unicode fails with SQLCODE332N.
|
4 | IC87419 | Data Studio is unable to deploy SQLJ stored procedure to Db2 z/OS V10CM8. |
5 | IC90808 |
The statistics advisor keeps offering the same statistics advice even after running recommendations on the server.
|
6 | IC99357 | Data Studio is unable to drop Db2 z/OS native stored procedures with multiple versions. |
7 | IT00375 | Missing PLAN_TABLE and diagram tabs in access plan graph view in Data Studio 4.1.0.1. |
8 | IT00680 |
Opening the source of a Java stored procedure using the routine editor may result in no source being displayed.
|
9 | IT00782 | Build owner field in deploy options not used on rebuilds. |
10 | IT00850 | In SQL scripts, there is an English pound symbol. After saving, it automatically gets saved as a different set of characters. |
11 | IT00984 | Connections left "opened" on run from the SQL editor. |
12 | IT00998 | Installed browsers do not show up in the Review Access plan graph for Data Studio 4.1.0.1. |
13 | IT00870 | Db2 LUW creates large table space: Translated data tag inherit keyword caused creation DDL error. |
14 | IT01751 | Data Studio 4.1 should treat an identifier of uppercase with # sign same as lowercase with a # sign. |
15 | IT01997 | PLAN_TABLE is not displayed when you open Visual Explain from the Data Studio SQL editor. |
16 | IT02101 | The TIMESTAMP column displays problems. |
17 | IT02688 |
Performing explained in Data Studio 4.1 results in character conversion error.
|
18 | IT02744 | Data Studio 4.1 query tuner throw error for query annotation on Db2 V10NFM and V11NFM. |
19 | IT02816 | When Data Studio 4.1.0.1 users try to access the path graph, Data Studio displays a message that says the supported browser is not available. |
20 | IT03308 | Data Studio 4.1 generates a wrong DDL for views in Db2 z/OS. |
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS62YD","label":"IBM Data Studio"},"ARM Category":[{"code":"a8m3p000000h9fCAAQ","label":"DSM"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.1.1;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
02 March 2022
UID
swg27038177