IBM Support

Problems fixed in InfoSphere Optim Query Workload Tuner, Version 4.1.1 and the unlicensed tuning features in the IBM Data Studio client, Version 4.1.1

Product Documentation


Abstract

This document lists the problems that have been fixed in InfoSphere Optim Query Workload Tuner, Version 4.1.1 and in the unlicensed tuning features in the IBM Data Studio client, version 4.1.1.

Content

Fixed problems
Description Affected Products
Tuning a query workload in which the referenced tables were partitioned into many partitions could cause the product to return an OutOfMemory exception and crash.

Fixed in APAR IC99548
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
When tuning single SQL statements that run on DB2 for Linux, UNIX, and Windows that is running on an AIX 64-bit system, the DB2 JDBC driver could return an error with the error code -4472.

Fixed in APAR IT01951
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
Data Studio client running unlicensed tuning features
The Workload Analytics Acceleration Advisor considered static SQL statements as ineligible for offloading if those statements contained unqualified table references and were bound with a default qualifier.

Fixed in APAR PI20370
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
The Workload Statistics Advisor returned a NullPointerException when processing an index for which the value in the IX_EXTENSION_TYPE column in the SYSIBM.SYSINDEXES table was T for "Spatial".

Fixed in APAR PI18351
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
For SQL statements that run on DB2 10 for z/OS and use the XMLQUERY scalar function, the product returned a StringIndexOutofBound exception.

Fixed in APAR IT02688
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
Manually setting the STATSTIME column in the SYSIBM.SYSTABLES and SYSIBM.SYSCOLUMNS tables to 9999-12-31-24.00.00.00000 no longer causes an error. This timestamp is automatically converted to 9999-12-31-23.59.59.999999 by the product.

Fixed in APAR IT01951
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
Running the Statistics Advisor or Index Advisor on an SQL statement or query workload for DB2 10 for z/OS NFM could generate an internal error.

Fixed in APAR PI18351
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
When an SQL statement that runs on DB2 for z/OS was displayed in an access plan graph, the Plan Table tab did not appear.

Fixed in APAR PI19974
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
When tuning an SQL statement or a query workload that runs against DB2 10 for z/OS Conversion Mode and invoking SYSPROC.DSNAEXP to explain the statement or statements, you might encounter an SQLCODE -551 error.

Fixed in APAR PI18241
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
Access plan diagrams could not be displayed when the Data Studio client was shell-sharing with InfoSphere Warehouse Design Studio, Version 10.5.

Fixed in APAR IT01951
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
Access plan graphs could not be displayed in Microsoft Internet Explorer 9.1 because the Data Studio client could not detect that browser on the system.

Fixed in APAR IT00998
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
Generating an access plan graph no longer causes the following error for non-administrative Windows users who do not have access to the registry: "No supported browser is found. Try installing another browser and opening the access plan graph again." InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features
Though the Data Studio client was installed with English only, access-plan graphs were displayed in the operating system's current language.

Fixed in APAR IC99607
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Data Studio client running unlicensed tuning features

[{"Product":{"code":"SS7LB8","label":"InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"4.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS7L9Q","label":"InfoSphere Optim Query Workload Tuner for DB2 for z\/OS"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27042251