Presentation details:

End to end Performance Monitoring – John Barnard (BMC)

Click Here for Presentation

Complex transaction flows within the z/OS operating environment oftentimes imply complex finger pointing exercises to resolve problems. The MAINVIEW Transaction Analyzer (MTA) product can help reduce the time for Problem Isolation and Route Cause Analysis. This presentation will describe the MTA product and how it can help provide an effective tool to resolve application problems.

John Barnard is the Development Director responsible for several MAINVIEW products, including MAINVIEW Transaction Analyzer. He has more than 20 years experience in systems software development, including the areas of z/OS, CICS. John was a primary developer and development lead for CICSPlex System Manager (CPSM) for IBM and has lately helped architect and design the MAINVIEW Transaction Analyzer product.

Performance Experiences with Two DB2 Data Sharing Architectures – Phil Czachorowski (CSC)

Click Here for Presentation

This talk will describe two application systems that demonstrate the trade-offs of designing a database to minimize the degree of DB2 data sharing or designing to maximize high availability. Data sharing can be minimized by routing transactions by data content so as to keep a strong data/process affinity. Designs that maximize high availability typically require a high degree of data sharing. Both applications use CICS as the transaction manager and process high transaction rates. The talk will include a description of each database architecture, a definition of key DB2 performance metrics, performance results and lessons learned.

Philip Czachorowski has extensive experience in relational technology and has worked with DB2 since 1983, with Release 1. He is the Director of the CSC Systems Performance Center, which executes performance benchmarks and conducts performance studies. The center has executed benchmarks on a range of DBMS products. Phil has worked with clients on large scale database designs and on database performance issues, covering all of the major DBMS products. Most recently he has completed a study of MySQL and has been working on a large scale DB2 data sharing system. He is the founder of the N.E. DB2 Users Group.

Managing DB2 performance with Quest Central for DB2 – Jim Wankowski (Quest)

Click Here for Presentation

Obtaining optimal performance from your DB2 applications is a multi-faceted exercise. DB2 performance optimization cannot be limited to simply tuning SQL. You need to have an understanding of how factors such as memory, physical design, SQL, and maintenance can affect performance. This presentation will show you how to use Quest Central for DB2 to identify and resolve the most common areas of performance bottlenecks in DB2 running on Unix, Windows and z/OS. This presentation will compare/contrast the differences in memory architecture, physical design, maintenance, and SQL tuning techniques for applications running in z/OS vs. LUW.

Jim Wankowski has over 20 years of development and DBA experience with DB2. Jim spent 6 years as a DB2 DBA, 9 years as a DB2 product specialist with Platinum technology and is currently the DB2 Technology Specialist for Quest Software. Jim is a well known speaker and has presented at many IDUGs, regional DB2 users groups and vendor seminars around the world.

---