Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 10 Apr 2008 @ 14:45:41 GMT


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


Subj:   Re: Mystery CurrentSpool
 
From:   Hanson, Robert

Run the following query to identify users that are holding leftover spool:

     SELECT distinct(DATABASENAME) (title '')
     FROM DBC.DISKSPACE
     WHERE DATABASENAME NOT IN (SEL USERNAME FROM DBC.SESSIONINFO)
     AND DATABASENAME <> 'DBC'
     AND CURRENTSPOOL > 0
     ORDER BY 1;

You would then need to logon to the Unix node and run the following command for each user Identified by the above SQL. Replace the XXX by the user who is holding leftover spool:

     cnsrun -utility updatespace -commands "{update spool space for XXX;}
     {quit}"

Robert J Hanson
Senior Consultant Teradata PS
Teradata



     
  <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: 28 Jun 2020