The 2018 IDUG Db2 Tech Conference took place in St. Julians, Malta, November 4 – 8, where History & Present are combined. The conference offered 5 days of Db2 education and training, including new and emerging technologies.
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.