Locking and latching are both key mechanisms employed by relational database management systems to ensure data integrity, consistency, and the serialization of resources. In the Db2 for z/OS IRLM manages the locks, but both Db2 and IRLM have internal latches.
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.
Let's have some fun with date logic in our SQL statements.
There are a lot of practical SQLs for developer. We talk about pattern matching using regular expression, how to invoke external REST services using HTTPGETCLOB, and consuming the REST response in JSON and XML using the JSON or XML features in Db2 for z/OS.
XML and JSON support the storage of complex data structures. Standardizing your structures requires using a formal schema.