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?