Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Jun 2014 @ 21:55:09 GMT


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


Subj:   Viewpoint showing negative spool space
 
From:   Ganga, Sandeep Kumar

Hi Experts,

Scenario: Viewpoint showing negative spool space

We have runned updatespace utility this resolved the issue temporarily and was been occurring later a week or two the utility runned.

Logs shows no negative spool as well.

Please confirm why we are seeing this and how we can avoid the issue further.

My understanding is that the Database Space collector queries and retains database-space metrics from the DBC.DataBaseSpace and DBC.DBase tables, not DBQL.

The spool space metric is collected by the space collector and also updates the VP system_statistics table where the system health portlet reads it.

There is no calculation done on the data.? Viewpoint is reporting what is returned by the database.but on reviewing DB logs found no issues this end.

Thanks in advance,


Regards,

Sandeep.



     
  <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