Problems Fixed in the IBM Data Studio Client and InfoSphere Optim Query Workload Tuner, Version 3.2

Product documentation


Abstract

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

Content

Fixed problems
Description Affected Products
If running recommended RUNSTATS commands from the workflow assistant failed due to an error, a lock remained on SYSIBM>SYSTABLES. Data Studio client

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
Running the query formatter and annotation analysis tool from the workflow assistant sometimes resulted in the error message "An internal error occurred. Contact IBM Support for assistance." Data Studio client

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Explaining a query workload sometimes failed with a -206 SQLCODE if the workload contained static SQL statements in which double quotation marks were used. InfoSphere Optim Query Workload Tuner for DB2 for z/OS.
Capturing a set of SQL statements from a file that contains duplicate queries and saving them to a query workload failed to consolidate the duplicates. InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Attempting to explain an SQL statement caused Visual Explain to fail if the catalog data for the statement contained invalid XML characters. Data Studio client

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
When generating an access plan graph for a static SQL statement that contains host variables and comments, an error sometimes occurred. Data Studio client

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Using a secondary authorization ID that contains certain special characters to collect EXPLAIN information sometimes failed. In trace files, an Illegal group reference exception would appear. Data Studio client

InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Capturing a query workload from the statement cache after changing the default SQLID or SCHEMA sometimes failed with a -904 SQLCODE. InfoSphere Optim Query Workload Tuner for DB2 for z/OS

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

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.2

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

7036379

Modified date:

2012-12-07

Translate my page

Machine Translation

Content navigation