Problems Fixed in the IBM Data Studio Clients and InfoSphere Optim Query Workload Tuner, Version 3.1.1

Product documentation


Abstract

This document lists the problems that have been fixed in the IBM Data Studio clients and InfoSphere Optim Query Workload Tuner, Version 3.1.1.

Content

Fixed problems
Description Affected Products
Running the Query Annotation tool sometimes resulted in the error message "The XML format is not correct. XML tag PREDICATE cannot be followed by tag CASE. Correct this syntax." InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Running the Query Annotation tool sometimes resulted in the error message "An internal error occurred. Contact IBM Software Support for assistance." In trace files, an IndexOutOfBoundsException exception would appear. InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Running the Index Advisor or Workload Index Advisor sometimes failed with a -802 SQLCODE. InfoSphere Optim Query Workload Tuner for DB2 for z/OS.
In the list of attributes for tables in access plan graphs, the attributes Second High Key and Second Low Key did not display NULL as values when appropriate. Data Studio clients

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
The option "Use the SYSPROC.OPT_RUNSQL stored procedure to run the EXPLAIN statement" option in the wizard Set Criteria for Capturing SQL Statements from the Dynamic Statement Cache was disabled, even if the stored procedure was correctly set up. Data Studio clients

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Conflicting settings at the client and at the server for the DSNHDECP values for number delimiters and decimal points could lead to java.lang.NumberFormatException exceptions. Data Studio clients

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
After the creation of an access plan graph, open threads were sometimes not closed. Data Studio clients

InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
On the Tune page of the Task Launcher, clicking "Tune single SQL queries" generated an org.xml.sax.SAXParseException exception. Data Studio clients

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Creating the ADVISE_INDEX table with the SYSINSTALLOBJECTS stored procedure could cause an error when the workflow assistant checked whether a database was configured properly for tuning queries. Data Studio clients

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

Cross reference information
Segment Product Component Platform Version Edition
Information Management InfoSphere Optim Query Workload Tuner for DB2 for z/OS z/OS 3.1.1

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows

Software version:

3.1.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

7024835

Modified date:

2012-04-27

Translate my page

Machine Translation

Content navigation