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.
Over the years, there has been a lot of evolution in DB2 for z/OS : packages, compression, datasharing, triggers, large objects, unicode support, memory management, PBG tablespaces …
DB2 helped DBA’s with the delivery of very nice features : RTS, bufferpool simulation, virtual indexes
This article starts a serial devoted to Db2 for z/OS System Profiles. Profiles are still not widely used and known while they represent a strong capability allowing to automatically tune the system. This introductory article discusses how you can define and activate a system profile.
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.
The purpose of this article is to provide a couple of ways you can work with Spark and Db2 for z/OS while having your Apache Spark installation (standalone or cluster) working outside of z/OS and at the same time enabling a feature of Db2 for z/OS most people are not aware of.