 |
 |
Archives of the TeradataForum
Message Posted: Fri, 07 Aug 2009 @ 07:39:05 GMT
| Subj: | | Re: Get History of blocking. |
| |
| From: | | Ronald Montemayor |
Vinay Bagare wrote:
| | If you have acess to Higa tools, you could. | |
| | I tried one another option, which relies on TD alert for blocking. | |
| | The process outputs to alerts.log file and there has to be process to parse this log file and load it into database table. | |
Hi.
Yes, we already have TD Manager alerts that sends out emails everytime a blocked lasted more than x amount of time.
But, What we actually need is to review the details (who blocked, who got blocked, what sql, etc.) at a later time.
| |
