SoftBase Systems, Inc.

BATCH ANALYZER

Home > Solutions > DB2 Batch Health Care > Batch Analyzer

BATCH ANALYZER:

Find Poorly Performing SQL and Batch Problems That Your Other Monitors Are Missing

Batch Analyzer is a powerful new solution that can quickly locate all your poorly performing DB2 for z/OS batch SQL in seconds. If you're tired of late night phone calls at 2:00 AM or wading through many DB2 performance tools and way too much data, consider letting Batch Analyzer find your bad batch SQL before it finds you:

Find Poorly Performing DB2 SQL Statements

Batch Analyzer can be installed and start gathering DB2 batch performance data in a few hours
Batch Analyzer locates every single bad batch SQL statement in seconds - without impacting DB2 application performance
Locates production SQL that has degraded in performance over time
Batch Analyzer identifies your worst SQL statements from yesterday, last week, or even last month
Developers can now locate their own performance problems
List the Top 10 bad SQL statements anywhere in production
Determine which batch Jobs are not DB2 performance problems

Locate DB2 Timeouts and Deadlocks
Batch Analyzer finds all DB2 batch jobs encountering deadlocks or timeouts in seconds Batch Analyzer also provides diagnostics on COMMIT frequency to help tune each DB2 batch program

Identify Excessively Long DB2 ROLLBACKs
Batch Analyzer identifies DB2 batch programs that might ROLLBACK for excessively long periods of time Batch Analyzer predicts how long each DB2 batch program will perform a ROLLBACK if it failed - estimates are based on amount of DB2 data alteration and COMMIT frequency

Product FAQs

Success Story

SBA Webcast Replay

Product Fact Sheet

Live Web Seminar

Product Support

"Batch Analyzer is a great, great product. It's just amazing how quickly Batch Analyzer can zero-in on SQL statements consuming most of our DB2 batch CPU cycles... �

Patty Pritchard
Senior DBA
Health Plan Services