ASG-TMON for DB2
for Complete Performance Management of DB2

ASG-TMON for DB2 in combination with the SQL Analyzer feature is the industry's only fully integrated DB2 performance management solution for z/OS that scales to meet the challenges of complex enterprise systems. TMON for DB2 and SQL Analyzer improve overall DB2 availability by proactively managing DB2 applications and critical DB2 resources. Together they provide the needed insight to solve complex SQL problems, resulting in optimized end-user response times and maximized DB2 performance.

Features at a Glance

• Provides a single view of DB2 data-sharing group performance
• Identifies performance slowdowns of active threads
• Tracks and evaluates the performance of all DB2 buffer pools
• Isolates the reporting within a DB2 data-sharing group
• Identifies and corrects all DB2 lock contention and serialized resource usage issues
• Tracks transaction statistics from ASG-TMON for CICS to TMON for DB2
• Provides transaction history and flow information for review
• Generates custom reports with batch report writer
• Enables the evaluation of the impact of SQL call performance for static and dynamic queries
• Provides graphical definitions and representations of DB2's contribution to overall CICS response time
• Identifies transactions consuming the most resources using a predefined "worst" performance report
• Generates user-defined, ad-hoc, repeatable online reports to track and analyze performance trends across systems and time frames
• Determines the exact text of dynamic and static SQL calls, including host variables
• Views all performance statistics by plan, package, and statement, including CPU time, I/O analysis, and lock activity buffer pool utilization by SQL statement
• Identifies SQL performance and logic problems when accessing DB2 databases, eliminating the need to review application source programs

Other ASG Products that Complement ASG-TMON for DB2

• ASG-NaviGraph for enterprise reporting of ASG-TMON trend data
• ASG-NaviPlex for z/OS enterprise performance management
• ASG-TMON for z/OS for management z/OS operating systems performance
• ASG-TMON for CICS TS for z/OS for management of CICS TS performance
• ASG-TMON for IMS for management of IMS performance
• ASG-TMON for WebSphere MQ and ASG-TMON WebSphere MQ Enterprise Edition for management of WebSphere MQ systems performance
• ASG-TMON for TCP/IP for management of TCP/IP network performance
• ASG-TMON for VTAM for management of VTAM performance
• ASG-TMON for Web Services for management of IBM z/OS UNIX System Services (USS), including WebSphere Application Server and HTTP Server

Did you find the information you were looking for?

Yes

No

Back