473,887 Members | 2,359 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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_BUFPOO L) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMEST AMP) = 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 2899
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_BUFPOO L) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMEST AMP) = 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2089
by: aswinee | last post by:
I am running Microsoft SQL Server 2000 - 8.00.760 Enterprise Edition on Windows 2003 Enterprise Edition (NT 5.2 Build 3790:) I have 4CPU and 8GB of RAM. I have AWE enabled, /pae /3gb switch is on in boot.ini, In my errorlog I have noticed few times error messages as "The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock...
11
14081
by: EoRaptor | last post by:
I`m exporting data from many Lotus Notes databases to a DB2 database using LotusScript. The LotusScript agents commit after EACH update/insert. Nevertheless, I keep getting transaction rollbacks on deadlock or timeout. When I get a snapshot for locks, I see that one of the export agents is getting a table lock rather than a row lock. I`m guessing this is what causes the time out. Questions: how do I determine whether it`s a deadlock or a...
10
5142
by: florian | last post by:
Hi, we have a contention problem because of an application which tries to insert a duplicate row in a table with primary key. This insert fails of course but the locks are not released within this transcation. Why DB2 does not release the X lock after a failed insert??? We use DB2 UDB EEE Version 7.2 Fixpak 9, but we also can reproduce the Problem on DB2 UDB ESE 8.1 Linux Fixpak 4.
6
20637
by: John Carroll | last post by:
Is there a SQL query that can be run against a database that will give me all the details on any locks that are in place at the given time? I am interested in find the lock type and owner. Thank you, John
0
3393
by: Bruce Pullen | last post by:
DB2 v7.2 (FP7 - DB2 v7.1.0.68) on AIX 5.2.0.0. We're seeing unexpected single row (then commit) insert locking behaviour. We're seeing Applications that already hold row-level W locks in lock-wait, waiting to acquire row-level X locks. The lock-waits are behind applications that have row-level X locks on different rows (honestly). Both executing and lock-waiting applications have been granted IX table locks.
0
1392
by: db2group88 | last post by:
hi, we are using db2 udb v8.1 on windows with type 4 db2jcc driver, our application use jdbc to create statement and execute query, i would like to know when the application connect to DB2 blow up in the middle, will the resource created by this application get released from DB2, such as locks, when i do db2 get snapshot for locks for the application handler, i still can see the locks holding there, so why they are not released when the...
2
5684
by: aj | last post by:
DB2 WSE 8.1 FP5 Red Hat AS 2.1 I'm trying to monitor locks in my DB by running the following shell script: while true do db2 get snapshot for locks on <db> | head -9 sleep 3
3
2148
by: bughunter | last post by:
Description The maximum number of locks held during this transaction. It's not true. :-( When I tried found longest transactions I see next picture: uow_start_time T1, uow_stop T2, locks_held_top > 0 In monitor for statements
3
1711
by: Tejas | last post by:
Hi, I have gone through the snapshot API. I need to use it for finding location of database files, tablespace containers etc on a remote machine. These parameters are present in the response. However, for getting only some paramters, I get a huge response, with many parameters that I do not need (mostly many are performance parameters). How long can the snapshot response be, and can it considerably affect performance?
0
9799
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11173
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10432
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7988
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5809
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6011
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4632
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4238
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3245
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.