Recently, I upgraded a fairly large system from DB2 V8.2 to 9.7, with one of the greatest expected benefits being the reduction in storage usage because of the compression (storage optimisation) feature. This article describes how the new ADMIN_MOVE_TABLE() administrative stored procedure in DB2 9.7 made getting maximum benefit out of this feature easy.
The database had DMS tablespaces, but had been initially created prior to the introduction of automatic storage. DB2 9.7 allows an existing... Read More >>
IDUG Sponsored Whitepapers
Ten Steps for Archiving Data in IBM DB2 on Mainframe Systems
This Informatica whitepaper outlines the challenges of managing data growth in IBM DB2 on mainframe systems and the limitations of conventional solutions. Link to register: http://vip.informatica.com/?elqPURLPage=7761.