Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Apr 2006 @ 21:33:17 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Spool space available before running my query
 
From:   Meade, Cornelius

I do not believe there is any direct way via a query however there are ways to infer the potentially available spool space. These are only estimates at best and do not necessarily reflect the instantaneous system state. Assuming you went ahead and developed PM/API compliant code to get at the real time system state information (like that used/displayed by PMON/TDM) still you would have the issue of it only being valid as of the point in time when you took a look. The problem is that is a fleeting instant and the system state in the next second or two could be dramatically different unless you have some control over what other work is currently executing or has started in the interim.

So the real question becomes, What is the intended use of this information?


Cornelius Meade III
EDS - Consulting Services/BI/CRM



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