Archives of the TeradataForum
Message Posted: Wed, 21 Apr 2004 @ 12:39:25 GMT
| Subj: || || Re: SHOWLOCKS and Locked DB Info |
| From: || || Glen Blood |
This only gives you current HUTCNS (ARC) locks. You may be able to use DBC.RCEVENT and DBC.LOGONOFF to figure out the lock time. Mainfrme
ARC jobs (at least here) give you sufficient information tin logonsource to identify arc jobs. I have just started playing with DBC.RCEVENT. It
looks like it will give you both successes and failures.
Locking logger will give you blocking times.