Topic: 2011 NA
Subtopic: DB2 for z/OS
DATE: 2011-5-6 (09:15 AM - 10:15 AM)
SPEAKERS: Daniel Luksetich (YL&A)
This presentation will address the many different ways you can search of data in DB2 for z/OS. It's concentration will be on table and index design to support searching and scrolling, as well as various SQL coding techniques for search capabilities and indexing. We will focus significantly on performance of queries while trying to keep the number of indexes to a minimum. It will also look at the basic and advanced scroll techniques and choices for performance from a practical coding perspective based upon real-world experience.
EXP. LEVEL: Beginner,Intermediate,Advanced
Discuss DB2 features that support searching and scrolling
discuss database and indexes design, including extreme design and performance tricks
Demonstrate the choices for matching on index columns for search queries
Discuss DB2 merge versus materialization and predicate transitive closure
Demonstrate possible program solutions for scrolling of multi-table queries
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.