IBM Support

Fixed APARs in IBM Data Studio 4.1.x

Product Documentation


Abstract

This document provides the list of APARs that are fixed in Data Studio 4.1.x.

Content

  • Data Studio 4.1
  • Data Studio 4.1.0.1
  • Data Studio 4.1.1
  • Data Studio 4.1.2
  • Data Studio 4.1.3

Data Studio 4.1

Data Studio 4.1
Sr. No. APAR Number Description
1 IC82080 Documentation topic is missing configuring data studio for running high performance unload (hpu) utility on unix platforms.
2 IC83380 Tablespaces in data studio do not recognize partitioned tables.
3 IC83799 Simultaneously updating source and user privileges for stored procedure in properties view may result in incorrect generated ddl.
4 IC85153 Unable to retian autoresize keyword change after alter on dms tablespace
5 IC86915 Local stored procedure marked as syntax error in data studio
6 IC87265 Data studio generates incorrect update statement for table statistics.
7 IC87419 Data studio unable to deploy sqlj stored procedure to db2 z/os v10cm8.
8 IC88034 Using ellipsis button to enter data for in or inout parameter trims spaces
9 IC88090 Data studio keeps connection thread on fail udf run
10 IC88756 Datastudio 3.1.1 generates -206 error code in edit mode while used in db2 z 10 cm8 environment
11 IC88928 "Grant to role" statements are not generated for a role which name matches the name of an existing user
12 IC89499 Incorrect extra comma in create nickname statement for the non relational data source file_wrapper.
13 IC89577 Data type declaration of for bit data ignored by data studio.
14 IC89910 Sql2036n error when backup command is executed from admin explorer.
15 IC90135 Database catalog filter produces incorrect result in data studio
16 IC90322 Statements in before run should be treated as a single unit of work.
17 IC90808 The statistics advisor keeps offering the same statistics advise even after running recommendations on server.
18 IC90904 Can not input alphanumeric in pmr number's branch field when user use capture query environment after tuning a sql.
19 IC90928 Data studio does not run properly when authentication mode is data_encrypt
20 IC91252 Data studio's optim query tuner do not display proper values for low2key, high2key, frequency.
21 IC91348 Unable to use analyze impact function for temporary tables.
22 IC91480 User gets "internal error occured" when running a select on table containing character for bit data column
23 IC91710 Calling a stored procedure with a supplied value for inout
24 IC91838 "Generate ddl" function is not available for db2 for z/os
25 IC91906 Comments at the beginning of sql script in sql editor will fail the running of the script.
26 IC92095 User gets sqlstate=51002 in data studio administration perspective when trying to rebind a package which has v
27 IC92209 Sql results view shows password plain text in result output for altering user mapping under federated database objects

Data Studio 4.1.0.1

Data Studio 4.1.0.1
Sr. No.
APAR Number
Description
1 IC85675 CREATE XML SCHEMA FOR DB2 Z/OS V10 FAILS IN DATA STUDIO
2 IC91253 CANNOT START THE DATA STUDIO 3.2 INSTALLATION IN RED HAT ENTERPRISE LINUX 6.3
3 IC92281 ROUTINE EDITOR HAS A DELAYED SYNCHRONIZATION WITH USERS' INPUT AND MAY RUN AN OUTDATED VERSION OF AN SQL SCRIPT BEING EDITED
4 IC92596 DATA STUDIO 3.2 DROPS THE COMMENTS FROM THE STORED PROCEDURE'S PARAMETER SECTION AFTER DEPLOYING IT ON DATABASE
5 IC92564 SQL QUERY BUILDER IN DATA STUDIO SHOW NO RESULT FROM RUN
6 IC92709 DATA STUDIO 3.2 OPTIM QUERY TUNER HANGS UP DUE TO THE CATALALOG LOADING DURING THE QUERY TUNNING PROCESS.
7 IC92857 UPDATE STATISTICS FUNCTION ON NICKNAME IN DATA STUDIO 3.2 GIVES SQLCODE=-1131
8 IC92908 VIEWING XML COLUMNS IN "SQL RESULTS" VIEW VIA ELLIPSIS BUTTON MAY SHOW GARBAGE INSTEAD OF SOME UNICODE CHARACTERS
9 IC92916 "GENERATE DDL" PRODUCES INVALID DDLS FOR DB2 Z/OS TRIGGERS WHICHDEFINITIONS HAVE SPARSE FORMATTING
10 IC93065 WHEN SPECIFY A NETWORK DRIVE AT THE WORKSPACE LOCATION, GET 'START EXPLAIN WORKER HAS ENCOUNTERED A PROBLEM' ERROR
11 IC93016 ERROR DIALOG POPS UP WHEN PRINTING A DIAGRAM IN DATA STUDIO
12 IC93152 COMMAND TEXT FROM LOAD UTILITY DOES NOT REFLECT GUI
13 IC93927 DDL IS NOT GENERATED WHEN ONLY PRIVILEGES OBJECT IS SELECTED FROM MODEL OBJECTS LIST AT CREATE DDL FROM DATA SOURCE EXPLORER
14 IC94069 DDL GENERATION IN DATA STUDIO CONTAINS EXTRA QUOTES
15 IC94333 DATA STUDIO DISPLAYS INCORRECT PARTITIONS FOR TABLESPACES
16 IC94615 SYNCHRONIZATION OF DATA STUDIO CONNECTIONS, PRIMARY CONNECTION MUST BE ESTABLISHED FIRST
17 IC94940 DATA STUDIO 4.1 FORMAT SQL RESULTS IN WRONG SQL FORMAT FOR HOST VARIABLES.
18 IC95168 MISSING FILES FROM JAVA STORED PROCEDURES EXPORT
19 IC95072 ERROR CAN BE GENERATED WHEN OPENING THE SEQUENCES FOLDER WHICH CONTAINS AN ALIAS OF A SEQUENCE.
20 IC95700 FORMAT SQL FAILS WHEN HOST VARIABLE CONTAINS SPACE IN DATA STUDIO
21 IC96040 RENAME ACTION IN DATA STUDIO FOR SQL SCRIPTS HAVE DIFFERENT BEHAVIOR FOR DIFFERENT PROJECT TYPES
22 IC96935 UPON GENERATION OF THE DDL USING DATA STUDIO 4.1 THE UPDATE GRANT IS NOT SHOWN AS PART OF DDL.
23 IC97677 DATA STUDIO SQL EDITOR - HOST VARIABLE NAME DOES NOT WORK FOR A MAJORITY OF UNICODE CHARACTERS

Data Studio 4.1.1

Data Studio 4.1.1
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 FAIL WITH SQLCODE332N.
4 IC87419 DATA STUDIO UNABLE TO DEPLOY SQLJ STORED PROCEDURE TO DB2 Z/OS V10CM8.
5 IC90808 THE STATISTICS ADVISOR KEEPS OFFERING THE SAME STATISTICS ADVISE EVEN AFTER RUNNING RECOMMENDATIONS ON SERVER.
6 IC99357 DATA STUDIO NOT ABLE 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 SQL SCRIPTS, THERE IS A SYMBOL ENGLISH POUND SIGN. AFTER SAVING, IT WILL AUTOMATICALLY SAVE AS A DIFFERENT SET OF CHARACTER.
11 IT00984 CONNECTIONS LEFT "OPENED" ON RUN FROM THE SQL EDITOR.
12 IT00998 INSTALLED BROWSERS DO NOT SHOW UP IN REVIEW ACCESS PLAN GRAPH FOR DATA STUDIO 4.1.0.1.
13 IT00870 DB2 LUW CREATE 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 # SIGN.
15 IT01997 PLAN_TABLE IS NOT DISPLAYED WHEN OPEN VE FROM DATA STUDIO SQL EDITOR.
16 IT02101 TIMESTAMP COLUMN DISPLAY PROBLEMS.
17 IT02688 PERFORMING EXPLAIN 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 DATA STUDIO 4.1.0.1 USER GET THE MESSAGE ABOUT NOT HAVING SUPPORTED BROWSER WHEN TRY TO DISPLAY AN ACCESS PATH GRAPH.
20 IT03308 DATA STUDIO 4.1 GENERATES WRONG DDL FOR VIEWS FOR DB2 ZOS.

Data Studio 4.1.2

Prerequisite: Data Studio (Client) 4.1.2

Data Studio 4.1.2 APAR 1
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 statement on DB2 for z/OS environment, which uses double quotes as 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 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 task 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.

Data Studio 4.1.2 APAR 2
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 "Run" button is not enabled for IMPORT when specify a valid path with 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 function with alias as 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.

Data Studio 4.1.2 APAR 3
Data Studio 4.1.2 APAR 3
Sr. No.
PMR Number
Description
1 71151,122,000 Fixed the issue debugging for native stored procedure on DB2 for z/OS.
Fixed the issue of database statements generation for schema on DB2 for z/OS.
Data Studio 4.1.2 APAR 4
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.
Data Studio 4.1.2 APAR 5
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).
Data Studio 4.1.2 APAR 6
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.
Data Studio 4.1.2 APAR 7
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 fail to capture workload on Db2 z/OS version 11 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 tune a query contains “-“ character.
11 93435,250,631 Fixed the performance issue when tune 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.

Data Studio 4.1.3

Prerequisite: Data Studio (Client) 4.1.3

Data Studio 4.1.3 APAR 1

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 customer is using jdk 1.8.
4 IT24550 Data Studio throwing Null pointer Error when attempt to filter browsing data on a table with column name "value".

Data Studio 4.1.3 APAR 2

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
User 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 user to directly change password 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.

Data Studio 4.1.3 APAR 3

Data Studio 4.1.3 APAR 3
Sr. No.
APAR Number
Description
1 IT26550 DS and IDAA shell sharing issue for visual explain on DB2zOS 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 function from UI.
Failed to reflect currentSQLID schema value while sql execution.

Data Studio 4.1.3 APAR 4

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:
Tech note for this RFE has been published:
IBM Data Studio introduces support for MS SQL Server 2016
9
Enhancement
97397
Security - Allow user to directly change password or ensure repeated connection attempts do not lock out passwords.

Note:
Tech note for this RFE has been published:
Changing database password using IBM Data Studio
10 Internal Enhancement Added support for Db2 for i table partitions.
Note:
Tech note for this RFE has been published:
Support for table partition in Db2 for I database in Data Studio

Data Studio 4.1.3 APAR 5

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 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 physical data model.

Data Studio 4.1.3 APAR 5 Hotfix

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.

Data Studio 4.1.3 APAR 6

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 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 Properties window of User / Role, in 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 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.

Data Studio 4.1.3 APAR 7

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 show 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 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.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS62YD","label":"IBM Data Studio"},"ARM Category":[{"code":"a8m0z0000001jGMAAY","label":"rbrw"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"4.1.0;4.1.1;4.1.2;4.1.3","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 July 2020

UID

swg27038177