?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.

?? ??? DB2 UDB - LUW?? ???? ???? Tool? Activity Monitor?
??? Lock ??? ???? ??? ????? ?????. ??? XpertMon
for DB2?? Activity Monitor? ?? Lock ??? ?? ??? ???? ??
??? ?????.

---

DB2 UDB for LUW 8.2 - how to detect locking using the Activity Monitor

DBA? “? ????? ?? ??? ??? ? ? ??? ?????.” ?? ???
?? ???. ?? DBA? ?? ??? ?? ????
DB2 UDB for LUW ?? 8.2(8.1.7)??? ?? ??? Performance Expert? ??
??? tool? ?? ???? ???? ???? ?? Activity Monitor? ?? ??
? ? ????. Activity Monitor??? lock? ?? ??? ???? ??? ????
? ???? ?????.

Activity Monitor? ?? ??? ?? ??? Window ???? DB2 UDB 8.2.1 for LUW?
?? ? SAMPLE ??????? ???????. ?? SAMPLE ???????
database configuration? LOCKTIMEOUT ????? -1? ?????.

Activity Monitor? ???? ?? ?? ? ??
- Activity Monitor ??
- db2user1 ? db2user2 ?? ? ?? ???? ??
- GRANT ?? ??? ??? ?? ? ?? ????? db2admin.employee ????
UPDATE ??? ??
- db2user1? db2admin.employee ???? UPDATE?? ???? commit ?? ??
- db2user2? db2admin.employee ???? UPDATE?? ??
- Activity Monitor? ???? Lock? ?? ??

Activity Monitor ????
?? Activity Monitor? ?? ??? ????, ???? ???? db2am ??? ??
Activity Monitor? ???????.

Activity Monitor? ?? ????? ? SAMPLE ??????? ??? ? ????,
????? ??? ??? ?? 4??? ???? ???? ????.
- ?? ?????? ??? ?? ?? ??(Resolving a general database system slowdown)
- ??????? ?? ?? ??(Resolving the performance degradation of an application)
- ?????? ?? ?? ??(Resolving an application lock situation)
- ?? SQL? ?? ??(Tuning the dynamic SQL statement cache)

‘?????? ?? ?? ??(Resolving an application lock situation)’? ???? ??
??? ???? ‘Locking’ ??? ??? ??? ?? ? ???? ???? ???
??(Next)? ??, ???? ???? ?? ??(Specify the category of monitoring task)
??? ??? ??? ??/?? ??? ??? ?????? ??(Trouble shooting/Identify
one or more problem applications)? ???? ??? ??? ????, ??(Next), ??
??????(All applicaionts), Lock ??? ?? check box? ?? ?? ? ? ??(Next),
??(Next), ??(Next), ??(Finish)?? ?? Activity Monitor? ?? ??? ?? ? ????.

Activity Monitor ?? ?
Windwos? ????? ? ?? ???(db2user1, db2user2)? ????? db2admin.employee
???? ?? update ??? GRANT?? ?? ?????.
> db2 grant update on table db2admin.employee to db2user1
> db2 grant update on table db2admin.employee to db2user2

db2user1 ???? ?? ??? ?????.
> db2 connect to sample user db2user1 using db2user1
> db2 +c “update db2admin.employee set salary = salary + 1”
? ??? ??? ??? ?????? ?????.

db2user2 ???? ?? ??? ?????.
> db2 connect to sample user db2user2 using db2user2
> db2 +c “update db2admin.employee set salary = salary + 1”
? ??? ???? ?? ??? ??? ???.

db2admin ???? ?? ????? ???? Activity Monitor? ??? ?, ??(Next),
??? ?? ??? ‘Locking’? ???? ??(Finish)? ?? ? ?, ???(Report)?
‘?? ?? ?? ??? ???? ??????(Applications holding the largest number
of locks)’? ?????.

????ID? DB2USER2? ???? ??? ????, ???? ??? ??? ??,
?? ?? ??(Show lock chains)? ??? ? ???? ???? ?? ??? ???
?? ??????? ? ? ????.

Figure 1 : ?? ?? ?? ??
??(Legend) ??? ???? ?? ??? ???? ??? ?? ?? ??? ? ?
????.

XpertMon for DB2 ??? Activity Monitor ?? ??
DB2 UDB for LUW?? ???? ???? Activity Monitor? ??? ?? ?????.
?? ??? ???? XpertMon for DB2 ????? ??? ??? Activity Monitor
?? ?? ??? ? ????.
XpertMon for DB2 ?? ? Main ???? SESSION?? ???? ??, ??? ??
Activity Monitor? ???? ??? ?? ??? ???? ?? ??????? ??
??? ?? ? ????.

Figure 2 : XpertMon for DB2 ??? Lock? ?? ?? ????? ?? ?? ??


Figure 3 : XpertMon ??? ?? ?? ????? ?? ?? ?? ??

---

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