Data Studio Query Tuning Primer & Capturing environments of SQL statements and query workloads that run on DB2 for z/OS
KevinHarrison 1000005N52 Visits (3151)
When you work with IBM Support to resolve problems that you are having when tuning queries or query workloads, you might have to send the support team a set of files that they can use to reproduce the environment in which the queries or query workloads are running.
Capturing this information is very helpful when you are
working with IBM Support to resolve a problem tuning an SQL statement or a
query workload. After you open a PMR regarding a problematic SQL statement or
query workload, IBM support technicians
The attached link explains how to collect and send these files.
KevinHarrison 1000005N52 Visits (3318)
The BookManager format is being discontinued. We knew it was coming, but now for DB2 Version 10 the Bookmanager format is no longer available.
IBM® is discontinuing the BookManager® format as part of an ongoing effort to deliver the best possible information experience to our customers. IBM is optimizing the DB2® for z/OS® information for viewing in the information center.
The BookManager books will continue to be provided for DB2 UDB for z/OS Version 8 and DB2 Version 9.1 for z/OS; however, IBM is not delivering BookManager books with DB2 Version 10 for z/OS. Instead, you can find the Information Management Software for z/OS Solutions Information Center at the following website: http
The information center includes all of the information that you are used to seeing in BookManager and PDF, plus many improved features for finding and viewing the information that you need. To help your transition from BookManager to the information center, see the following resources:
Information Management Software for z/OS Solutions Information Center Flyer
See this 2-page PDF flyer for a quick overview of information center features. You can print the second page and use it as a reference sheet for using the information center.
DB2 for z/OS Best Practices: Finding Information Fast and Efficiently
View this webcast to learn tips and techniques for accessing DB2 for z/OS information quickly.
Information center viewlets
View these Flash tours for the following lessons:
Getting started with the information center
Using search scopes and advanced search techniques to find information quickly
Identifying new content in the information center
Marissa ParkerDB2 for z/OS and DB2 QMF