Archives of the TeradataForum

Message Posted: Tue, 15 Apr 2008 @ 12:47:47 GMT


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

Subj:		Re: Mystery CurrentSpool

From:		Stieger, Etienne E

Robert wrote the following:

          >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}"

However,when I try this on a node:

     /nssoft/unix-soft/06.00.02.16/shadowpma/usr/ntos/bin/cnsrun -utility
     updatespace -commands "{update spool space for MYTESTUSER;} {quit}"

I get the following error:

     /nssoft/unix-soft/06.00.02.16/shadowpma/usr/ntos/bin/cnsrun: CNS
     Connection Lost.

Also, it is not successful in releasing the phantom spool.

Any suggestions? (I am still waiting for access to the Teradata knowledge articles).

Kind rgards

Etienne Stieger
Analytics and Information Management (AIM/EIW)
Standard Bank of South Africa Ltd


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

Attachments

Library

Quick Reference