469,579 Members | 1,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Locks held from snapshot on db and on locks is totally different

I have db2 v8.2.5 on AIX V5.3 with all the switches on
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 for
snapshot 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

Sep 12 '06 #1
1 2668
It is a known bug, IY87012.
sh*******@gmail.com wrote:
I have db2 v8.2.5 on AIX V5.3 with all the switches on
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 for
snapshot 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
Sep 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by aswinee | last post: by
11 posts views Thread by EoRaptor | last post: by
6 posts views Thread by John Carroll | last post: by
reply views Thread by Bruce Pullen | last post: by
3 posts views Thread by Tejas | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.