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...
Some time ago I had a discussion with a DBA who guided the developers to use a singleton SELECT instead of fetching from a cursor in cases where just a single row would be selected. Singleton SELECT is a select statement that returns a single row at most. Even though I did not know any further...