Hello,

DB2 V8 LUW FP 11.

My applications eventually takes a very long time to process simple
insert statements.
Here´s the output of a event monitor:

 Text     : INSERT INTO MyTable
VALUES('000D60984D9A586AAD001128','2006-09-23-02.25.00',0,103923200,1843939328,298211000,6931647000,1834013105000,128034627001536546,6779,252559,0,33,54219,12803462700153654)
 -------------------------------------------
 Start Time: 09/25/2006 13:53:51.471750
 Stop Time:  09/25/2006 13:54:21.137034
 Exec Time:  29.665284 seconds
 Number of Agents created: 1
 User CPU: 0.000000 seconds
 System CPU: 0.000000 seconds
 Fetch Count: 0
 Sorts: 0
 Total sort time: 0
 Sort overflows: 0
 Rows read: 0
 Rows written: 1
 Internal rows deleted: 0
 Internal rows updated: 0
 Internal rows inserted: 0
 Bufferpool data logical reads: 0
 Bufferpool data physical reads: 0
 Bufferpool temporary data logical reads: 0
 Bufferpool temporary data physical reads: 0
 Bufferpool index logical reads: 0
 Bufferpool index physical reads: 0
 Bufferpool temporary index logical reads: 0
 Bufferpool temporary index physical reads: 0
 SQLCA:
  sqlcode: 0
  sqlstate: 00000

There are no clustered index and/or triggers defined. However, there
are several others applications reading/writing into the same table.
Locking doesn´t seem to be an issue, as all applications that read
data from the table use the UR isolation.

How do I figure out why the statement took so long to complete? Besides
event monitoring, any traces available? Any other clues ?

Thanks in Advance, Michel