IDUG DB2 Tech Conference in Sydney, Australia 2014
Sydney, Australia
10 - 12 September, 2014

View Printable Version

Application and SQL Design for Performance

Session Number: 3050
Track: z/OS & Cross Platform Track
Session Type: Podium Presentation
Primary Presenter: Susan Lawson [YL&A]
Room(s)/
Time(s):

1.15 => Fri, Sep 12, 2014 (08:30 AM - 11:45 PM)

Speaker Bio: Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement and tune some of the worlds’ largest and most complex DB2 databases and applications. She also performs Performance and Availability Audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities include authoring articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM GOLD Consultant for DB2 and z/Series, and an IBM Information Champion and has authored the IBM ‘DB2 for z/OS V8 DBA Certification Guide’ and the IBM ‘DB2 for z/OS V7 Application Programming Certification Guide’. She is also the co-author of several DB2 books including the IBM ‘DB2 10 for z/OS DBA Certification Guide’, IBM ‘DB2 9 for z/OS DBA Certification Guide’, ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’. She is also a SME(Subject Matter Expert) for the IBM Certification exams for DB2 z/OS Database and System Administration assisting with writing and verifying questions for the exams.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), High Availability (DB2 for z/OS), SQL and XML Performance
Objective 1: * High performing applications

o What makes an application perform

o What kills application performance

Objective 2: * DB2 and SQL call reduction

o How to reduce calls

o Features to exploit

Objective 3: * SQL filtering and index usage

o Predicate Stages

o Promoting Predicate

Objective 4: * Minimizing application contention and overhead

o Locking reduction

o Lock avoidance

o Bind parameters

Objective 5: * 10 and 11 features

o Using new features to improve application performance

o Exploiting new SQL code

o Using additional Explain tables


Abstract:  This presentation will cover many alternatives to our normal applications in order to achieve performance. Many techniques to minimize overhead and locking will be explored. We will also take a look at techniques coding efficient SQL and minimizing the amount of data we bring back to process in our applications via optimal predicates, less repetition and better use of indexes. We will also look at recent release features in DB2 that can be exploited to achieve best performance.

For questions or concerns about your event registration, please contact aucpc@idug.org