All Forums Viewpoint
Chiraggorsia 7 posts Joined 06/15
19 May 2016
Negative Spool in Viewpoint

Hi All,
 
Recently while monitering Viewpoint I saw one of the delete queries showing negative spool.
Can any one tell me what does that indicate.
 
Regards,
Chirag

CarlosAL 512 posts Joined 04/08
20 May 2016

Hi.
Phantom / Orphan spool perhaps.
updatespace utility should fix it.
HTH.
Cheers.
Carlos.

Chiraggorsia 7 posts Joined 06/15
14 Jun 2016

Hi Carlos,
Thanks for you answer.
But can you please update on what is Phantom / Orphan spool, Or do you have a link where I can read about it? 
Regards,
Chirag
 

CarlosAL 512 posts Joined 04/08
15 Jun 2016

Hi.
Spool files left behind (not dropped) after request ended / aborted.
Also, there can be DBC.DatabaseSpace inconsistencies.
The updatespace utility resolves all of this.
HTH.
Cheers.
Carlos.

You must sign in to leave a comment.