In large scale organizations, it is often necessary to move data from Db2 Production subsystems to Test subsystems. Of the various technologies that are available to achieve this business objective, circumstances determine which is most appropriate.
There are several enhancements to Utilities in DB2 12 for z/OS, including, but not limited to:
New UNLOAD Privilege
New catalog field COMPRESSRATIO
New REORG option to control the deletion of empty PBG partitions
REORG on partitions can overflow to newly created PBG partition
LOAD RESUME YES an
Today we will discuss how LOAD and UNLOAD utilities and file reference variables can help you to overcome inefficiencies in XML document maintenance with standard SQL statements.