By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,286 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,286 IT Pros & Developers. It's quick & easy.

Ask for help about a problem of DB2 health monitor usage

P: 1
hi,all
As we known,DB2 Health Center is a very good tool,but it made me a little confusion. I will be very appreciate if anyone give me some advices.
The problem is that I want to monitor my tablespacle utilization,then I did some test work:
1.I create a tablespace "TESTDMS"managed by database,
db2=>CREATE REGULAR TABLESPACE TESTDMS PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE 'D:\test\test' 5120 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL IBMDEFAULTBP DROPPED TABLE RECOVERY ON;
2,I open the health center window and go to "Health Indicator Configuration Lanuchpad",then I chose "Global Settings",select instance,and set the "Tablespace Utilizaiont" warning threshold "80%" alarm threshold "90".
3.I create a table in the tablespace I created just before
db2=>CREATE TABLE TEST(ID NUM(10) , NAME VARCHAR(20)) IN TESTDMS
4,I write a little program to fill some data in this table,but I didn't see any alarm even util the tablepace utilizaion is 100%,below is what I got about the tablespace information:
db2=>select TBSP_ID,SUBSTR(TBSP_NAME,1,20) AS TBSP_NAME,TBSP_UTILIZATION_PERCENT FROM SYSIBMADM.TBSP_UTILIZATION

TBSP_ID TBSP_NAME TBSP_UTILIZATION_PERCENT
-------------------- -------------------- ------------------------
0 SYSCATSPACE 100.00
1 TEMPSPACE1 100.00
2 USERSPACE1 100.00
3 TEMPSPACE4 100.00
4 TEMPSPACE8 100.00
5 USERSPACE8 100.00
6 USERTEMP1 100.00
7 USERTEMP4 100.00
8 SYSTOOLSPACE 2.14
9 SYSTOOLSTMPSPACE 100.00
10 TESTSMS 100.00
11 TESTDMS 100.00
12 TESTDMSAUTO 67.42
13 TEST1 0.94

I don't know why health monitor didn't work.Anyone give me some help?
Thank you so much
Sep 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.