Product Documentation

Download IBM Data Studio. Select to download from the web, or from Passport Advantage. Select to download the Data Studio client. When you complete the download, depending on your operating system, run one of the following commands as administrator. 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.


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 NumberDescription
1IC82080Documentation topic is missing configuring data studio for running high performance unload (hpu) utility on unix platforms.
2IC83380Tablespaces in data studio do not recognize partitioned tables.
3IC83799Simultaneously updating source and user privileges for stored procedure in properties view may result in incorrect generated ddl.
4IC85153Unable to retian autoresize keyword change after alter on dms tablespace
5IC86915Local stored procedure marked as syntax error in data studio
6IC87265Data studio generates incorrect update statement for table statistics.
7IC87419Data studio unable to deploy sqlj stored procedure to db2 z/os v10cm8.
8IC88034Using ellipsis button to enter data for in or inout parameter trims spaces
9IC88090Data studio keeps connection thread on fail udf run
10IC88756Datastudio 3.1.1 generates -206 error code in edit mode while used in db2 z 10 cm8 environment
11IC88928'Grant to role' statements are not generated for a role which name matches the name of an existing user
12IC89499Incorrect extra comma in create nickname statement for the non relational data source file_wrapper.
13IC89577Data type declaration of for bit data ignored by data studio.
14IC89910Sql2036n error when backup command is executed from admin explorer.
15IC90135Database catalog filter produces incorrect result in data studio
16IC90322Statements in before run should be treated as a single unit of work.
17IC90808The statistics advisor keeps offering the same statistics advise even after running recommendations on server.
18IC90904Can not input alphanumeric in pmr number's branch field when user use capture query environment after tuning a sql.
19IC90928Data studio does not run properly when authentication mode is data_encrypt
20IC91252Data studio's optim query tuner do not display proper values for low2key, high2key, frequency.
21IC91348Unable to use analyze impact function for temporary tables.
22IC91480User gets 'internal error occured' when running a select on table containing character for bit data column
23IC91710Calling a stored procedure with a supplied value for inout
24IC91838'Generate ddl' function is not available for db2 for z/os
25IC91906Comments at the beginning of sql script in sql editor will fail the running of the script.
26IC92095User gets sqlstate=51002 in data studio administration perspective when trying to rebind a package which has v
27IC92209Sql 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.
Description
1IC85675CREATE XML SCHEMA FOR DB2 Z/OS V10 FAILS IN DATA STUDIO
2IC91253CANNOT START THE DATA STUDIO 3.2 INSTALLATION IN RED HAT ENTERPRISE LINUX 6.3
3IC92281ROUTINE EDITOR HAS A DELAYED SYNCHRONIZATION WITH USERS' INPUT AND MAY RUN AN OUTDATED VERSION OF AN SQL SCRIPT BEING EDITED
4IC92596DATA STUDIO 3.2 DROPS THE COMMENTS FROM THE STORED PROCEDURE'S PARAMETER SECTION AFTER DEPLOYING IT ON DATABASE
5IC92564SQL QUERY BUILDER IN DATA STUDIO SHOW NO RESULT FROM RUN
6IC92709DATA STUDIO 3.2 OPTIM QUERY TUNER HANGS UP DUE TO THE CATALALOG LOADING DURING THE QUERY TUNNING PROCESS.
7IC92857UPDATE STATISTICS FUNCTION ON NICKNAME IN DATA STUDIO 3.2 GIVES SQLCODE=-1131
8IC92908VIEWING XML COLUMNS IN 'SQL RESULTS' VIEW VIA ELLIPSIS BUTTON MAY SHOW GARBAGE INSTEAD OF SOME UNICODE CHARACTERS
9IC92916'GENERATE DDL' PRODUCES INVALID DDLS FOR DB2 Z/OS TRIGGERS WHICHDEFINITIONS HAVE SPARSE FORMATTING
10IC93065WHEN SPECIFY A NETWORK DRIVE AT THE WORKSPACE LOCATION, GET 'START EXPLAIN WORKER HAS ENCOUNTERED A PROBLEM' ERROR
11IC93016ERROR DIALOG POPS UP WHEN PRINTING A DIAGRAM IN DATA STUDIO
12IC93152COMMAND TEXT FROM LOAD UTILITY DOES NOT REFLECT GUI
13IC93927DDL IS NOT GENERATED WHEN ONLY PRIVILEGES OBJECT IS SELECTED FROM MODEL OBJECTS LIST AT CREATE DDL FROM DATA SOURCE EXPLORER
14IC94069DDL GENERATION IN DATA STUDIO CONTAINS EXTRA QUOTES
15IC94333DATA STUDIO DISPLAYS INCORRECT PARTITIONS FOR TABLESPACES
16IC94615SYNCHRONIZATION OF DATA STUDIO CONNECTIONS, PRIMARY CONNECTION MUST BE ESTABLISHED FIRST
17IC94940DATA STUDIO 4.1 FORMAT SQL RESULTS IN WRONG SQL FORMAT FOR HOST VARIABLES.
18IC95168MISSING FILES FROM JAVA STORED PROCEDURES EXPORT
19IC95072ERROR CAN BE GENERATED WHEN OPENING THE SEQUENCES FOLDER WHICH CONTAINS AN ALIAS OF A SEQUENCE.
20IC95700FORMAT SQL FAILS WHEN HOST VARIABLE CONTAINS SPACE IN DATA STUDIO
21IC96040RENAME ACTION IN DATA STUDIO FOR SQL SCRIPTS HAVE DIFFERENT BEHAVIOR FOR DIFFERENT PROJECT TYPES
22IC96935UPON GENERATION OF THE DDL USING DATA STUDIO 4.1 THE UPDATE GRANT IS NOT SHOWN AS PART OF DDL.
23IC97677DATA STUDIO SQL EDITOR - HOST VARIABLE NAME DOES NOT WORK FOR A MAJORITY OF UNICODE CHARACTERS

Data Studio 4.1.1

Ibm Data Studio Versions

Data Studio 4.1.1
Sr. No.
APAR Number
1IC98973DATA STUDIO DOES NOT DROP INACTIVE VERSIONS OF STORED PROCEDURES.
2IC99118DATA STUDIO SQL EDITOR TO ALLOW THE USE OF !! AS CONCATENATION.
3IC99609DEBUGGING A UDF (DEPLOYED ON DB2 FOR Z/OS) THAT IS USING PARAMETER CCSID UNICODE FAIL WITH SQLCODE332N.
4IC87419DATA STUDIO UNABLE TO DEPLOY SQLJ STORED PROCEDURE TO DB2 Z/OS V10CM8.
5IC90808THE STATISTICS ADVISOR KEEPS OFFERING THE SAME STATISTICS ADVISE EVEN AFTER RUNNING RECOMMENDATIONS ON SERVER.
6IC99357DATA STUDIO NOT ABLE TO DROP DB2 Z/OS NATIVE STORED PROCEDURES WITH MULTIPLE VERSIONS.
7IT00375MISSING PLAN_TABLE AND DIAGRAM TABS IN ACCESS PLAN GRAPH VIEW IN DATA STUDIO 4.1.0.1.
8IT00680OPENING THE SOURCE OF A JAVA STORED PROCEDURE USING THE ROUTINE EDITOR MAY RESULT IN NO SOURCE BEING DISPLAYED.
9IT00782BUILD OWNER FIELD IN DEPLOY OPTIONS NOT USED ON REBUILDS.
10IT00850SQL SCRIPTS, THERE IS A SYMBOL ENGLISH POUND SIGN. AFTER SAVING, IT WILL AUTOMATICALLY SAVE AS A DIFFERENT SET OF CHARACTER.
11IT00984CONNECTIONS LEFT 'OPENED' ON RUN FROM THE SQL EDITOR.
12IT00998INSTALLED BROWSERS DO NOT SHOW UP IN REVIEW ACCESS PLAN GRAPH FOR DATA STUDIO 4.1.0.1.
13IT00870DB2 LUW CREATE LARGE TABLE SPACE: TRANSLATED DATA TAG INHERIT KEYWORD CAUSED CREATION DDL ERROR.
14IT01751DATA STUDIO 4.1 SHOULD TREAT AN IDENTIFIER OF UPPERCASE WITH # SIGN SAME AS LOWERCASE WITH # SIGN.
15IT01997PLAN_TABLE IS NOT DISPLAYED WHEN OPEN VE FROM DATA STUDIO SQL EDITOR.
16IT02101TIMESTAMP COLUMN DISPLAY PROBLEMS.
17IT02688PERFORMING EXPLAIN IN DATA STUDIO 4.1 RESULTS IN CHARACTER CONVERSION ERROR.
18IT02744DATA STUDIO 4.1 QUERY TUNER THROW ERROR FOR QUERY ANNOTATION ON DB2 V10NFM AND V11NFM.
19IT02816DATA STUDIO 4.1.0.1 USER GET THE MESSAGE ABOUT NOT HAVING SUPPORTED BROWSER WHEN TRY TO DISPLAY AN ACCESS PATH GRAPH.
20IT03308DATA 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
Sr. No.Description
193151,122,000Fixed the issue for improper removal of WLM Environment statement for native SQL stored procedure for DB2 for z/OS.
271074,7TD,000Support tuning specific statement on DB2 for z/OS environment, which uses double quotes as SQL delimiter.
388386,7TD,000Support running Workload Analytics Acceleration Advisor for specific static statements.
478422,122,000Support NON-SYSADM users to create explain tables automatically.
521130,057,649Support 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.
668100,072,649Support long query text for scheduling capture task from package cache.
739230,033,724Support displaying cardinality of TBSCAN of a global temporary table.
877846,122,000Support migration of workload control center view's privilege from Optim Query Workload Tuner 4.1.1.
977846,122,000Support doing configuration for DB2 for z/OS by using JCL.
1081745,999,616Support tuning specific workload, which includes CREATE TEMPORARY table statement on DB2 for Linux, UNIX, and Windows.
1175336,122,000Support 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.Description
109910,122,000Fixed the issue for 'Edit Data' when using SSL Connection.
217286,010,678Fixed the issue for default schema is not honored when used in SQL script on DB2 for z/OS.
315430,999,760Fixed the issue for 'Run' button is not enabled for IMPORT when specify a valid path with Japanese character.
445900,060,678Support deleting a row using Data Studio with specific Column type (Column type is VARCHAR, data type is HEX).
572660,250,631Support tuning statements, which contain expressions with OLAP specifications on DB2 for z/OS.
643125,L6Q,000Support capturing query environment by using the global setting for SQLID and SCHEMA.
770533,077,649Support tuning specific statements, which use function with alias as select-clause item on DB2 for Linux, UNIX, and Windows.
861526,077,724Support primaryAccess='P' for webVE.
943125,L6Q,000Support tuning specific statement, which refers to the temporal table on DB2 for z/OS v11 environment.
1093151,122,000Fixed 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.
Description
171151,122,000Fixed 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.
Ibm Data Studio For Mac Os X Download
Data Studio 4.1.2 APAR 4
Data Studio 4.1.2 APAR 4
Sr. No.Description
1Fixed 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
Sr. No.
Description
153832,L6Q,000Fixed the issue that Data Studio 'reorg' option is grayed out when a table has xml column.
232105,756,000Fixed the issue for getting an error when trying to select 'configure' on a database (DB2 v11.1).
388886,122,000Update 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.
Description
113113,999,706Fixed for Data perspective - Edit/Update of Columns in IBM Rational Developer for z systems to work as expected.
239801,230,631Fixed for Data Studio script execution stuck during export functionality
387831,100,838Fixed for Backup and configure functionality not working for DB2 11.1
473154,004,000Fixed for Data Studio not returning complete error messages back when it is connected to Big SQL.
590398,031,724Fixed for SQL QUERY BUILDER to avoid CURRENT TIMESTAMP being quoted in the where clause.
611752,999,706Fixed for com.ibm.datatools.* plugin issue in RDZ from Data Studio.
Data Studio 4.1.2 APAR 7
Ibm Data Studio For Mac Os X Download
Data Studio 4.1.2 APAR 7
Sr. No.
PMR Number
189458,122,000Fixed for Data Studio reverse engineering missing tables.
200411,160,846Fixed for Pasting filter string into object list view does not work properly.
344510,442,000Fixed for Data Studio 'WLM Environment' field length limitation.
421467,082,000Fixed for Stored procedure call failed when proceeded with comment line in sql script.
586345,082,000Fixed for Version 4.1.2 does not display DPF partitioned table spaces correctly.
662986,122,000Fixed for DEBUG source window shows the incorrect (inactive) version of the stored procedure in data studio for DB2 ZOS.
705816,999,724Fixed IMS SQL Parser to support Java Application programming API.
834340,442,000Fixed for fail to capture workload on Db2 z/OS version 11 compatible mode.
990697,442,000Fixed for show the original -553 error of setting CURRENT SQLID when tune query on Db2 z/OS.
1075238,057,649Fixed the -104 error when tune a query contains “-“ character.
1193435,250,631Fixed 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

Data Studio 4.1.3 APAR 1

Data Studio 4.1.3 APAR 1
Sr. No.
Description
1IT24573Failed to reflect default schema value while sql execution.
2JR59058Data Studio cannot batch-create federated nicknames.
3IT24636Byte to char converter error.java 1.4 is getting used though customer is using jdk 1.8.
4IT24550Data 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
1IT24983Parameters are not included in stored procedure deployment on DB2 for iSeries 7.2.
2IT24738
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
3IT25174Not able to use the Explain option in Data Studio and getting an error:
An internal Error occurred.
4IT21676DDL 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
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
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
1IT26550DS and IDAA shell sharing issue for visual explain on DB2zOS V12.
2IT26548Special symbols in a SQL statement.
3IT25794Data studio filer does not work for DB2 ZOS.
4IT25746User not able to view parameter marker window when sendDataAsIs property set to true.
5IT22206When generating the DDL for a VIEW, DDL will incomplete.
6IT25797Data Studio 4.1.3 and illegal timestamp format error when trying to open visual explain.
7IT26018AUTONOMOUS is not considered as valid keyword in DB2 ZOS v11 and v12 parsers for DS 4.1.3.
8Internal DefectsBreakpoints 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.
Description
1IT26807Data studio is incorrectly generating unique indexes for Primary Key constraints with incorrect names.
2IT26109IDAA Data Studio Client issues with Db2 V12R1M502.
3IT25174Not able to use Explain option in Data Studio and getting an error:
An internal Error occurred.
4IT25175Data Studio is not generating Access Plan Graph for Db2 LUW v11.1.
5IT27066Handle ParseNameException exception while generating Access Plan Graph in Data Studio 4.1.3.
6IT26806Two connections seen in the back end for one connection in data studio for Db2 LUW database.
7IT26314Japanese installation of Data studio 4.1.3 is not showing characters in Japanese on the Japanese operating system.
8
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
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
10Internal EnhancementAdded 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
1IT28533Online Check during deployment.
2IT27661DDL is not generated with the model for DB2 LUW.
3IT28078Null Pointer exception while browsing table data, connection issue.
4IT28403Data Studio DDL Generation for an ALIAS is not correct.
5IT28432Data Studio does not show the data in Privilege tab in Properties view.
6IT25174Not able to use Explain option in Data Studio and getting an error:
An internal Error occurred.
7IT28142Data Studio is not supporting null input into individual array elements.
8IT27813Comma can now be added in String array element as input in DB2 z/OS Native Stored Procedure in Data Studio.
9IT23365Native SQL Stored Procedure is failing with array as a parameter when called via Data Studio.
10IT26495Added support in Storage Group for physical data model.

Data Studio 4.1.3 APAR 5 Hotfix

Ibm Data Studio Download Mac

For
Data Studio 4.1.3 APAR 5 Hotfix
Sr. No.
Description
1IT29901Add 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
1IT29734The Instead Of parameter for Trigger is not shown properly after reverse engineering a model for table.
2IT29993Support for handling extra characters in DB2 NSP.
3IT29578Data Studio 4.1.3 APAR 5 Multivariate Distribution does not work with APAR 5 and previous versions.
4IT28629z/OS parser to offer 'Set Current Accelerator' statement validation.
5IT29543In Administration explorer, in Properties window of User / Role, in Privileges tab, the names of Package and Schema appear blank.
6EnhancementSupport for Data Studio for V11.5 version of DB2 LUW.
7Internal DefectNull pointer issue breaks QueryTuning for DB2 z/OS.
8Internal DefectDDL does not generate Create Procedure statements in Data Studio 4.1.3 DB2 z/OS 12.
9Internal DefectIn 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.
Description
1IT28700Issue while extracting data from a table.
2IT30179The SYSTOOLS Explain table show unknown format error during configuration.
3IT31001Added support for ISO format timestamp value for loading data in Db2 LUW.
4IT31040Query Tuning > Visual Explain fails for z/OS SSL environment
5IT32201Query Tuning > Generate recommendations > Statistics Explain hangs.
6IT32286Modifying table fails with SSL connection.
7IT32288Added support for the FETCH FIRST clause in Delete statement in Db2 z/OS 12.
8IT33295Generated DDL for Load in the Alter function is not compatible with Db2 LUW parameter setup.
9IT32482While configuring query tuning the DSN_Statement_Cache_Table appears in an unknown format in Db2 z/OS 12.
10IT33418Data Studio is unable to differentiate between the Allow and Disallow Debug modes of different versions of a Stored Procedure.
11EnhancementAdded support for Column Organized Tables property in a partitioned environment for Db2 LUW.
12NoneQualified support for Db2 LUW 11.5.4.

Content URL

[{'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