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.

Forum

IDUG Db2 Tech Conference coming to San Paulo, Brazil and Mexico City! Register Now

Started by Surekha Parekh in What's hot ? on Thursday. 0 Replies

For the first time IDUG is hosting two events in Latin America. These seminars will bring together Db2 professionals from around the world for expert-led technical sessions and networking opportunities. This is your chance to connect! …Continue

Tags: Education

MSSQL linked server attaching to DB2 LUW

Started by Mike Jett in Application Development and DB2 Aug 15. 0 Replies

I am trying to create a linked server from MSSQL 2014  to DB2 11.1  I am able to create one linked server and get it to work with one DB.  I have not been able to figure out how to add additional catalogs(DB's).  Is it possible to use just one…Continue

Tags: server, linked

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service