The following notes describe important changes with fix pack 7:

• The use of profiles to monitor query performance or capture query workloads is deprecated, and is not recommended.
• Languages other than English are no longer supported in the user-interface, on-line help, and information center topics.
• The workstation client driver is no longer delivered with the server-enablement files for assembly and download through SMP/E. You can download the client driver to your workstation from the download site.

Back to top

The following fixes and enhancements are included in fix pack 7:

• The dependency on DB2 Connect is removed.
• The on-line help and information center topics are updated and reorganized.
• The number of checks for SYSADM authority by the workload control center are reduced, reducing the impact on auditing procedures.
• An option is added to specify whether to issue EXPLAIN STMTCACHE ALL statements when viewing queries or capturing workloads from the dynamic statement cache.
• The amount of historical EXPLAIN data is reduced, saving disk space in the project folder on your workstation and in the EXPLAIN tables on the data server.
• The performance of service SQL, viewing queries, and the workload control center is improved.
• An option is added to reset the layout of the user interface to the default configuration.
• An option is added to specify SMF or GTF as the destination for trace data.
• The service SQL and service workload functions are changed to always include DDL statements and statistics.
• An indication of the number of matching qualified rows is added to index scan nodes in access plan graphs.
• Explanations are added to the column headings of the view when viewing queries.
• The ability is added to migrate EXLAIN tables from non-UNICODE to UNICODE format.
• Defects related to the following situations are fixed:
  • SQLCODE -104 for static queries when the value DECIMAL POINT subsystem parameter is set to COMMA.
  • A problem in query annotation for outer joins.
  • Statistics advisor repeatedly issuing previously applied recommendations.
  • Log file conflicts for multiple DB2 for z/OS subsystems that share the same z/OS UNIX System Services environment.
  • A problem with the windows registry that prevented the installation of Optimization Service Center and Optim Query Tuner Version 2.2 on the same workstation.
  • Access plan graphs for SQL statements that have the following characteristics:
    • Contain columns with field procedures.
    • Contain key words for text search.
    • Involve any virtual indexes.
  • Handling non-English and special characters in service SQL, query annotation, and the statistics advisor.
  • The time stamp format when identifying queries in EXPLAIN tables.
  • Service SQL, including correct DDLs for partitioned table spaces, partitioned indexes, default tables spaces in DB2 9, and others.
• Requirements from the following PMRs have been fixed:
  • 65388,661,706
  • 83963,379,000
  • 83749,211,788
  • 71037,180,000
  • 69408,032,724
  • 68179,032,724
  • 54162,370,000
  • 48509,379,000
  • 47121.708.708
  • 37758,379,000
  • 21905,075,724
  • 10766,077,724
  • 05937,300,624
  • 05218,113,848
  • 05208,114,848
  • 83310,122,100

Back to top

Hardware requirements

Ensure that your workstation meets the following hardware requirements:

• 500 MB of space on your hard disk drive
• 1 GB of memory

Software requirements

Ensure that you have the 32-bit version of one of the following Microsoft Windows® operating systems installed on your workstation:

• Windows XP
• Windows 2003
• Windows Vista® *

* Additional requirements for using Optimization Service Center on Windows Vista workstations:

• Install Optimization Service Center in a directory that is not part of the "Program Files" directory. User-level accounts cannot write files in the Windows Vista "Program Files" directory. Because of user account control restrictions, silent installation cannot be used for Windows Vista workstations.
• Add the logon user to the "DB2ADMNS" group to give them the required access to execute DB2 Version 9 programs and applications. You must do this, even if the user is a member of the local administrators group, to provide read access to DB2 configuration and application data.

Back to top

This sofware offering contains the following files:

• media.inf - a file that you can use to create an OSC installation CD
• readme.txt - describes the files in the distribution
• response.txt - stores silent install instructions and the default settings
• setup.exe - a Windows native install file that supports interactive installation
• silent.bat - a batch file to use the response file for silent installation

Back to top

For more information about how to install Optimization Service Center, see Installing Optimization Service Center.

Back to top

Ensure that the host data server runs one of the following versions of DB2:

• DB2 for z/OS, V8 conversion mode (CM) and DB2 for z/OS, V8 new-function mode (NFM)
• DB2 9 for z/OS conversion mode (CM) and DB2 9 for z/OS new-function mode (NFM)

For a list of additional PTFs and the PUT level that are required by Optimization Service Center, see: Key prerequisites for using Optimization Service Center for DB2 for z/OS

The following facilities and environments must be enabled before you can configure your DB2 subsystem for query tuning and tune queries and workloads from the Optimization Service Center client:

• Distributed data facility (DDF)
• Java™ environment (optional, but recommended)
• Administrative task scheduler (optional, but recommended)
• DB2-supplied stored procedures
• A DB2OSCA RACF group

For detailed information about these requirements, and instructions for configuring your DB2 subsystem for tuning, see Configuring DB2 for z/OS subsystems for Query Tuning.

Back to top

This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:

     IBM Director of Licensing
     IBM Corporation
     North Castle Drive
     Armonk, NY  10594-1785
     U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:

     IBM World Trade Asia Corporation
     Licensing
     2-31 Roppongi 3-chome, Minato-ku
     Tokyo 106, Japan

The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law:
INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.

This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

Any references in this publication to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is as your own risk.

Licenses of this program who want to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:

     IBM Corporation
     J74/G4
     555 Bailey Avenue
     San Jose, CA 95141-1003
     U.S.A.

Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.

The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.

Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurement may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.

Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.

All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

For complete information about trademarks and service marks used in this document and IBM Optimization Service Center for DB2 for z/OS, see: Copyright and trademark information.

The following terms are trademarks or service marks of the IBM Corporation in the United States or other countries or both:

   
     DB2                        
     z/OS    
     IBM          
   

Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.

Microsoft, Windows, Windows NT, Windows Vista and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.

Back to top