Product Documentation
Abstract
This document lists the problems that have been fixed in InfoSphere Optim Query Workload Tuner, Version 4.1.0.1 and in the tuning features in the IBM Data Studio client, version 4.1.0.1.
Content
| Description | Affected Products |
|---|---|
| An error with SQLCODE -104 would occur if tools and advisors were run on a static SQL statement captured from a catalog plan or package, the statement declared a cursor, and the name of the cursor contained the string "FOR". | InfoSphere Optim Query Workload Tuner for DB2 for z/OS Data Studio client |
| Selecting a table node in an access plan graph and then selecting a "multiple columns frequency distribution" in the Description of Selected Node area would cause the phrase "invalid Hex Value" to be appended to the value in the Value column when the data type of the value was Decimal and the value was "NULL". | InfoSphere Optim Query Workload Tuner for DB2 for z/OS Data Studio client |
| When an access plan used a range-list index scan (ACCESSTYPE='NR'), the resulting access plan graph lacked information about the attributes of all of the nodes. | 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 |
| The OWNER filter criterion for capturing from DB2 Query Management Facility was ignored. | InfoSphere Optim Query Workload Tuner for DB2 for z/OS Data Studio client |
[{"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.0.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":"PF035","label":"z\/OS"}],"Version":"4.1.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"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":"","label":"Linux zSeries"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"4.1.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27039792