Skip to main content

Software  >  Information Management  >  DB2 Product Family  >  

Visual Explain with Statistics Advisor

 Product documentation
 
Abstract
DB2® for z/OS® Visual Explain Version 8 has been overhauled to provide quick answers to questions that customers have been asking for years. Is a predicate S1 or S2? What is the filter factor for a predicate? How many rows does the optimizer estimate are being returned? How big is my sort? If PAGE_RANGE is set to yes, what partitions qualify? Answers to all of these questions and more are at your mouse click. This presentation shows DBAs how to leverage new capabilities within Visual Explain.
 
 
Content
Patrick Bossman, IBM® Advisory Software Engineer

DB2 for z/OS Visual Explain Version 8
 
Related information
IBM DB2 Visual Explain
IBM Optimization Service Center for DB2 for z/OS
 
 
Original publication date
2004/9/20
 
 

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.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Data Management
 Data Servers (Database Management Systems)
 DB2 for z/OS
 Visual Explain
 Operating system(s):
  z/OS
 Software version:
  8.0
 Reference #:
  7005488
 IBM Group:
 Software Group
 Modified date:
 2004-09-28

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.