Download Database.com - dbaTOOLS Analyzer

dbaTOOLS Analyzer

dbaTOOLS/Analyzer Version 9.0 for Unisys
ClearPath MCP and A Series Systems

32-bit Version (Windows 98, ME, NT, 2000 or XP)
Improved Reporting Support
Reports can be exported in PDF, EXCEL and HTML
Improved Graphing
Improved User Interface
Year 2000 Compliant
Better Exporting of data

dbaTOOLS/Analyzer is a software product for monitoring and tuning Unisys ClearPath MCP and A-Series systems - DMS II and LINC databases. Developed by Jim Stewart, an internationally recognized expert on ClearPath MCP and Client/Server technology, it is the replacement for DBAnalyzer, and it is the only product of its type implemented using client/server architecture. It consists of a collection module which runs on the ClearPath MCP system, and an analysis module that runs on a PC.

The collection module runs on a Unisys ClearPath MCP system, and collects data about DMSII databases. The user requests the type and amount of data to be collected and the time that it is to be collected, using a parameter file. The collection module also has the capability to keep databases opened, to start WFL jobs, to issue DMS II Visible DBS commands and to start DMS II Utility jobs. The collection module collects both statistical information and information about the physical structures in the database.

The analysis module runs on a PC under Microsoft Windows 95, 98, ME, NT or 2000, and is implemented using Microsofts Visual Basic. The analysis module loads the data collected on the ClearPath MCP system into a database for reporting and analysis. Because the data is stored in a database, both historical and current information can be analyzed and compared. Dataset population growth is calculated based upon the historical data and is used to project future limiterrors. The analysis module provides the following:

DMS II statistics analysis Dataset Average Wait Time
Dataset vs Set Finds
Physical vs Logical I/O
Reblock Analysis
General Database
StatisticsAudit Statistics

Population tracking and reporting Limiterror detection and reporting
Percentage of dataset used
Percentage of deleted records
Detailed Compact Dataset report
Detailed Variable Format Dataset report

Index sequential table level analysis Recommended Entries per Table
Garbage Collection Results

Index table loading
Index table Bias
Wasted Blockspace Analysis
Database disk segment usage reporting
On-line browsing of structure information
Set and Dataset Blocksize Calculator
Multiple Database Reports
Graphs and Much More

- Download dbaTOOLS Analyzer -