1 to 2 of 2
Sort by

Blog Entry
A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas

Steve Thomas of CA Technologies presents a great introduction into the world of locks, latches, claims and drains. A must see for all developers working wit Db2 for z/OS as well as all DBAs wanting to refresh their knowledge. This session will provide an introduction to how data integrity is...

Steve Thomas's profile image

Library Entry
db2perf_wait.db2 - show DB2 LUW wait time percentage breakdown

The Time Spent hierarchy in DB2 LUW is a great way to understand where your system is busy or where it's waiting, and more metrics are added to it on a regular basis. This script captures the entire DB2 10.5 wait time hierarchy, showing by % where time is spent. It uses delta...

Steve Rees's profile image