Articles & Content


Database Performance Discoveries and Recommendations (F01)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

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


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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.