Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 04 Jun 2001 @ 20:15:05 GMT

  <Prev Next>   <<First <Prev

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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020