Upload

Loading...

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

626 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
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...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...