Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
Why have agile development and DevOps techniques been adopted for software development over long-standing techniques like the waterfall approach? It all comes down to improved collaboration resulting in faster development and therefore a quicker return on investment.
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.