Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 10 Sep 2003 @ 12:50:59 GMT


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


Subj:   Re: Increasing Spool space for a User
 
From:   Ruth Fenwick

Spoolspace is not cumulative like Permspace is.

A user can not have more spool that its owner (or parent), but it is not 'reserved' for them. When looking for spool space, the system will use every available block that does not have perm space on it. It's not a good practice, but you could give a user more spool than space available on the system.

A good rule of thumb is to use maxspool as a ceiling for the user - make their spool large enough to run the queries they need to, but not much bigger - that way it keeps the run away query from consuming the system. It's also a capacity planning issue - if I have x users active, each using y spool, do I have xy space available for spool.

Ruth Fenwick
Database Services



     
  <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