~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Readme file for September 2017 fix (APAR7) for:

- IBM Data Studio client, Version 4.1.2

Details on the fix:
~~~~~~~~~~~~~~~~~~~~~~~~
This test fix addresses the following problem:

What's new in APAR7:
======IBM Data Studio client======
Fix: PMR 89458,122,000 - Fix for Data Studio reverse engineering missing tables.
Fix: PMR 00411,160,846 - Fix for Pasting filter string into object list view does not work properly.
Fix: PMR 44510,442,000 - Fix for Data Studio 'WLM Environment' field length limitation.
Fix: PMR 21467,082,000 - Fix for Stored procedure call failed when proceede with comment line in sql script. 
Fix: PMR 86345,082,000 - Fix for Version 4.1.2 doesn't not display DPF partitioned tablespaces correctly.
Fix: PMR 62986,122,000 - Fix for DEBUG source window shows the incorrect (inactive) version of the stred procedure in data studio for DB2 ZOS.
Fix: PMR 05816,999,724 - Fix IMS SQL Parser to support Java Application programming API.
Fix: PMR 34340,442,000 - Fix for fail to capture workload on Db2 z/OS version 11 compatible mode.
Fix: PMR 90697,442,000 - Fix for show the original -553 error of setting CURRENT SQLID when tune query on Db2 z/OS.
Fix: PMR 75238,057,649 - Fix the -104 error when tune a query contains “-“ character.
Fix: PMR 93435,250,631 - Fix the performance issue when tune Workload Statistics Advisor.
Fix: INTERNAL DEFECT - Fix for IDz defect caused by DS package-duplicate namespace issue.
Fix for fail to tune workload from Query Monitor due to certificate file has expired.
Fix for tune Workload Statistics Advisor abend due to table columns count is bigger than 255.

What's new in APAR6:
======IBM Data Studio client======
Fix: PMR 13113,999,706 - Fix for Data perspective - Edit/Update of Columns in IBM Rational Developer for z systems to work as expected.
Fix: PMR 39801,230,631 - Fix for Data Studio script execution stuck during export functionality
Fix: PMR 87831,100,838 - Fix for Backup and configure functionality not working for DB2 11.1
Fix: PMR 73154,004,000 - Fix for Data Studio not returning complete error messages back when it's connected to Big SQL. 
Fix: PMR 90398,031,724 - Fix for SQL QUERY BUILDER to avoid CURRENT TIMESTAMP being quoted in the where clause
Fix: PMR 11752,999,706 - Fix for com.ibm.datatools.* plugin issue in RDZ from Data Studio

What's new in APAR5:
======IBM Data Studio client======

Fix: PMR 53832,L6Q,000 - Fix the issue that Data Studio 'reorg' option is greyed out when a table has xml column.
Fix: PMR 32105,756,000 - Fix the issue for getting an error when trying to select "configure" on a database(DB2 v11.1).
Fix: PMR 88886,122,000 - Update the db2 jdbc driver to DB2 Level : v11.1 FP1( 4.22.29 and 3.72.24)



Items included in APAR4:
======IBM Data Studio client======
Fix 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.


Items included in APAR3:
======IBM Data Studio client======
Fix PMR71151,122,000 - fix the issue debugging for native stored procedure on DB2 for z/OS.
Fix the issue of database statements generation for schema on DB2 for z/OS.

Support to add host name for DB2 for z/OS connect server.
Support parser validation.

Items included in APAR2:
======IBM Data Studio client======
Fix: PMR 15591,L6Q,000 - don't block deployment process when recover ASU time if saved ASU time is not valid.
Fix: PMR 09910,122,000 - fix the issue for 'Edit Data" when using SSL Connection.
Fix: PMR 17286,010,678 - fix the issue for default schema is not honoured when used in SQL script on DB2 for z/OS.
Fix: PMR 15430,999,760 - fix the issue for "Run" button is not enabled for IMPORT when specify a valid path with Japanese's character.
Fix: PMR 45900,060,678 - support deleting a row using Data Studio with specific Column type(Column type is VARCHAR, data type is HEX).

Support updating sqlj4.zip to be compatible with Java 1.8.
Support recognizing future DB2 for Linux, UNIX, and Windows version which is higher than V10.6. Make it work normally for V10.6 features.

======InfoSphere Optim Query Workload Tuner======
Fix: PMR 72660,250,631 - support tuning statements which contain expressions with OLAP specifications on DB2 for z/OS.
Fix: PMR 43125,L6Q,000 - support capturing query environment by using the global setting for SQLID and SCHEMA.
Fix: PMR 70533,077,649 - support tuning specific statements which use function with alias as select-clause item on DB2 for Linux, UNIX, and Windows.
Fix: PMR 61526,077,724 - support primaryAccess='P' for webVE.
Fix: PMR 43125,L6Q,000 - support tuning specific statement which refer to the temporal table on DB2 for z/OS v11 environment.

Support tuning query from DB2 Query Monitor CAE Web Client with ¡®CR¡¯ in first line.
Support tuning workload from DB2 Query Monitor CAE Web Client, set current SQLID to proper value.


Items included in APAR1;
======IBM Data Studio client======
Fix: PMR 93151,122,000: fix the issue for improper removal of WLM Environment statement for native SQL stored procedure for DB2 for z/OS.

Support: Showing some specific tablespaces on DB2 for Linux, UNIX, and Windows.
Support: Updating jcc driver to support the java 1.8.

======InfoSphere Optim Query Workload Tuner======

Fix: PMR 71074,7TD,000: support tuning specific statement on DB2 for z/OS environment which using double quotes as SQL delimiter.
Fix: PMR 88386,7TD,000: support running Workload Analytics Acceleration Advisor for specific static statements.
Fix: PMR 78422,122,000: support NON-SYSADM users to create explain tables automatically.
Fix: PMR 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.
Fix: PMR 68100,072,649: support long query text for scheduling capture task from package cache.
Fix: PMR 39230,033,724: support displaying cardinality of TBSCAN of a global temporary table.
Fix: PMR 77846,122,000: support migration of workload control center view's privilege from Optim Query Workload Tuner 4.1.1.
Fix: PMR 77846,122,000: support doing configuration for DB2 for z/OS by using JCL.
Fix: PMR 81745,999,616: support tuning specific workload which includes CREATE TEMPORARY table statement on DB2 for Linux, UNIX, and Windows.
Fix: PMR 75336,122,000: support creating workload with query length between 3500 to 4000.

Support: SSL support in OQWT 412.
Support: Enable APG in Index What-if comparison result.
Support: Showing priorities in analysis results of single query advisor recommendations.
How to install the test fix:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*** NOTE: It is mandatory to have IBM Data Studio client 4.1.2

*** installed before applying this test fix

Please follow the guide in Hotfix Guide.pdf

How to uninstall the test fix:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please follow the guide in Hotfix Guide.pdf

Automatic uninstalls:
~~~~~~~~~~~~~~~~~~~~~
The TestFix is uninstalled automatically if there is no longer a package installed to which the fix applies. 
This is checked during updates and rollbacks.