Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 30 Jun 2004 @ 12:24:04 GMT

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

Subj:   Re: How do I calculate Spool Usage
From:   Tewksbury, Kevin


I would recommend using dbc.allspace. In the dbc.databasespace table the databasename is only an ID (an integer value), you would have to join to dbc.dbase to get/convert the username to get their ID for the databasespace table. The below query will give you space used by vproc. You can run this while the user query is running and order by 2 desc (currentspool) to see if the query is "hot amping" as well. We typically will clearpeakdisk for a user, have them run their query and monitor during (with currentspool) and after (with peakspool).

     select vproc, sum(currentspool), sum(peakspool), sum(maxspool)
     from dbc.allspace
     where databasename = 'xxxxxxxx'
     group by 1
     order by 3 desc


  <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: 23 Jun 2019