Highly Volatile Table. Lots of Inserts & Deletes, Hardly every Read and small amount of data.. Persistent Message Store basically.


  • I have a table that is used to persist messages/events which means data is inserted and deleted over and over and hardly ever read and usually there is limited amount of data in it... since a row is inserted... the event processed and then the row is deleted. The data in it only lives a short time.

    I am getting deadlocks on that table trying to delete by the primary key. How can I reduce the locking on this table and prevent deadlocks? (delete from ops_event where "pkid" = ?)

    Is there anything like the DB2 "Volatile" keyword for the table?


    Monday, July 15, 2013 8:03 PM