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...
The script Drive RunstatScript.cmd will control the execution of the ps1 members, the parameter labelled "ameddev" is my database name, so replace that with your database name. Also this script is the member scheduled in MS Windows Scheduler. The script RunstatScriptbld.ps1 will generate...
3 attachments
Introduction Each new release of DB2 brings changes to the utilities suite, and new release DB2 11 is no exception. The importance of these changes can have a big impact on the work of a DBA. The changes and new options should be well understood and choices have to be made for your...
DB2 11 for z/OS again raises the bar in key areas for high-end packaged applications like SAP. Besides performance boosts for various workloads, it optimizes the network latency for remote applications that run on AIX, Linux or Windows. Together with DB2 Connect 10.5, it provides a whole new set...
EU13A12.pdf
Automation tools have been used to collect detailed statistics to accurately generate the needed housekeeping procedures for space administration, reorganization among other tasks. Most customers have an increasing number of objects – and these are increasing in size too, so how do you still...
EU13A17.pdf
This presentation looks at the performance impact of DB2 z/OS V9, especially performance scalability of transactions, CPU and elapsed time of queries and utilities, and other performance-related topics.
EU07A15.flv