Db2 for LUW

Explain and SQL access path analysis

Event:

Title:

Db2 für LUW – Explain and SQL access path analysis

Course code:

LT#EXPL

Date:

On request

Duration:

3,5 Days

Cost per person:

2.788,00€ excl. VAT

3.318,12€ incl. VAT

Organizer:

LIS.TEC GmbH

Location:

Ludwigsburg or

on site (plus travel costs)

Services:

Small study groups

Food & drinks

Seminar documents and training in german

If you register for several participants, we offer interesting graduated discounts.

You can register by sending an e-mail to schulung@listec.de

Contact: Herr Joachim Klassen

Telephone: +49 (0) 7141 93 93-0

Description: 

Database performance is not just a matter of parameter settings, but also largely of SQL. In this workshop, you will learn the tools and capabilities of Db2 to view and interpret the SQL flowcharts – and thus the results of Db2 optimization.

In addition to the administrative side of EXPLAIN use, special attention is given to the interpretation of the EXPLAIN expenses and the associated options for action and influence. In addition, it shows how Db2 parameters, SQL reformulations and optimized database objects can influence an access path.

The documents for the workshop are in German and on the most up-to-date Db2 stand – by means of exercises the theory is practically implemented.

 

Participants:

This workshop is designed for application developers, SQL specialists, and database administrators interested in analyzing SQL commands using Explain.

 

Objective:

Participants will learn about the key approaches and tools for SQL analysis, and how to interpret the Explain issues to make important inferences about improving database access. You are then able to perform SQL analysis and optimization in your usual Db2 environment independently.

 

The topics at a glance:

  • Introduction to the Db2 Optimizer working method
  • EXPLAIN
  • EXPLAIN analysis tools
  • Read and understand access plans for single and multi-partition databases
  • Access plans with Db2 BLU
  • SQL optimization with IBM Data Server Manager and IBM Data Studio
  • Statistics (RUNSTATS)
  • Db2 Optimizer guidelines
  • SQL Policies
  • Index Guidelines

 

Requirements:

  • good knowledge and experience with Db2
  • SQL knowledge

LIS.TEC GmbH

Contact us!