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.
Looking for a different way to move data between two databases - check out this article on using LOAD FROM CURSOR with a named pipe.
DB2 for LUW has undergone a lot of changes to become more “cloud friendly”. This article focuses on new DB2 11.1 features that enable direct use of Amazon S3 cloud storage, and offers considerations about security and cost when integrating some aspects your database with the cloud.
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.