By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,816 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,816 IT Pros & Developers. It's quick & easy.

Snapshot Statement - No statement text if in lock-wait state ?

P: n/a
Hi all,
(DB2 LUW 8.2)

I'm just trying to write a little widget to capture lock wait details
(when they occur).

i.e when a lock-wait occurs, simply record the 2 statements involved
in the lock wait.

However, I am stumped by the fact that the snapshot monitor does not
seem to return
the SQL statement text of the application that is waiting ???
- I have tried the CLP and Snapshot Table Functions.
- the SQL statement text is available for the application holding
the lock.

NB. I am using the SYSPROC.SNAPSHOT_ * table functions.

I have the following monitor switches enabled in the DBM CFG
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF

Any ideas?

Jan 29 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
PLease ignore , This seems to be working now?? - not sure what
changed.

On Jan 29, 3:39 pm, "PaulR" <p...@abacus.co.ukwrote:
Hi all,
(DB2 LUW 8.2)

I'm just trying to write a little widget to capture lock wait details
(when they occur).

i.e when a lock-wait occurs, simply record the 2 statements involved
in the lock wait.

However, I am stumped by the fact that the snapshot monitor does not
seem to return
the SQL statement text of the application that is waiting ???
- I have tried the CLP and Snapshot Table Functions.
- the SQL statement text is available for the application holding
the lock.

NB. I am using the SYSPROC.SNAPSHOT_ * table functions.

I have the following monitor switches enabled in the DBM CFG
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF

Any ideas?
Jan 29 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.