 |
 |
Archives of the TeradataForum
Message Posted: Mon, 04 Jun 2001 @ 20:15:05 GMT
| Subj: | | Re: MSI Timeouts |
| |
| From: | | Steve Hummel |
I don't know that much about MSI, but I would think _any_ time limit could be arbitrary, especially if the query that gets timed out is
the "million dollar question" that the marketing VP asked an hour ago. Have you considered using the "Alert" facility in Teradata Manager
to notify a DBA when conditions are out of whack? The DBA can then investigate, and make a determination as to whether the query should
continue or not. Another possibility might be to use the Database Query Manager (DBQM), which will allow you to place up-front restrictions
on ODBC queries; these restrictions can be based on database object access rules or expected resource usage (e.g., full table scans, join
types, etc.). (btw, in V2R4.1 later this summer, a new architecture of DBQM is being released as Teradata Dynamic Query Manager, which can
intercept all queries, not just ODBC.)
Steve Hummel
Sr. Product Manager
Teradata, a division of NCR
| |
