   
|
|
|
DB2 BATCH HEALTHCARE SOLUTION
Home > Solutions Overview > DB2 Batch Healthcare Solution
SoftBase's Batch Analyzer Facility 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's Checkpoint Facility 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. Batch Analyzer Facility:
| 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. Checkpoint Facility:
| 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 Status 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 Facility 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 Facility'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 Facility. 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
|
|
|
