Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 17:43:44 GMT


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


Subj:   Spool Usage without Session
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, May 06, 2004 13:29 -->

Hi All,

Anyone know how a user could have current spool usage if the user has no current session logged on? I have that as shown by the below BTEQ results where user has current spool but no session. In our diskspace history table, this user has this same current spool usage every hour of every day going back to early April. I greatly appreciate any ideas how this can be or how to fix it.

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     Select *
     From DBC.sessionInfo
     Where username = 'fryer';
      *** Query completed. No rows found.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     Select vproc, databasename, currentspool
     From DBC.DiskSpace
     Where databasename = 'fryer';
      *** Query completed. 16 rows found. 3 columns returned.
      *** Total elapsed time was 4 seconds.
      Vproc  DatabaseName                           CurrentSpool
     ------  ------------------------------  -------------------
          0  fryer                                           0
          1  fryer                                           0
          2  fryer                               1,433,570,816
          3  fryer                               1,411,943,424
          4  fryer                                           0
          5  fryer                                           0
          6  fryer                               1,410,153,984
          7  fryer                               1,410,483,712
          8  fryer                               1,417,439,744
          9  fryer                               1,419,947,520
         10  fryer                                           0
         11  fryer                                           0
         12  fryer                               1,391,145,472
         13  fryer                               1,405,389,312
         14  fryer                                           0
         15  fryer                                           0

Thanks!



     
  <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: 27 Dec 2016