Negative Spool in Viewpoint

Viewpoint
Enthusiast

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

3 REPLIES
Junior Supporter

Re: Negative Spool in Viewpoint

Hi.

Phantom / Orphan spool perhaps.

updatespace utility should fix it.

HTH.

Cheers.

Carlos.

Enthusiast

Re: Negative Spool in Viewpoint

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

 

Junior Supporter

Re: Negative Spool in Viewpoint

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.