Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Jun 17
    2008

    DB2 Application Tuner's Boot Camp

    Marlene Gaydos
    [highmark]
    Please note the location of the seminar:

    DB2 Application Tuner's Boot Camp

    June 26, 2008 ? Camp Hill, PA, United States

    One Day Seminar June 26, 2008
    Giant Super Food Store Community Room
    3301 Trindle Rd
    Camp Hill, PA 17011
    100% of performance audits easily discover poorly coded or performing SQL.
    These statements can easily add up to 25% total CPU utilization.

    If your goal is optimizing IT, DB2 SQL education and tuning is a low cost,
    immediate return, high ROI and low organizational blockade solution. Let
    SQL tuning expert Sheryl M. Larsen with over 20 years of DB2 experience,
    award winning lectures and course material, increase your developers? SQL
    tuning skills in as little as one day of education.
    Access paths are a significant factor of DB2® performance. DB2 chooses
    access paths, but developers and DBAs need to understand how access paths
    affect performance in certain situations. The class will concentrate on
    the skills required to be competent at changing the DB2 optimizers mind:
    what each access path is, when they are good, when they need to be
    altered, and when to apply the optimal tuning techniques. A workshop will
    follow to reinforce these skills.
    Learn how DB2 executes index, table and join access paths
    Learn when each access path is optimal and non-optimal
    Learn recommended SQL tuning techniques for changing the DB2 optimizer?s
    mind
    Learn how to identify potential access path problems
    Sheryl will lead students with a comprehensive demo and workshop of a free
    and convenient workstation tool for analyzing EXPLAIN output, IBM®
    Optimization Service Center for DB2 for z/OS (DB2 OSC). This tool is
    compatible with DB2 Version 8 and DB2 9 for z/OS.

    DB2 OSC is a workstation tool for monitoring and tuning the SQL statements
    that run as part of a workload on your DB2 for z/OS subsystem. You can use
    DB2 OSC to identify and analyze problem statements and receive expert
    advice about statistics that you can gather to improve the performance of
    an individual statement or an entire workload.

    By using DB2 OSC, you can gather EXPLAIN information for SQL statements
    and view that EXPLAIN information in a graphical format, instantly
    clarifying the relationships between objects (such as tables and indexes)
    and operations (such as table space scans and sorts). This one day hands
    on workshop will take you from the basic to the advanced level of using
    DB2 OSC and also provide a review of the DB2 9 SQL enhancements.

    Workshop prerequisite download: DB2 OSC is offered in the DB2 Accessories
    Suite for z/OS. You can use DB2 OSC on a Windows® 2000, Windows XP, or
    Windows 2003 workstation that has DB2 Connect? Enterprise Edition or DB2
    Connect Personal Edition, Version 8.1.7 installed.
    http://www-306.ibm.com/software/data/db2/zos/downloads/osc.html
    (installation help will be provided on site)
    Bring you own laptops for the DB2 OSC workshop (sharing is allowed)
    Learn how to navigate DB2 OSC to view access path graphs, EXPLAIN, and
    tune queries
    Learn how to identify and fix potential problems within a workload
    Become efficient at sourcing, reviewing and tuning SQL
    Cost: $250 (includes lunch)
    · Credit cards welcome
    · Checks made out to Sheryl M. Larsen, Inc.
    · Corporate Purchase Orders approval by phone (630) 399-3330

    RUG MEMBERS :
    Those planning on attending the fee based class on JUNE 26TH for DB2
    Application Tuner's Boot Camp, there is a prerequisite to download DB2
    OSC. Below is the directions to down load the DB2 OSC & the points that
    the class will cover.
    Workshop prerequisite download: DB2 OSC is offered in the DB2 Accessories
    Suite for z/OS. You can use DB2 OSC on a Windows® 2000, Windows XP, or
    Windows 2003 workstation that has DB2 Connect? Enterprise Edition or DB2
    Connect Personal Edition, Version 8.1.7 installed.
    http://www-306.ibm.com/software/data/db2/zos/downloads/osc.html
    (installation help will be provided on site)
    Bring you own laptops for the DB2 OSC workshop (sharing is allowed)
    Learn how to navigate DB2 OSC to view access path graphs, EXPLAIN, and
    tune queries
    Learn how to identify and fix potential problems within a workload
    Become efficient at sourcing, reviewing and tuning SQL

    There will be an introduction to this seminar at the RUG meeting on June
    25th.
    Description & sign up through the website - USE this site to Pay &
    Register : http://www.mwdug.org/DB2BCAMPJUN08/.
    Hope to see you all there!


    ---------------------------------------------------------------------------------
    Welcome to the DB2 User Group - Pittsburgh list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Pittsburgh.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Pittsburgh List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact