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.