Upload

Loading icon Loading...

This video is unavailable.

DB2 LUW 10 -- Capture and Access Section Actuals Skill Builder

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like IBM Information Management Skills's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike IBM Information Management Skills's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add IBM Information Management Skills's video to your playlist.

Published on Dec 12, 2013

Standard DB2 LUW explain reports show estimated result counts for each operation in the access plan. These estimates are determined before the SQL statement is executed.
We will show how the DB2 procedure EXPLAIN_FROM_ACTIVITY can be used to generate an enhanced explain report that contains both estimated and actual runtime cardinalities, called Section Actuals, for each operation in the access plan.

Course Links:
DB2 for LUW Performance Tuning and Monitoring Workshop - DB2 10.1 (CL413)
http://www.ibm.com/services/learning/...


DB2 LUW Performance Tuning/Monitoring for Single/Multiple Partition DBs (CL443)
http://www.ibm.com/services/learning/...


Other links:
Training Paths: http://www.ibm.com/services/learning/... a) Advanced Database Administration -- Single Partition and DB2 pureScale http://www.ibm.com/services/learning/... b) Database Administration - Multiple Partition http://www.ibm.com/services/learning/...


Certification Program: http://www.ibm.com/software/data/educ... Test 000-610: DB2 10.1 Fundamentals http://www-03.ibm.com/certify/tests/o... Test 000-611: DB2 10.1 DBA for Linux, UNIX, and Windows http://www-03.ibm.com/certify/tests/o... Test 000-614: DB2 10.1 Advanced DBA for Linux UNIX and Windows http://www-03.ibm.com/certify/tests/o... DB2 10.5 Information Center See topic "Obtaining a section explain with actuals to investigate poor query performance" http://pic.dhe.ibm.com/infocenter/db2...

  • Category

  • License

    Standard YouTube License

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Loading...
Working...
Sign in to add this to Watch Later

Add to