Articles & Content

Archives

Database Performance Discoveries and Recommendations (F01)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-11-8 (11:30 - 12:30)
SPEAKERS: Dave Beulke (Dave Beulke )

Is your database application experiencing poor response time, scalability problems, too many deadlocks or poor application performance? One or a combination of zParms, database design and application coding techniques can cause these performance issues. The DB2 Version 9 for z/OS and new Version 10 techniques, system parameters, database design, and application coding methods are discussed so you can avoid problem 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: Beginner,Intermediate,Advanced

OBJECTIVES:

Understand the database design techniques for avoiding locking and deadlock issues

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

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

Find out the latest recommendations for application performance coding

Understand the latest consideration and recommendations for efficient setup and maintenance of your new PBG 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.