Db2 Batch processing has long been considered a mainframe only domain. Many enterprise domain applications require bulk processing of large volumes of data for critical environments. But,what if we could offload some of the batch process handling of mainframe jobs to Linux servers using Java?
I spend every day of my life since 1990 as a Db2 DBA both on Db2 for z/OS and Db2 for LUW. During that time, I’ve collected a lot of knowledge that makes my job easier and gets easier and gets the answers to the developer’s questions in a timely fashion.
There are tremendously powerful programming possibilities with SQL and many of these features are translatable across RDBMS’s with only a modest amount of effort. Utilizing these advanced SQL features can drastically reduce development time and improve performance, and so let's explore them!
I searched for the manual which would explain how to write proper SQL. I never found it and the more I talked to people on which strategy I should follow, the less useful information I seemed to get. The same was true whenever I asked for general rules to decide which index was needed.
Customers have a wealth of data in their databases and publishing it to different devices is often fraught with many challenges. OData tries to remove much of the complexity of communicating with the database