SoftBase Systems, Inc.

DEPLOY DB2 APPLICATIONS WITHOUT SURPRISES

Home > SoftBase Application Deployment Solution Overview

BUSINESS CHALLENGES:

Application Developers and DBAs often live in fear of moving new DB2 projects or enhancements into production. Many performance problems pop up as new or changed SQL statements run far longer than expected. Online application response times slow dramatically and batch programs run far longer than their alloted time.

In addition, new or enhanced DB2 applications deployed into production have a strange way of not working quite properly as Application Developers and QA Personnel have been unable to run enough tests to throroughly test their DB2 programs.

BATCH ANALYZER: PREVENTING DB2 PRODUCTION PERFORMANCE SURPRISES

Batch Analyzer from SoftBase is a unique solution that allows Application Developers to locate potential performance problems that will occur when moving new or enhanced DB2 applications into production:

Batch Analyzer provides Developers with unique insight into which SQL statements within their test programs are using the majority of DB2 CPU and elapsed time
Batch Analyzer watches new DB2 production applications and immediately singles out SQL that is running longer than it should or used to
Batch Analyzer also locates DB2 batch programs that will ROLLBACK an excessively long time if they fail or abend
SoftBase Checkpoint Restart allows Application Developers to make appropiate DB2 programs restartable from near or at the point of failure

Click here to learn more about Batch Analyzer

TESTBASE: PREVENTING DB2 PRODUCTION APPLICATION SURPRISES

New DB2 production applications often do not work as intended. TestBase can quickly confirm that new DB2 applications are working properly and that Application Developers did not accidentally break existing functionality:

TestBase allows Application Developers to thoroughly test all code changes in their DB2 applications
TestBase ensures that Application Developers have accurate and realistic test data at all times
TestBase also provides powerful Regression Comparison Reports that verify no unexpected production data is altered or deleted

Solution Fact Sheet

Batch Analyzer
Slide Show

Live Web Demo

"Batch Analyzer helps our developers quickly identify any new or modified DB2 SQL statements which are going to cause big problems later when placed into production..."

Patty Pritchard
Health Plan Systems
Database Administrator