Search

1 to 7 of 7
Sort by

Blog Entry
Utility Enhancements in DB2 12 ESP for z/OS

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...

Cuneyt Goksu's profile image

Library Entry
DB2 LUW - (MS Windows) PowerShell Script for Generating and Executing Runstats

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

Lyn Maberry's profile image

Blog Entry
DB2 11 Utility Enhancements

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...

Kurt Struyf's profile image

Library Entry
[A12] DB2 11 for High-End Packaged Applications

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


Library Entry
[A17] Sleep tight while CA Database Analyzer works hard

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


Library Entry
DB2 z/OS V9 Performance

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


Library Entry
DB2 z/OS V9 Performance

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