473,322 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Queries against a table

Jay
I have a DB2 UDB database on an AIX UNIX machine. I would like to know
the queries running against certain tables. There are some applications
outside of the database that do read and update these tables. Some have
incorrect isolation levels that end up locking the tables. How can I
find out what queries are running against a table, and how can I kill
them. This is a development environment and I would hate to bother the
DBA to fix these things. Sometime back the DBA has mentioned to me that
he will give the users access to see these things. I just didnt know
how.
Appreciate your help.
Thanks.
Jay

Sep 25 '06 #1
4 1678
Jay wrote:
I have a DB2 UDB database on an AIX UNIX machine. I would like to know
the queries running against certain tables. There are some applications
outside of the database that do read and update these tables. Some have
incorrect isolation levels that end up locking the tables. How can I
find out what queries are running against a table, and how can I kill
them. This is a development environment and I would hate to bother the
DBA to fix these things. Sometime back the DBA has mentioned to me that
he will give the users access to see these things. I just didnt know
how.
HE must have been talking about giving you SYSMON privileges so you can
use snapshot table functions.
The easiest way. The easiest way to find out which query goes against
which table is to dump the statement cache and grep for the table names.
You can perform more elaborate schemes. But I'd start there.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 25 '06 #2
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:4n************@individual.net...
HE must have been talking about giving you SYSMON privileges so you can
use snapshot table functions.
The easiest way. The easiest way to find out which query goes against
which table is to dump the statement cache and grep for the table names.
You can perform more elaborate schemes. But I'd start there.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
I don't believe that you can kill (force) any offending applications with
SYSMON authority.
Sep 25 '06 #3
Mark A wrote:
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:4n************@individual.net...
>HE must have been talking about giving you SYSMON privileges so you can
use snapshot table functions.
The easiest way. The easiest way to find out which query goes against
which table is to dump the statement cache and grep for the table names.
You can perform more elaborate schemes. But I'd start there.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

I don't believe that you can kill (force) any offending applications with
SYSMON authority.

No. But you got to find'em first.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 26 '06 #4
Jay
How would I do that in unix. I mean what is the command to run at the
unix prompt.
Thanks.

Mark A wrote:
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:4n************@individual.net...
HE must have been talking about giving you SYSMON privileges so you can
use snapshot table functions.
The easiest way. The easiest way to find out which query goes against
which table is to dump the statement cache and grep for the table names.
You can perform more elaborate schemes. But I'd start there.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

I don't believe that you can kill (force) any offending applications with
SYSMON authority.
Sep 26 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
7
by: D | last post by:
18k queries against 70k rows query: select cn from geoip where between start and end table: "start_ip","end_ip","start","end","cc","cn"...
6
by: Brad | last post by:
I have an sql query that has specific criteria (like state='PA' or state = 'NJ'...) and would like to be able to have the user specify the criteria dynamically either through the web or from...
2
by: hazz | last post by:
Does anyone have any ideas on how to implement what has been suggested for my 'rules engine'? thx, -hazz the following are rules in the sql server table, one row for each rule. Table Column ...
2
by: Tim Pollard | last post by:
Hi I'm hoping someone can help me with an access problem I just can't get my head around. I normally use access as a back end for asp pages, just to hold data in tables, so queries within access...
4
by: Dave Edwards | last post by:
I understand that I can fill a datagrid with multiple queries, but I cannot figure out how to fill a dataset with the same query but run against multiple SQL servers, the query , table structure...
4
by: dave | last post by:
Hi, I have a job where it will involve checking large volumes of addresses against a master address table. The master address table contains approx 1.7 million addresses. The files (normally...
1
by: tgphelps | last post by:
I've got this 20,000 row table. It had never given anyone trouble. I'm not a particularly good SQL Server admin, but I'm all we have. I was certified on MSSQL 7, some years ago, but it's just a...
9
by: jehugaleahsa | last post by:
Hello: I am writing a cute little class that will cache queries against a database. Currently, I am implementing this by storing the command text, parameter values and generated DataRows. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.