Session Abstracts

SQL PL – Creative Uses

David Simpson, Themis

The SQL PL language is useful for writing stored procedures, user defined functions (UDFs) and triggers.  The language is becoming more powerful with each release.  This session will cover the basics of the language and give you some samples to take home and try!

• Overview of SQL PL
• Strengths and Limitations of SQL PL
• Sample stored procedures for use anywhere!
• Sample user defined functions for use anywhere!
• SQL PL and Triggers

Access Path Stability on Db2 for z/OS - Best Practices

David Simpson, Themis

DB2 has provided some great features for stabilizing performance through changes in the environment, particularly through a DB2 version upgrade.  In this session we will look at the evolution of access path stability over the last few releases and provide some thoughts on best practices for implementation.

• Plan Management
• Access Path Reuse
• Comparing Access Paths
• Bind Output Using APREUSE and APCOMPARE
• Best Practices