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

Enhancements to Insert Algorithm 2

Posted by Eric Radzinski on March 13, 2019 at 19:51 0 Comments

Db2 for z/OS APAR PH02052 provides some significant enhancements to Insert Algorithm 2, which was introduced in Db2z 12 to provide faster INSERT throughput for unclustered INSERTs on universal table space objects that use the MEMBER CLUSTER…

Continue

Videos

  • Add Videos
  • View All

DB2 for z/OS APARS

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service