Mainframe software directory - DBA

Return to software directory index

DBA Software

ADAREORG
Company:
Treehouse Software
A utility for reorganizing and restructuring ADABAS files. ADAREORG allows DBAs to respond to changing requirements by inserting and deleting fields, normalizing PEs and MUs, etc. It assists in tuning efforts by helping reorganize files. For example, by moving the most frequently accessed fields to the start of the physical record, ADABAS field decompression overhead is minimized.

AUDITRE
Company:
Treehouse Software
A generalized auditing facility that uses the ADABAS Protection Log to identify changes to ADABAS data. Extensive reporting and selection criteria are provided.

BatchControl for DB2
Company:
Software Engineering GMBH
Regardless how much effort is spent to produce the most perfect DB2 utility jobs and SQL batch programs, even carefully written jobs fail due to unforeseen problems. Now there is a way to replace time consuming and error prone processes with productivity tools for EDP automation. BatchControl products are unique DB2 tools that govern the DB2 batch window:BatchControl for DB2/Utilities - Controls the execution of DB2 utilities and commands. BatchControl for DB2/SQL - Controls the execution of SQL batch programs.

BCV5
Company:
Enterprise Systems Associates
BCV5™ Fast cloning of DB2 databases or even parts of DB2 databases. Compared to slower "usual" DB2 utilities, BCV5 is the choice when speed and minimal disruption are of key importance. Save an average of 90 percent in CPU and wall clock time for your DB2 copy or migrate jobs.

BPA4DB2
Company:
Enterprise Systems Associates
BPA4DB2 supports DB2 Administrators by analyzing the I/O behavior of DB2 subsystems and DB2 groups. This Buffer Pool Analyzer generates proposals to improve the setup of the pools. BPA4DB2 consists of two parts, a host component which measures the I/O rates and a JAVA client which receives the compressed measurements from the host. Increased system performance and resource cost savings make this a must have tool in z/OS shops. DB2 verison 8 upgrade and sizing support too.

Buffer Pool Optimizer
Company:
Responsive Systems
Buffer Pool Optimizer™ provides the complete configuration and sizes for your buffer pools, and properly group your objects into the required number of pools, to optimize your performance based on the amount of memory you can allocate for DB2 buffer Pools. It removes the analysis time and effort from your pool tuning activities, and allows you to focus on other areas that may provide additional performance benefits. The Buffer Pool Tool® is a pre-requisite for Buffer Pool Optimizer.

Buffer Pool Tool for DB2
Company:
Responsive Systems
Buffer Pool Tool is the proven and accepted industry standard software for tuning DB2 for z/OS buffer pools. As the only product that can predict the effect of sizing and threshold changes, or moving objects into different or totally new pools - it remains the only way to remove the guesswork from pool tuning and guarantee that tuning changes will provide performance gains. Attempting to tune without being able to predict is merely guessing about the outcome - and pool size increases don't always, or necessarily, provide a performance improvement. Since the most important performance metric is the I/O rate/second, Buffer Pool Tool predicts this, predicts the System Hit Ratio, and predicts the working set sizes of all objects at different pool sizes, and/or in different pools.

CA Fast Unload for Distributed Databases
Company:
CA
Fast Data Unloading across multiple formats

ConditionalBind for DB2
Company:
Software Engineering GMBH
ConditionalBind stops unnecessary binds by determining whether a DBRM contains changed SQL and skipping the bind step for those that do not.

Coupling Facility Sizing Module
Company:
Responsive Systems
Sizes the CF structures based on statistical data from your 'operating' DB2 system(s). This an included component of, and requires, the Buffer Pool Tool.

Database Administration for DB2
Company:
BMC
The Database Administration Solution for DB2 is one of BMC Software's SmartDBA Solutions that provides a set of integrated tools to help companies manage the most complex DB2 Universal Database for z/OS and OS/ 390 environments.

Database Administration for DB2
Company:
BMC
Allows you to manage day-to-day administrative tasks more quickly, easily, and cost-effectively. This product can help you reduce the time required to perform changes and migrations, vastly improving DBA productivity.

DB2 Thread Management
Company:
Relational Architects International
Thread/STOPPER deals with the inevitable DB2 "problem" threads that arise from operational mistakes, network failures, application errors and runaway queries. These problematic DB2 threads can consume considerable system resources, create serious contention problems and impair the performance and availability of critical systems and data. Thread/ STOPPER lets authorized users cancel such threads gracefully -- before they impact your system and disrupt large numbers of users. It can also clear the way for critical applications and utilities to run without contention.

DBA-Xpert
Company:
Compuware
With DBA-XPERT for DB2, you can perform DB2 catalog queries and analysis.Perform DB2 object modifications and migration. Multi-task in multiple active windows. Access subsystems simultaneously access any object in any subsystem and activate any function in a single session, no need to change tools. Perform multiple actions on an object within the same window

DCC-COMPACT
Company:
TONE Software
DCC-COMPACT™ provides optimum DB2 data compression without sacrificing CPU performance or limiting data compression options. DCC-COMPACT saves an average of 50% to 80% of DASD space required by each DB2 table while reducing the CPU utilization associated with DB2 compression processing.

ImpactExpert for DB2
Company:
Software Engineering GMBH
Impact Expert automatically determines the performance impact of BINDs and REBINDs on packages in advance.

Maintain for DB2
Company:
Software Engineering GMBH
Maintain for DB2 z/OS will distinguish your company from the rest with its state-of-the-art solutions for providing the best automatic database maintenance possible. Your customers and internal users drive the need for better services for your business processes. Not only does this require an extension of online service times, e.g., from 6 a.m. to 10 p.m., but may also mean around-the-clock operations 24 hours a day 7 days a week. As a consequence, getting your database maintenance completed in a smaller batch window, or even parallel to online operations, is more important than ever.

PackageManager for DB2
Company:
Software Engineering GMBH
PackageManager examines consistency of load modules and/or DBRMs and packages of the DB2 catalog to determine unnecessary packages.

PiT Recovery for DB2
Company:
Software Engineering GMBH
A PIT recovery is always needed when unwanted and irreversible SQL updates are made to the DB2 database, e.g., a program error or a flawed operational procedure such as running a batch application twice or using bad input. Subsequent SQL update processing makes the situation even worse because it may result in additional erroneous data. In a situation like this, pinpointing the corrupted table spaces and indexes is especially difficult with ERP and CRM because the referential constraints (RI) are ruled by the application, instead of using the physical RI feature of the DB2 database. Therefore, a DBA cannot be certain that all data tables are logically consistent with each other when recovering just a subset of the ERP and CRM tables. The alternative solution is a recovery of all table spaces and indexes of an ERP or CRM system to a prior point. With tens of thousands of objects, this implies a very disruptive outage for several hours and makes this scenario impractical. Because the need for a point in time recovery is never entirely eliminated, SOFTWARE ENGINEERING was encouraged to develop a software solution that addresses and solves the problems with a PIT recovery for black box DB2 applications.

RealTime DBAExpert for DB2 z/OS
Company:
Software Engineering GMBH
RealTime DBAExpert is a comprehensive DB2 database administration tool kit that you can use to automate maintenance and manage databases in batch and in real-time. RealTime DBAExpert also controls the execution of DB2 utilities, DB2 commands, SQL batch programs, and efficiently manages space.

RealTimeMaintain for DB2
Company:
Software Engineering GMBH
RealTimeMaintain uses an unprecedented exploitation of real-time statistics (RTS), combined with IFCID technology and using online utilities to enable dynamic maintenance during online operations. Additionally, RealTimeMaintain works together with all classical maintenance solutions offered by 3rd party vendors.

Recovery HealthCheck for DB2
Company:
Software Engineering GMBH
Recovery HealthCheck is an automated solution to perform periodic (e.g. daily) health checks of data availability and recoverability, as well as provide actual recovery times required for a DB2 object, a complete application, or even a whole DB2 subsystem. Join in to find out how you can insure that your actual recoverability times (RTO's) fit to your SLAs.

Recovery Management for DB2
Company:
BMC
Provides automation and advisory-level features that facilitate transaction-level recovery on a high-speed, managed basis. Online transaction recovery gives you greater control over the recovery process, improving data availability and reducing recovery risk without taking your database offline.

SmartDBA Database Performance for DB2
Company:
BMC
Identifies the objects that are most active and in need of reorganization, and then creates and schedules reorganization jobs for those objects. It cost-effectively maximizes the performance of systems, databases, and applications to enable your DB2 resources to meet or exceed customer SLAs.

SmartDBA System Administration for IMS
Company:
BMC
Enables customers to have availability and relieve the tasks of day-to-day operations of IMS in a common interface, and includes DELTA PLUS VIRTUAL TERMINAL, EXTENDED TERMINAL ASSIST PLUS (ETA), Energizer® for IMS Connect, Message Advisor for IMS.

SpaceManager for DB2
Company:
Software Engineering GMBH
Keeping DB2 objects such as table spaces and indexes in a proper state is well-known to be one of the important influential factors for good performance of application systems. Activities in this field are, among others, the reduction of extents and an appropriate sizing of primary and secondary space allocations. However, in practice it is difficult to collect all necessary information because it is wide-spread over the ICF catalog and several DB2 catalog tables. Additionally, formulas for space evaluation described in the DB2 literature can be quite intricate. Hence, there is the need for SpaceManager; an easy to use, comprehensive space information system with flexible related functions that allow an automated, threshold-driven space adjustment.

TurnOver PDQ® for i5/OS
Company:
UNICOM Systems
TurnOver PDQ, a unique database change product that Promotes Data Quickly and eliminates the pain inherent in data file upgrades and reorganizations. Using advanced high availability and change management techniques, TurnOver PDQ allows your users to maintain read/write access to databases while upgrades are taking place. Only during the final minutes of the conversion do users have to exit from the application.

Return to software directory index