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.
I want to be able to set things up so that my end-users can monitor and cancel their own queries without having to come to me. Is there a way I can do this?
A singleton SELECT - is this always the best solution for readability and performance? The article discusses a simple scenario, that shows that a singleton SELECT can result in surprising application behavior if not used properly.