Buffer pool (DFT_MON_BUFPOOL) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = ON
>From the snapshot for DB, it said currently 421 locks, same forsnapshot of all Application.
But the snapshot for lock say different thing, only 18 locks.
Looks like DB snapshot and application snapsho is not accurate.
Anybody have tried to compare this 2 values?
$ db2 reset monitor all
DB20000I The RESET MONITOR command completed successfully.
$ db2 get snapshot for db on p1csdb | grep "Locks held "
Locks held currently = 421
$ db2 get snapshot for locks on p1csdb | grep "Locks held " | sort -r
Locks held = 9
Locks held = 5
Locks held = 4
Locks held = 0
Locks held = 0
Locks held = 0
Locks held = 0
Locks held = 0