Data is ever increasing. How are you handling data now and how will you prepare the future? There are distinct considerations when looking to meet performance, project, and compliance objectives.
Transparent Archiving, which was a new feature in Db2 z/OS version 11, allows for the segregation of da
”. Overthinking and trying to predict Db2 performance is a slippery slope, and so rather than “thinking” about Db2 performance why not have the database tell you how it will perform. The key to this is the Db2 accounting trace, and subsequent Db2 accounting reports. The accounting reports are useful
In this article, Peter Vanroose shares his story on porting a COBOL application to Db2 Stored Procedures, including his approach and lessons learned in the process.
Db2 stored procedures by themselves have the benefit of improving programming productivity. What if you combine that with the power of Zowe CLI?
Playing with cardinality and selectivity on predicates is not a common trick, though Joe Geller, David Simpson and Tony Andrews demystify it so that you can start playing with its intricacies and give a boost to the Optimizer.