www.themisinc.com
Open in
urlscan Pro
173.46.149.48
Public Scan
URL:
https://www.themisinc.com/training/Advanced-Query-Tuning-with-IBM-Data-Studio-on-Db2-for-zOS
Submission: On May 26 via api from US — Scanned from CA
Submission: On May 26 via api from US — Scanned from CA
Form analysis
1 forms found in the DOMPOST ./Advanced-Query-Tuning-with-IBM-Data-Studio-on-Db2-for-zOS
<form method="post" action="./Advanced-Query-Tuning-with-IBM-Data-Studio-on-Db2-for-zOS" id="ctl01">
<div class="aspNetHidden">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE"
value="hoaa323cv5VdIF6xUs5D1DISBa2FMEY5x4p2Jb0jc5uZiNJ9eO8zn8AJIoSXJkPC4sTd4s2hcLywR22sAHZQdJWhFKTIqv841KO6TgIt4CEN6SshMSVtN4aL7dJFVolcztVM7beUu2g4NPGkpsJkw/FOWxL4BrOu4ozU3RVI4H30gvh3CSPw3PD4AzUD8Z5PrFARQEU+k/zN9q6nOK9H5Bh2+w8pIt8oClkBk3j4gihXnEy32b3QB4Tva9lje/zEpr5HixqDu6evJ2fEDmFG6R9anmUWJ6DEucnujou5JOD9H+J9c4ujsLThcTq1dIh0LziLnVzZG0nerBiWQVmLf4IqGeky6caJX6gVNDTEoDBlq/tGnUMILPypeO5d+LzjXYyveFJ9HDyTBfI6dfoaB7aQANS3/tAlYe/XDkq9Od4KIt0gg6tWXBL4rw62HXapxpnv0qcTdCT1gKAj4X9sgVcDxgwaZ+3CWI6aVDl22YBsHuQlgq1T7mjszl2pVPZ8nM03/qjuxDfRGt3u7r1KhP5JtuHxhr668gG09jRQGF4=">
</div>
<div class="aspNetHidden">
<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="F3E4E223">
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="OnjMPKVHDoUeLwp9xpKG/FgOKxI64YMqxzKiwqs9kVkclj7RoSoL6cLbjYoLhwP9u5jnIIS6aUkqa6b0V+TeXeJvCZvOo8SoPJp0KBBeblQ/KmhrZTz25TpcMfB8IijY">
</div>
<div class="header">
<input type="image" name="ctl00$logo" id="logo" src="../Images/Themis_LOGOsmall.jpg" alt="Themis Logo">
<span class="menubar">
<a href="../Default.aspx" class="menuitem">Home</a>
<a href="../About.aspx" class="menuitem">About</a>
<a href="../Courses.aspx" class="menuitem">Courses</a>
<a href="../Schedule" class="menuitem">Schedule</a>
<a href="../Services.aspx" class="menuitem">Services</a>
<a href="../Webinars" class="menuitem">Webinars</a>
<a href="../Contact.aspx" class="menuitem">Contact</a>
<a href="../Search.aspx" class="menuitem">Search</a>
<a id="hlUser" class="menuitem"></a>
</span><br>
</div>
<div class="mainBlank">
<div class="theOutline">
<span>
<div class="upperPortion" xmlns="http://www.w3.org/1999/xhtml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<div class="synopsis">
<h2>Advanced Query Tuning with IBM Data Studio on Db2 for z/OS</h2>
<span style="float:right" id="boxLink4">
<a href="../CourseSched.aspx?id=DB1037">
SEE SCHEDULE
</a>
</span>
<div>
<h3> Duration: 3.0 days</h3>
<h3> Method: Instructor led, Hands-on workshops</h3>
<h3> Price: $1920.00</h3>
<h3> Course Code: DB1037</h3>
<h3>
<br>
</h3>
</div>
</div>
</div>
<div class="outlineSection" xmlns="http://www.w3.org/1999/xhtml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<div class="leftColumn">
<h2>View Related Video</h2>
<div>
<iframe width="400" height="200" frameborder="2" allowfullscreen="allowfullscreen" src="https://www.youtube.com/embed/LLs-gTKpgLs"> This text does not appear but forces a necessary closing tag for the iframe </iframe>
</div>
<h2>Audience</h2>
<p>Application Architects, analysts, developers and DBAs involved in the development and support of Db2/SQL applications. </p>
<h2>Description</h2>
<div class="topicsDetail">
<p>Get ready for a deep dive into Db2 for z/OS Optimization. This course is for the Db2 for z/OS development professional who desires to understand the fundamental issues associated with performance for SQL applications. Emphasis is
placed on new considerations for the latest releases of Db2 and the use of IBM Data Studio as an optimization tool. Concepts discussed will be reinforced with appropriate workshops. This class covers optimization features and
enhancements through V11. There are many hands on workshops during these 3 days where students are coding, explaining, and analyzing SQL statements. Students will come out of this class much stronger in the SQL language and Db2
optimization. Many times there are 2, 3, 4, 5 different ways to code SQL statements in getting the same result. Which way is best? These are discussed in great detail with Db2 explains to back them up. Of course ‘It Depends’! </p>
</div>
<h2>Objectives</h2>
<div class="objectivesDetail">
<p>Upon successful completion of this course, the student will be able to:</p>
<ul>
<li>Understand the different types of access paths and when each are desirable</li>
<li>Navigate through the features of the IBM Data Studio tool</li>
<li>Read through a Db2 visual explain</li>
<li>Understand new statistics available in the latest releases of Db2 and their impact on access path selection</li>
<li>Learn new optimization techniques available from Db2 9 optimizer (correlating and de-correlating) up through V11</li>
<li>Use the information provided by IBM Data Studio to improve the performance of Db2 applications</li>
</ul>
</div>
<h2>Prerequisites</h2>
<p>A basic understanding of the SQL language is helpful.</p>
</div>
<div class="rightColumn">
<h2>Topics</h2>
<div class="topicsDetail">
<ul>
<li class="topLevel">I. Optimization Goals & Tools<ul type="disc">
<li>Goals of Optimization</li>
<li>Deciding what to tune</li>
<li>What causes CPU and I/O<ul type="circle">
<li>Use of Functions, triggers, etc.</li>
<li>Keeping too much data too long</li>
</ul>
</li>
<li>Optimizer overview</li>
<li>Explain output<ul type="circle">
<li>PLAN_TABLE</li>
<li>DSN_STATEMNT_TABLE</li>
<li>Additional Explain Tables</li>
</ul>
</li>
<li>Viewing explain output in IBM Data Studio</li>
</ul>
</li>
<li class="topLevel">II. Access Paths with IBM Data Studio<ul type="disc">
<li>Single Table Access<ul type="circle">
<li>Tablespace Scan</li>
<li>Sequential Prefetch</li>
<li>Index Scans</li>
<li>Index Screening</li>
<li>List Prefetch</li>
</ul>
</li>
<li>Multiple Table Access<ul type="circle">
<li>Optimizing Inner and Outer Joins</li>
<li>Join method selection</li>
<li>Sorting</li>
<li>Avoiding sorts</li>
<li>Join order</li>
</ul>
</li>
<li>Predicate Transitive Closure</li>
</ul>
</li>
<li class="topLevel">III. Filter Factors & Performance<ul type="disc">
<li>Catalog Statistics via IBM Data Studio</li>
<li>What is a filter factor?</li>
<li>Use in index selection</li>
<li>Use in join order selection</li>
<li>Use in join method selection</li>
<li>How are filter factors calculated?</li>
</ul>
</li>
<li class="topLevel">IV. Predicate Types<ul type="disc">
<li>Software levels</li>
<li>Predicate processing order</li>
<li>Viewing predicate details in IBM Data Studio</li>
<li>Stage 1 vs Stage 2 processing</li>
</ul>
</li>
<li class="topLevel">V. Case Studies in Optimizer Problems<ul type="disc">
<li>Case 1: 2 Possible Indexes</li>
<li>Case 2: Join Order</li>
<li>Case 3: Range Predicates</li>
<li>Case 4: Host Variables</li>
</ul>
</li>
<li class="topLevel">VI. Design for Performance<ul type="disc">
<li>Index Only Access for screening and data retrieval</li>
<li>Clustering decisions</li>
<li>Multiple Index Access</li>
<li>Sort Avoidance</li>
<li>Index on Expression</li>
<li>Partitioning</li>
</ul>
</li>
<li class="topLevel">VII. IBM Data Studio Features<ul type="disc">
<li>Saving access paths as XML files</li>
<li>Building SQL statements</li>
<li>Formatting SQL statements</li>
<li>Explaining SQL statements</li>
<li>Query Formatting</li>
<li>Obtaining queries from packages</li>
<li>Generating Service SQL</li>
<li>Statistics Advisor</li>
</ul>
</li>
<li class="topLevel">VIII. Top 35+ Tuning Tips for Db2 SQL Developers<ul type="disc">
<li>(and More)</li>
<li>SQL Standards and Guidelines</li>
<li>Programming guidelines</li>
<li>Db2 SQL Tuning Tips</li>
</ul>
</li>
</ul>
</div>
</div>
</div>
</span>
</div>
</div>
<div class="footer">
<a href="../#" id="copyright">Copyright ©2022 Themis, Inc. All rights reserved</a>
<iframe id="twitter-widget-0" scrolling="no" frameborder="0" allowtransparency="true" allowfullscreen="true" class="twitter-follow-button twitter-follow-button-rendered" style="position: static; visibility: visible; width: 174px; height: 20px;"
title="Twitter Follow Button"
src="https://platform.twitter.com/widgets/follow_button.bbd13993eb53d3a11ac08f5e8cf9d6a4.en.html#dnt=false&id=twitter-widget-0&lang=en&screen_name=ThemisTraining&show_count=false&show_screen_name=true&size=m&time=1653598233416"
data-screen-name="ThemisTraining"></iframe>
<script async="" src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>
<a href="../privacy.aspx" id="privacyLink">Privacy Policy</a>
</div>
</form>
Text Content
Home About Courses Schedule Services Webinars Contact Search ADVANCED QUERY TUNING WITH IBM DATA STUDIO ON DB2 FOR Z/OS SEE SCHEDULE DURATION: 3.0 DAYS METHOD: INSTRUCTOR LED, HANDS-ON WORKSHOPS PRICE: $1920.00 COURSE CODE: DB1037 VIEW RELATED VIDEO This text does not appear but forces a necessary closing tag for the iframe AUDIENCE Application Architects, analysts, developers and DBAs involved in the development and support of Db2/SQL applications. DESCRIPTION Get ready for a deep dive into Db2 for z/OS Optimization. This course is for the Db2 for z/OS development professional who desires to understand the fundamental issues associated with performance for SQL applications. Emphasis is placed on new considerations for the latest releases of Db2 and the use of IBM Data Studio as an optimization tool. Concepts discussed will be reinforced with appropriate workshops. This class covers optimization features and enhancements through V11. There are many hands on workshops during these 3 days where students are coding, explaining, and analyzing SQL statements. Students will come out of this class much stronger in the SQL language and Db2 optimization. Many times there are 2, 3, 4, 5 different ways to code SQL statements in getting the same result. Which way is best? These are discussed in great detail with Db2 explains to back them up. Of course ‘It Depends’! OBJECTIVES Upon successful completion of this course, the student will be able to: * Understand the different types of access paths and when each are desirable * Navigate through the features of the IBM Data Studio tool * Read through a Db2 visual explain * Understand new statistics available in the latest releases of Db2 and their impact on access path selection * Learn new optimization techniques available from Db2 9 optimizer (correlating and de-correlating) up through V11 * Use the information provided by IBM Data Studio to improve the performance of Db2 applications PREREQUISITES A basic understanding of the SQL language is helpful. TOPICS * I. Optimization Goals & Tools * Goals of Optimization * Deciding what to tune * What causes CPU and I/O * Use of Functions, triggers, etc. * Keeping too much data too long * Optimizer overview * Explain output * PLAN_TABLE * DSN_STATEMNT_TABLE * Additional Explain Tables * Viewing explain output in IBM Data Studio * II. Access Paths with IBM Data Studio * Single Table Access * Tablespace Scan * Sequential Prefetch * Index Scans * Index Screening * List Prefetch * Multiple Table Access * Optimizing Inner and Outer Joins * Join method selection * Sorting * Avoiding sorts * Join order * Predicate Transitive Closure * III. Filter Factors & Performance * Catalog Statistics via IBM Data Studio * What is a filter factor? * Use in index selection * Use in join order selection * Use in join method selection * How are filter factors calculated? * IV. Predicate Types * Software levels * Predicate processing order * Viewing predicate details in IBM Data Studio * Stage 1 vs Stage 2 processing * V. Case Studies in Optimizer Problems * Case 1: 2 Possible Indexes * Case 2: Join Order * Case 3: Range Predicates * Case 4: Host Variables * VI. Design for Performance * Index Only Access for screening and data retrieval * Clustering decisions * Multiple Index Access * Sort Avoidance * Index on Expression * Partitioning * VII. IBM Data Studio Features * Saving access paths as XML files * Building SQL statements * Formatting SQL statements * Explaining SQL statements * Query Formatting * Obtaining queries from packages * Generating Service SQL * Statistics Advisor * VIII. Top 35+ Tuning Tips for Db2 SQL Developers * (and More) * SQL Standards and Guidelines * Programming guidelines * Db2 SQL Tuning Tips Copyright ©2022 Themis, Inc. All rights reserved Privacy Policy