If you knew your
three worst performing
tablespaces,
you could substantially
improve performance
for the entire database.


"I tested these tools for a client and was able to recommend them unreservedly. Easy to install and use, immediate results and friendly, prompt and interested support."

Mark Nicholls
Consultant
Derneburg, Germany


Flight Deck

Palm-GUY

EEE-GUY

SQL-GUY

Connection-MINER

Pool-GUY

Space-GUY

Wise-GUY


Top Reasons
for Database-Guys Tools

Space-GUY™ 1.5

AIX READY!

Features  |   Platforms 
Software Requirements
Hardware Requirements
Vision  |   Tell Me More!

Features

Stop wading through pages and pages of detailed information about tablespace space allocation and performance, and stop worrying about running out of disk space.

Space-GUY crunches all the numbers and neatly summarizes all the relevant data for your review. While this is an amazing and useful feat, Space-GUY's best trick is its ability to predict the future. With Space-GUY's help, you can optionally discover on which date each DMS tablespace may fill up based on rates of utilization.

New!
For both DMS and SMS tablespaces, the average number of pages used per day is computed to help give you a clear picture of tablespace growth!

Space-GUY is EEE enabled, and New!   ready for DB2 version 8!

Using Space-GUY, you can quickly find out for each tablespace:

  • Allocated size of each tablespace in megabytes (MB)
  • Number of megabytes free
  • Percentage of space used and free
  • Average disk read and write response times
    • Overall average read milliseconds
    • Asynchronous average read milliseconds
    • Synchronous average read milliseconds
    • Overall average write milliseconds
    • Asynchronous average write milliseconds
    • Synchronous average write milliseconds
  • Number of database files closed
  • Bufferpool hit ratios
    • Overall bufferpool hit ratio
    • Index hit ratio
  • Asynchronous pages read per request
    • ... an important measure of prefetch effectiveness
  • Average number of physical pages read per minute
    • ... an important indicator of bufferpool tuning effectiveness
    • ... helps you identify most heavily read tablespaces for I/O balancing of containers
  • Synchronous vs. Asynchronous I/O activity
    • Percentage of Asynchronous Writes (High is good)
    • Percentage of Synchronous Writes
    • Percentage of Asynchronous Reads (Prefetch)
    • Percentage of Synchronous Reads (Random)
  • Total number of tablespace containers
    • ... and automatic tuning recommendation for MAXFILOP
  • Predicted date on which a DMS tablespace may become full
  • Average number of pages used per day

What's more, you can sort the display by any criteria, allowing you to discover:

  • Best and worst performing tablespaces
  • Tablespaces that are nearly full or least filled

Additionally, Space-GUY:

  • Integrates UNIX File System Monitoring
  • Provides extensive alert capability for both tablespaces and file systems
    • Email notification of tablespaces or file systems becoming full.
    • Run one or more scripts when a tablespace or file system triggers an alert
    • Run a DB2 command to automatically extend a DMS tablespace to avoid failures
  • Provides HTML reports that color code alerts and performance opportunities for improvement. See only the statistics you want to see!
  • Gives you the ability to create an HTML web page suitable for wireless device access anytime, anywhere
  • Optionally runs unattended, up to 24 hours a day, 7 days a week.
  • Saves all tablespace utilization data
  • Saves all tablespace performance data
  • Saves performance history to any database, local or remote
Architecture

Space-GUY digests the reams of output from 'list tablespaces show detail' and 'get snapshot for tablespaces on DBNAME' and computes the relevant figures for consolidated display. The appropriate figures are also stored in a tablespace statistics data-mart table. Ad hoc queries can be run against this table to ascertain trends, and the utilization statistics therein are the basis for the tablespace full date prediction.

Platforms Supported

Space-GUY supports DB2 UDB versions 6.1, 7.x, and 8.1 for both Enterprise Edition (EE) and Extended Enterprise Edition (EEE).

DB2 UDB Enterprise Edition

DB2 UDB Extended Enterprise Edition

Operating
System

Supported Versions

Remarks

AIX®

5.1 (32-bit)

4.3

5.1 (64-bit) coming soon!
Sun Solaris®

8

7

2.6

 
Linux® Intel

OS/390 coming soon!

HP-UX® HP-UX Inquire for details

Software Requirements

  • DB2 UDB per platforms listed
  • Operating system per platforms listed
  • A web browser capable of displaying HTML 3.2 documents

Hardware Requirements

Depending on tablespace history retention requirements, an additional 1-10MB or more of disk space should be reserved for tablespace data-mart data.

Vision for the Future

We would enjoy the opportunity to discuss our future plans and directions with you. Please complete our additional information request form.

  I Want More!

If you'd like more information on Space-GUY or any of Database-Guys's products, please complete our Tell Me More! form.

Last Updated: Mon, 03 Feb 2003 17:07:51 EST

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.