472,339 Members | 1,738 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,339 software developers and data experts.

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 2767
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
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...
11
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....
10
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...
6
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...
0
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...
0
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...
2
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...
3
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...
3
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...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

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.