SpDUG workshop "SQL Performance"

Event Details

SpDUG workshop "SQL Performance"

Time: November 12, 2018 from 9am to 1:30pm
Location: Hotel Meliá Avenida América
Street: Calle de Juan Ignacio Luca de Tena, 36
City/Town: MADRID
Website or Map: https://www.melia.com/es/hote…
Phone: +34699488915
Event Type: workshop
Organized By: SpDUG in collaboration with IBM
Latest Activity: Nov 10, 2018

Export to Outlook or iCal (.ics)

Event Description

This workshop is aimed at Db2 Developers, DBAs and Systems Programmers who are interested in collecting performance data for SQL statements, and understanding and tuning access plans chosen by the Db2 for z/OS Optimizer. 
Topics include: The Dynamic Statement Cache; EXPLAIN basics; Optimization Hints; Statement Level hints and The Access Path Repository; Catalog Statistics and The Db2 Optimizer; Walkthrough of Typical Access Path Problems. 
The workshop also looks at the access path management enhancements introduced by Db2 12. 

More information at http://l.spdug.org/foruminfows 

Comment Wall

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

A reminder to convert pagesets for Db2 for z/OS objects to the 10-byte extended RBA and LRSN format

Posted by Paul McWilliams on January 8, 2019 at 19:20 0 Comments

Db2 for z/OS APAR PH02437 introduces the new DSNB233I message in Db2 12…



  • Add Videos
  • View All

DB2 for z/OS APARS

PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service