BCV6 Company: UBS Hainer Avoid DB2 recovery downtime, shift Image Copies forward, prepare for fast recovery in background. BCV5`s fast copying utility COOCOPY saves 90% of CPU and SRU time. Identical copies of production databases for test or development environments are available within minutes. BCV5 Company: UBS Hainer Quickly copy DB2 Databases. You can work with volumes created by ESS FlashCopy, RVA SnapShot, EMC Timefinder, HDS ShadowImage, Softek TDMF, Fujitsu Equivalent Copy, or simply with native ADRDSSU. How you create the volume copies is unimportant.

BCV4 does everything necessary to set up a working DB2 system after the volumes have been copied. BCV4 Company: UBS Hainer Start your DB2 System Clone within minutes. By allowing you to quickly find and fix expensive SQL statements and to execute DB2 batch jobs in parallel, Batch Analyzer enables you to complete your nightly production work in a fraction of the time. Batch Analyzer diagnoses your batch job stream health problems by locating costly SQL statements and finding and eliminating time-consuming contention problems between DB2 programs. Batch Analyzer Company: SoftBase The Batch Health Care Solution from SoftBase provides a far more cost-effective and reliable solution to shorten your batch run times than purchasing expensive CPU upgrades.

APPTUNE for DB2 Company: BMC Alleviates problems caused by inefficient or run-away SQL statements. This allows concentration on the worst, i.e., highest resource consuming, SQL statements and avoids time spent analyzing SQL statements that have insignificant performance impact. As opposed to statement tuning that is addressed by the majority of the well known EXPLAIN tools - they analyze SQL statements on a stand-alone basis - application tuning additionally reflects the actual usage of application systems by monitoring them. Analyze+ for DB2 Company: Software Engineering GMBH To get the most out of automation, it is essential to perform application tuning instead of mere statement tuning. DB2 Software Analyze for STROBE Company: Software Engineering GMBH Analyze for STROBE automates the STROBE process to pinpoint relevant SQL statements for further analysis by an EXPLAIN tool, e.g., Analyze+.

Ca db2 tools manual