Negetive Spool is being displayed in Teradata Manager

Database
Enthusiast

Negetive Spool is being displayed in Teradata Manager

Hello All,

While monitoring the PROD, I cam across a typical situation. For one of the Session Current Spool was a negative number. The details are as follows -

AMP State - ACTIVE
PE State - DISPATCHING
Current Request CPU - 0
Current Request IOs - 404
Current Spool - -20964352

Can anybody please help me to understand why Current Spool is Negetive? We are having V2R6.

Thanks in advance.

Regards,
Somnath Roy
Tags (1)
1 REPLY
Enthusiast

Re: Negetive Spool is being displayed in Teradata Manager

Over the years Teradata has had some issues displaying negative spool. I believe it has something to do with the "direction" that the spool calulation comes from. We're on rel 12 and don't seem to have that issue.