Resolve Orphan or Phantom Spool Issues | Teradata Vantage - Resolving Orphan or Phantom Spool Issues - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

In rare cases when a request completes (or is aborted), the spool file is not dropped. The leftover spool may be:

  • Orphan: The spool file (tableid) incorrectly remains in existence.
  • Phantom: The spool file tableid is gone, but the spool space is still allocated.

Execute the following query to determine the presence of leftover spool of either type:

SELECT Databasename, Vproc, CurrentSpool
FROM DBC.Diskspace
WHERE Databasename NOT IN (SELECT Username FROM DBC.SessionInfo)
AND CurrentSpool > 0
ORDER BY 1,2
WITH SUM (CurrentSpool);

If this request returns rows, the next step is to run the Update Space (updatespace) utility.

The Update Space utility can also be used to correct inconsistencies in the DBC.DatabaseSpace table, which might occur because of unusual types of system failures.

From the Supervisor window issue:

START UPDATESPACE