I saw from the db2top utility that the agent id 0 was holding locks on
other apps. So I took this following snapshot. I am totally confused
as to what agent this is, since querying the snapagent doesnt tell me
what this is.
Please shed some light if someone else has experienced similar stuff.
Does this have to concern with utilities such as runstats and loads???

arun@test01:~> db2 "SELECT agent_id,
agent_id_holding_lk ,lock_mode_requested, lock_mode, Lock_object_type,
trim(tabschema),tabname, lock_current_mode,
lock_release_flags,data_partition_id,dbpartitionnu m from
sysibmadm.snaplockwait"

AGENT_ID AGENT_ID_HOLDING_LK LOCK_MODE_REQUESTED
LOCK_MODE LOCK_OBJECT_TYPE
6
TABNAME
LOCK_CURRENT_MODE LOCK_RELEASE_FLAGS DATA_PARTITION_ID
DBPARTITIONNUM
-------------------- -------------------- -------------------
---------- ------------------
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
----------------- -------------------- -----------------
--------------
47138 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12
8289 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12
6532 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12
46913 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12
7800 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12
47142 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12
6529 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12
57436 0 NS
X ROW_LOCK
FUS
ART
- 1 0
12

8 record(s) selected.



Thanks
Arun

Try get snapshot on apps.
and list applications