The 2017 IDUG Db2 Tech Conference took place in Lisbon, Portugal October 1-5. This event drew 15% more attendees than the previous year from around the world to be immersed in 4 days of Db2 education and training.
I am a big fan of minimizing the calls to DB2 and run as few SQL as possible. That is one of the reason I like the MERGE statement although it is a bit limited in DB2 for z/OS. In this short blog I would like to mention another of my favorite SQL tricks - SELECT FROM data-change-table-reference.
In this article Saurabh Agrawal discuss a technique utilized to shorten the amount of time it takes to purge a large amount of data from a DB2 for LUW database. The article includes a very detailed description of the process along with some script examples.
This month’s third article is by John Maenpaa. John provides us with the overview of a real life project. The choice was between JSON, XML and traditional relation structure, in order to store complex forms. John talks about measurements and considerations. This article is a must read.
Join Judy Ruby-Brown has she gives a thorough overview of system level backup and using FlashCopy for disaster recovery as provided by various vendors. Judy explains the types of services that need to be setup for disaster recovery as well as easy implementation scenarios for the DBA.