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
| 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":"BU059","label":"IBM Software w\/o TPS"},"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"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27042251