    
|
|
|
DB2 BATCH HEALTH CARE SOLUTION
Home > Solutions Overview > DB2 Batch Health Check Solution
SoftBase Batch Analyzer allows companies to quickly diagnose and treat a wide variety of health problems that eat up excessive CPU cycles and contribute to production job failures and expensive CPU upgrades.
In the event production DB2 jobs do fail, SoftBase Checkpoint Restart will allow you to restart and complete these jobs as quickly as possible.
1. Nightly Batch Jobs:
| Large companies have hundreds or even thousands of jobs that need to execute every night. These long running programs often cause batch windows to shrink or even disappear. | |
2. Production Databases:
| DB2 production databases are steadily growing in size over time. The more DB2 data that needs to be processed each evening, the longer the required nightly batch jobs take to complete. | |
|
 |
 |
 |
 |
 |
 |
 |
  
|
3. Batch Programs:
| Many companies lack the ability to determine why their batch DB2 jobs are running longer. They are unable to find the key SQL statements that are extending their batch window and where they are encountering contention problems. | |
4. SoftBase Batch Analyzer:
| Batch Analyzer captures key performance data each time batch programs attach to DB2. The overhead to collect this performance data is less than 1% overhead per DB2 job. | |
5. SoftBase Checkpoint/Restart:
| When large DB2 batch jobs fail, the best remedy is to restart the application at the point of failure - not to wait for long, time-consuming DB2 Rollbacks and to then rerun the program from the beginning. Batch Analyzer locates dangerous batch jobs that will cause costly Rollbacks and allows you to complete any batch jobs that fail fast!. | |
6. Health Check Reports:
| Batch Analyzer provides many valuable reports on SQL performance, contention problems (-911s & -913s), and many other DB2 batch health problems. Also, our Batch Analyzer Contention Manager and Checkpoint/Restart solution allows you to ensure if a DB2 batch job fails, you can get it completed just as quickly as possible. | |
About | Solutions | Products | News | Partners | Support | Contact
Downloads | Customer Login | Site Map
|
|
|
   "Checkpoint Restart's ability to work with IMS, DB2 and other systems in various combinations was another key factor in our decision to use SoftBase’s solution. With complicated processes where data needs to be synchronized from disparate sources, it’s even more important to use a product like Checkpoint Restart. Even a simple batch process will take hours to complete, and a premature abend would severely impact operations. A full application restart would take hours."
- Denis Dubeau, DBA and Systems Consultant, State Government
|
|
|
