>I looked in a database, and in MON$STATEMENTS tabla I have the following >fields:
MON$STATEMENT_ID MON$ATTACHMENT_ID MON$TRANSACTION_ID MON$STATE MON$TIMESTAMP MON$SQL_TEXT MON$STAT_ID >How can I detect which is the record I have to delete to unlock my record? >This is the only table I have to modify? I typically just look at the mon$sql_text with a mon$timestamp that seems to be the correct one. HTH, Set -------- Mensaje original ------- >> May be I can modify or delete some record in any MON$ table or do some other >> thing? >I typically locate and delete records from MON$STATEMENTS. Mind you, that is >2.5 and typically when I have a long- >running query. Don't know whether deleting from this table is possible or safe >with 2.1 or sensible WITH LOCK.
