In Part 1 of this blog we looked at the different ways to create or convert to Partition by Growth (PBG) table spaces. In this part we will review the advantages and disadvantages of PBGs, when it might be appropriate to use them, and making changes to existing PBGs.
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.