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.
Db2 introduced the MERGE statement in version 9 and made significant enhancements in Db2 12. This article shows you how.
The db2 logging process is an old strong process. You must take care of it because if all your active log data sets are not reusable because they are full, your db2 stops until it can offload them in archive logs. The performance of your recovery process is also strongly linked to your active log