Articles & Content


SQL Search and Scroll Techniques in DB2 for z/OS (E17)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

DATE: 2010-11-11 (11:15 - 12:15)
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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.