Matthias Tschaffler
  • Stuttgart, BW
  • Germany
Share

Gifts Received

Gift

Matthias Tschaffler has not received any gifts yet

Give a Gift

 

Matthias Tschaffler's Page

Profile Information

Why join "The World of DB2"?
Looking for news blogs and podcasts
What information or education would be useful to you?
Performance and Tuning - SQL
Are you a member of IDUG (International DB2 User Group)?
No
Are you a member of a Regional User Group (RUG)? If so, which one?
NO
What best describes your job role?
IBM Employee / Business Partner
Country
Germany

Matthias Tschaffler's Blog

How to extend performance advantages of static SQL statements to dynamic SQL to improve availability and reduce costs - Part 2

Posted on April 3, 2017 at 7:02am 0 Comments

Overview

This is the second of a two-part series covering Dynamic Plan Stability (DPS) in DB2 12 and how IBM OMEGAMON XE for DB2 Performance Expert/Monitor can help you take advantage of it in both batch and online/real-time monitoring.  Part 2 focuses on real-time monitoring.

Real-time Monitoring (VTAM® Classic Interface)

The VTAM Classic interface offers in-depth monitoring for running threads, system statistics including statement caches, system…

Continue

How to extend performance advantages of static SQL statements to dynamic SQL to improve availability and reduce costs – Part 1

Posted on March 27, 2017 at 8:20pm 0 Comments

Overview

 

Dynamic SQL queries and workloads are more susceptible to performance degradation for various reasons. DB2 12 for z/OS introduced dynamic plan stability (DPS) to extend stable, predictable performance behavior for repeating dynamic query workloads. This two-part blog explains DPS in DB2 12 and how IBM OMEGAMON XE for DB2 Performance Expert/Monitor can help you take advantage of the feature in both batch and online monitoring. Part 1 focuses on batch…

Continue

Comment Wall

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

  • No comments yet!

WordPress

 
 
 

Bringing DB2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]

© 2017   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service