Software frees up DB2 objects held by errant applications.

Press Release Summary:



DB2 Thread Expert for z/OS® (5697-H85) enables users to cancel threads on DB2 objects that are needed by DB2 utilities or that are held by long-running applications, freeing up DB2 objects for higher priority uses. Product can be used to perform routine tasks such as canceling threads on DB2 table space before table space is reorganized or copied.




Original Press Release:




IBM DB2 and IMS Tools Expanded and Enhanced to Help you Better Manage Database Environments



At a glance
DB2 and IMS Tools are integrated with each other and with the databases they support to help you reduce the complexity of database operations. Some tools consolidate data and manage activities. Others analyze, monitor, and recommend actions, while still others take action.

New and enhanced DB2 and IMS tools deliver:

Application management
IMS Connect Extensions for z/OS, V1.2 (5655-K48)
Database administration
DB2 Thread Expert for z/OS (5697-H85)
Performance management
DB2 SQL Performance Analyzer for z/OS, V2.2 (5655-I22)
Recovery management
DB2 Log Analysis Tool for z/OS, V2.3 (5655-E56)
Utilities management
IMS Database Control Suite for z/OS, V3.2 (5655-L08)
IMS High Performance Fast Path Utilities for z/OS, V2.2 (5655-K94)

For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).

Overview
One new product, four new releases, a service update, and performance information for DB2® and IMS tools offer many innovative features to assist database administrators (DBAs) and system programmers in managing all aspects of DB2 and IMS database environments.

New product
DB2 Thread Expert for z/OS® (5697-H85) gives you the ability to cancel threads on DB2 objects that are needed by DB2 utilities or that are held by long-running or errant applications. This important function frees DB2 objects for more important or higher priority uses. The product can be used to perform a variety of routine tasks, such as canceling threads on a DB2 table space before the table space is reorganized or copied.

New releases

DB2 Log Analysis Tool for z/OS, V2.3 (5655-E56) provides a powerful tool to ensure high availability and complete control over data integrity. It allows you to monitor data changes by automatically building reports of changes that are made to database tables.

IMS Database Control Suite for z/OS, V3.2 (5655-L08) is designed for day-to-day management of your IBM IMS database environment. It automates time-consuming, manual maintenance tasks, while minimizing the occurrence of associated errors. This product enables you to perform IMS database management tasks without the need for in-depth knowledge about tasks.

IMS High Performance Fast Path Utilities for z/OS, V2.2 (5655-K94) includes all of the features available in IMS High Performance Fast Path Reorganization Tool, IMS Fast Path Basic Tools, and IMS Fast Path Online Tools.

IMS Connect Extensions for z/OS, V1.2 (5655-K48) enhances IMS Connect performance, availability, and security. IMS Connect Extensions for z/OS provides comprehensive event recording and performance monitoring, features dynamic workload management capabilities, and offers additional security facilities to IMS Connect.

Service update
PTF UK02548 is available for DB2 SQL Performance Analyzer for z/OS, V2.2 (5655-I22). It delivers new functions that provide an alternate view of the explain data and other enhancements.

Performance information
Refer to Software Announcement 204-297 , dated December 7, 2004, and Software Announcement 205-188 , dated August 23, 2005, for the latest information on DB2 and IMS performance-monitoring products from IBM:

Tivoli® OMEGAMON XE for DB2 Performance Expert on z/OS, V3
Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V3
Tivoli OMEGAMON XE for IMS on z/OS, V3

To view a complete list of the DB2 and IMS tools, visit http://www.ibm.com/software/data/db2imstools

Key prerequisites
Any hardware configuration that supports the required versions of DB2 and IMS.

Planned availability date
October 7, 2005

All Topics