Archives of the TeradataForum

Message Posted: Thu, 10 Apr 2008 @ 14:45:41 GMT

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

Run the following query to identify users that are holding leftover spool:

     SELECT distinct(DATABASENAME) (title '')
     FROM DBC.DISKSPACE
     WHERE DATABASENAME NOT IN (SEL USERNAME FROM DBC.SESSIONINFO)
     AND DATABASENAME <> 'DBC'
     AND CURRENTSPOOL > 0
     ORDER BY 1;

You would then need to logon to the Unix node and run the following command for each user Identified by the above SQL. Replace the XXX by the user who is holding leftover spool:

     cnsrun -utility updatespace -commands "{update spool space for XXX;}
     {quit}"

Robert J Hanson
Senior Consultant Teradata PS
Teradata

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