Articles & Content

Archives

Database Performance Discoveries and Recommendations (F04)

Topic: DB2 for z/OS

Subtopic: 2011



DATE: 2011-5-3 (04:30 PM - 05:30 PM)
SPEAKERS: Dave Beulke (Dave Beulke and Associates)

Is your database application experiencing poor response time, scalability problems, and too many deadlocks or poor application performance? One or a combination of zParms, database design and application coding techniques can cause these performance issues. There are many new DB2 9 and DB2 10 techniques, system parameters, database design, and application coding methods to avoid problems and revitalized your older databases' performance. This presentation will take you through the discoveries found during recent performance reviews and you will learn about the latest recommendations for fixing your database and application performance problems.

EXP. LEVEL: Intermediate

OBJECTIVES:

Find out the latest recommendations for database designs and application performance coding

Learn about the latest zParms and the optimum settings for OLTP or DW BI systems

Understand the database design techniques with the PBG and PBR tablespaces

Learn the latest coding considerations and techniques for Java and .NET applications

Understand the latest consideration and recommendations for efficient setup and maintenance of your tablespaces and indexes



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.