Oninit cdi / Archive
Talk to an expert →

deadlock question

Posted in 2011

Summary

Jack Papa asked how to check from catalog tables whether a deadlock occurred on a given date. Bob (rroussey) suggested catching it in an ALARMPROGRAM script by scanning severity 1 text. Dave Griffen said nothing tracks deadlocks by date, but counters exist in sysmaster:sysprofile.deadlks and sysmaster:sysptprof.deadlks, reset at startup or by onstat -z. Jack said he would check those tables.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Transactions, Locking & Isolation

JACK PAPA — — source: IIUG Forums & Mailing Lists

Hi All, Someone asked me to verify if a deadlock occured during a particular date. I would like to know if there's a way to select it from the catalog tables (if a deadlock occured)... I didn't find anything from the online.log... Best regards,

↪ replying to JACK PAPA
rroussey@comcast.net — — source: IIUG Forums & Mailing Lists

You *might* catch it with the ALARMPROGRAM script. Look at severity=1 and scan the additional_text field (4th parameter) for something about deadlock. That's where I found I could catch the "dynamically allocated locks" messages and email a warning to myself. Bob ----- Original Message ----- From: "JACK PAPA" <informix2009@gmail.com> To: ids@iiug.org Sent: Wednesday, May 11, 2011 2:09:55 AM Subject: deadlock question [23639] Hi All, Someone asked me to verify if a deadlock occured during a particular date. I would like to know if there's a way to select it from the catalog tables (if a deadlock occured)... I didn't find anything from the online.log... Best regards, ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to JACK PAPA
DAVE GRIFFEN — — source: IIUG Forums & Mailing Lists

JACK PAPA Wrote: -------------------------------------------------------------------------------- -------------------------------------------------- Hi All, Someone asked me to verify if a deadlock occured during a particular date. I would like to know if there's a way to select it from the catalog tables (if a deadlock occured)... I didn't find anything from the online.log... Best regards, -------------------------------------------------------------------------------- -------------------------------------------------- Response: I don't know of anything that tracks deadlocks by a particular date. However, there are counters of deadlock occurrences in sysmaster:sysprofile.deadlks (instance level) and in sysmaster:sysptprof.deadlks (table/index partition level). These counters are reset when the instance is started or if an onstat -z is done.

↪ replying to DAVE GRIFFEN
JACK PAPA — — source: IIUG Forums & Mailing Lists

Thank you guys..i'll try to check from the mentioned tables.

Related threads