- 论坛徽章:
- 0
|
主要涉及DB2的process监控,tablespaces监控,bufferpool监控,sortheap监控,lock监控,active log监控,应用中的sql语句等等比较关键的监控;我这里有现成的监控脚本(UNIX下),有兴趣的话可以等价交换一下。
1、tablespace监控输出:
#ID Name Useable Used Free Free(KB) Per High_Water PS
#-------------------------------------------------------------------------------------
0 SYSCATSPACE 281856 100608 181248 724992 35.6 105504 4096
#1 PSAPTEMP2 1 1 SMS SMS SMS SMS 4096
2 ZSAPLARD 16222848 7658752 8564096 34256384 47.2 16221664 4096
3 PSAPBTABD 16384320 14494880 1889440 7557760 88.4 16383056 4096
4 PSAPBTABI 12974592 12963952 10640 42560 99.9 12963952 4096
5 PSAPCLUD 12716544 12704064 12480 49920 99.9 12704064 4096
6 PSAPCLUI 1791360 1767392 23968 95872 98.6 1767392 4096
7 PSAPDDICD 205824 183600 22224 88896 89.2 203312 4096
8 PSAPDDICI 83136 78384 4752 19008 94.2 80704 4096
9 PSAPDOCUD 16896 14560 2336 9344 86.1 14560 4096
10 PSAPDOCUI 13824 11488 2336 9344 83.1 11488 4096
11 ZSAPRESBD 16118400 14918720 1199680 4798720 92.5 15998144 4096
12 ZSAPRESBI 1721856 1594848 127008 508032 92.6 1711776 4096
13 ZSAPOTHD 13779840 13757696 22144 88576 99.8 13757696 4096
14 ZSAPOTHI 7579008 7562016 16992 67968 99.7 7562016 4096
15 PSAPLOADD 3072 960 2112 8448 31.2 960 4096
16 PSAPLOADI 3072 480 2592 10368 15.6 544 4096
17 PSAPPOOLD 852768 839136 13632 54528 98.4 839136 4096
18 PSAPPOOLI 577056 575840 1216 4864 99.7 575840 4096
19 PSAPPROTD 1244544 1242368 2176 8704 99.8 1242368 4096
20 PSAPPROTI 174720 172672 2048 8192 98.8 172672 4096
21 PSAPSOURCED 26112 23680 2432 9728 90.6 23680 4096
.....................................................................
#42 PSAPTEMP8K 1 1 SMS SMS SMS SMS 8192
43 ZSAPMSEG8KI 899968 382016 517952 4143616 42.4 382016 8192
44 ZSAPMSEG8KD 8099712 5953024 2146688 17173504 73.4 5953024 8192
报警:
Warning: Tablespace PSAPBTABI(4) will be FULL, 0 days left!!!
Warning: Tablespace PSAPCLUD(5) will be FULL, 1 days left!!!
Warning: Tablespace PSAPCLUI(6) will be FULL, 2 days left!!!
Warning: Tablespace PSAPDDICD(7) will be FULL, 13 days left!!!
Warning: Tablespace ZSAPRESBI(12) will be FULL, 4 days left!!!
Warning: Tablespace ZSAPOTHD(13) will be FULL, 7 days left!!!
Warning: Tablespace ZSAPOTHI(14) will be FULL, 1 days left!!!
Warning: Tablespace PSAPLOADD(15) will be FULL, 0 days left!!!
Warning: Tablespace PSAPSTABI(24) will be FULL, 1 days left!!!
Warning: Tablespace PSAPUSER1D(26) will be FULL, 3 days left!!!
Warning: Tablespace PSAPUSER1I(27) will be FULL, 7 days left!!!
Warning: Tablespace PSAPES46CD(29) will be FULL, 0 days left!!!
Warning: Tablespace PSAPEL46CI(32) will be FULL, 17 days left!!!
Warning: Tablespace ZSAPBKPFD(3 will be FULL, 3 days left!!!
active logs监控:
Warning: (DB will be LOG FULL,available size:6683 B left !!!Detail information is in db/snapshot/log/report/Sep1_18:29:34.
detail)
......................... |
|