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
| 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 |
| 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:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.