?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
??? ?? ???? Access ???? ???? ??? ??? ???? ??? ??
?????? ?????.
Checking whether a table is being accessed
????? ?? ??? ???? ?? ???? Access ???? ??? ? ????.
?? monitoring switch ? table event ? ??? ??? ?? ?????.
- db2 update dbm cfg using dft_mon_table on
XpertMon? CFG ??? ???? update ? ? ???, ????? ??? ? ????.
- Immediate value ? ON?? , db2stop/db2start ?? ?? ?????.
- ????? ???? ?? ??? ?? ????? ?????? ? ? ????,
?? ??? ??? ? ????.
Snapshot? ???? ?? ???? ???? ?? ??? ?????.
??? ?? snapshot_table() Function? ???? ?? ??? ?? ???
??? ??? ? ? ????.
- select substr(table_schema,1,20), substr(table_name,1,20), rows_read
from table(snapshot_table(‘sample’,-1))as s
order by rows_read desc
1 2 ROWS_READ
------------- ------------- ------------
DB2ADMIN EMPLOYEE 32
DB2ADMIN DEPARTMENT 8
XpertMon? Report ?? ? Object I/O ???? ???? ?? ???? ??
Access ??? ? ? ????.
- ?? ??? ?? Object I/O Report ? ??? ? ‘OK’ ??? ??
??? ??? ?????.
- ??? ??? ???? Object I/O Report ??? ??? ? ‘OK’ ??? ????.
???? ??? ?? ?? ?? ??? ???? ?????.
- Table I/O ? ???? Table ???? ?????. ??? ?????.
???? 4? 29? ????? ??? Report ? ?????? ?????.
- ???? Rows Read ? ?? ???? Rows Read ??? order by ? ?????.
??? ???? ??? ???? Sort? ? ???, ??? Result Count ??
??? ? ????.
- Rows Read ? Write ? Overflow Access, Page Reorg ??? ????.
Write ? Write Rows ?? ??? ???? ????, Overflow Access ?
Overflow? ?? Row? Access ? ??? ?????. overflow Row ? Row?
update?? ?? ???? ??? ? ?? ?? ???? ??? Row ? ????.
Variable ?? ??? update???, alter table ?? ?? ??? ? ????.
Page Reorg? New Row? insert????, ?? Row? update??? ??
?? ?? ???? R???? ????? ???? ??? ??? ????.
Overflow Access ? Page Reorg ? ??? ???? ???? Reorg? ????
?? ????. UDBESE.EMP? ?? Page Reorg? ?? ???????,
?? ???? Reorg?? Insert ? update ? ???? ??? ? ? ????.
XpertMon for DB2 UDB V2
DB ???
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail : hjlee@iteg.co.kr
URL : http://iteg.co.kr