Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2009 @ 20:46:10 GMT
<-- Anonymously Posted: Wed, 4 Feb 2009 10:47 -->
I need some help. I have been asked to come up with a way to do the following.
1. If a user hits 500 GB of spool lower their priority automatically.
I am able to identify those users using 500 GB of spool but I don't know how to automate changing someone's account string from $H to $L for the duration of their session.
2. Identify poor performing queries while they happen.
Again I can identify poor queries from the DBQL logs but that is after the fact. How can I do this while the query is happening?
Thanks in advance for the help!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|