Db2 Tablespace Monitor

by Jul 28, 2007

This monitor allows you to monitor all of the tablespaces for your DB2 instance. The monitor collects the stats for all of the tablespaces defined on the DB2 instance.

1) Uncompress the contents of db2tablespace.zip into your uptime4/scripts directory
2) Load the db2TablespaceManifest-.xml file that is appropriate for your monitoring station
run: erdcloader -x scripts/db2TablespaceManifest.-.xml

3) If you are running on a Unix monitoring station you may have to `chown uptime db2*` and `chmod 744 db2*` to set the proper file permissions.

This monitor provides the following stats:

TBSP_USED_SIZE_KB
TBSP_FREE_SIZE_KB
TBSP_UTILIZATION_PERCENT
TBSP_USED_PAGES
TBSP_FREE_PAGES

Details on these metrics can be found at :

http://publib.boulder.ibm.com/infocenter/d…oc/r0022022.htm