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.
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
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
- Best and worst performing tablespaces
- Tablespaces that are nearly full or least filled
- Integrates UNIX File System Monitoring
- Provides extensive alert capability for both tablespaces and file
- Email notification of tablespaces or file systems becoming full.
- Run one or more scripts when a tablespace or file system triggers
- Run a DB2 command to automatically extend a DMS tablespace to
- 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
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.
DB2 UDB versions 6.1, 7.x, and 8.1 for both Enterprise Edition (EE) and
Extended Enterprise Edition (EEE).
DB2 UDB Enterprise
DB2 UDB Extended
(64-bit) coming soon!
- DB2 UDB per platforms listed
- Operating system per platforms listed
- A web browser capable of displaying HTML 3.2 documents
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
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.