Articles & Content

Archives

All Things Being SQL (G12)

Topic: 2009 NA

Subtopic: DB2 for LUW



DATE: 2009-5-15 (08:00 AM - 09:00 AM)
SPEAKERS: Jerry Spence (National City Corporation)

Presentation will discuss the life of a SQL statement in DB2 on Unix platforms. A flow of SQL from submission to completion will be demonstrated. Tips on how to collect and tune SQL will be presented and how to use and read explain plans will be discussed and reviewed. Also, SQL in a DPF environment will be discussed.Tips on improving SQL for performance will be given.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

The life cyle of a SQL statement: Explain the flow of a SQL statement from submission to completion

How to view and capture SQL Statement; Will discuss tools and methods of capturing SQL statements

Explain the Explain path: Discuss the importantance of reading and understanding explain plans and using to tune and diagnose SQL for performance.

SQL in a DPF environment; Discuss how SQL is processed in a DPF environment.

Tips for SQL Peformance



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.