Flight Deck

Palm-GUY

EEE-GUY

SQL-GUY

Connection-MINER

Pool-GUY

Space-GUY

Wise-GUY


Top Reasons
for Database-Guys Tools


"By using SQL-GUY, we can rapidly and effectively detect resource intensive SQL statements that slow down our business, usually before they go into production. This tool is essential and easy to handle. Every DB2 UDB user should have it."

Jan Ullmark
Chief DBA
RFV Data Sweden

Product Overviews


Flight Deck

The best way to take full advantage of our Full Crew, Flight Deck adds functionality to all Database-Guys tools while giving you autopilot performance analysis and self-tuning capabilities. The graphical user interface shows your database performance at a glance, so you'll be heading toward breakthrough results at mach speed.

Download product sheet (PDF) here.


Palm-GUY

Now you can really get a grip on your DB2 UDB - anytime, anywhere! With Palm-GUY™ as part of your crew, you'll have the power to monitor and control your databases from anywhere. It's the ultimate in wireless convenience for DBAs who are always flying multiple missions.

Download product sheet (PDF) here.


EEE-GUY

EEE-GUY™ provides performance data for all databases running on all nodes at one time. See the most recent performance data for each node at a glance, as well as detailed web-based performance reports. EEE-GUY also monitors db2diag.log files and can send alerts based on whatever criteria you define. In our flight plan, EEE-GUY means Enterprise Examination & Enrichment.

Download product sheet (PDF) here.


SQL-GUY

SQL-GUY tracks resource usages at the SQL statement level. It shows the ranked distribution of resources consumed by each statement as well as the number of times a statement was executed. This allows proper identification of statements that require tuning action. By identifying and fixing the most costly statements in a given application mix, some users of this tool have reduced overall CPU usage by 50% or more thereby dramatically improving transaction throughput rates for otherwise CPU bound applications.

Additional Features

  • Forecasts when DSS SQL Queries will complete
  • Quickly finds hidden costs in suboptimal application SQL
  • Rapidly analyzes and cost ranks all current connections
  • Identifies and expedites lock analysis
  • Finds run-away queries quickly
  • Interfaces to Index Advisor
  • Integrates with DB2 Explain Facilities
  • Integrates the Automatic Summary Table Analysis
  • Helps identify which users are accessing which columns and tables
  • Helps identify which columns are, and are not, being accessed
  • Helps identify which indexes are, and are not, being used

Download product sheet (PDF) here.


Wise-GUY

Wise-GUY integrates and provides operating system, DB2 database manager, DB2 database, and DB2 table activity information for tuning at these levels. It enhances the performance information in DB2 by retaining historical information and running in both interactive and unattended modes. It also integrates DB2 information with system information to provide a more complete picture of system activity. Alert capabilities are provided so that when critical events occur, the DBA can be automatically notified.

Download product sheet (PDF) here.


Space-GUY

Space-GUY helps manage disk space by checking the space allocated to each table space (file), the amount of space used, and the performance characteristics of each table space. The performance information includes average read and write times, physical I/O rates, asynchronous and synchronous read and write percentages, bufferpool hit ratios, and the predicted date when the table space may become full. The ability to identify the worst performing tablespaces is critical to being able to improve overall database performance. Alert capability is provided for both DB2 tablespaces and UNIX file systems, so the DBA can be contacted and corrective action taken before application availability is impaired.

Download product sheet (PDF) here.


Connection-MINER

Every DB2 user and task requires a connection to use DB2 resources. Connection-MINER provides valuable statistical information to help identify users that are having problems or are using high amounts of resources. This allows tuning efforts to be focused on these "heavy hitters." Trend information provided helps to ascertain resource utilization trends by weekday, hour of the day, week, month, and more. Connection-MINER provides the only commercially available accurate means of performing usage charge-backs. This tool is a virtual treasure chest of performance data.

Download product sheet (PDF) here.


Pool-GUY

The proper allocation of memory to bufferpools allows DB2 to avoid a high percentage of reads and writes to disk. The avoidance of I/O reduces wait time and the contention to disk. Pool-GUY monitors key bufferpool measurement data to provide information on how to optimize bufferpool performance. The heuristic tuning algorithms employed by Pool-GUY are the subject of a pending US patent.

Download product sheet (PDF) here.


Last Updated: Fri, 06 Jun 2003 14:52:24 EDT

Home | Contact Us | Support | Top 10 Tips | Customer Feedback | Careers | Downloads
Live! Monitor Our Database!   |   Live! Monitor Our Tables!
White Papers and Other Resources


Copyright © 2003 Database-Guys. All rights reserved. Privacy and Legal details.