Archives of the TeradataForum

Message Posted: Tue, 01 Jul 2003 @ 13:31:35 GMT

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

Jake,

Use the following query to check the users who are holding spool:...

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

You can use The 'updatespace' utility to recover this space, however you will need to enter each database individually.

On your PDN node start cnsterm:

Example:
$ cnsterm 6
Attempting to connect to CNS...completed.
Input Supervisor Command:
> start updatespace
start updatespace
Started 'updatespace' in window 1
 at Tue Jul  1 09:36:35 2003

<>>

$ cnsterm 1
Attempting to connect to CNS...completed.
Hello
The Update Space program provides for recalculating the
permanent database space or temporary space or spool
space used by a single database or by all databases in
the system.

The format of the input command is:

UPDATE [SPOOL | TEMPORARY | ALL] SPACE FOR {ALL DATABASES | dbname} ;

Enter either ALL DATABASES or the name of the database
  for which space is to be recalculated.  The SPOOL
  parameter is only allowed with a single database.

Enter Command
>update spool space for ....

Hope this helps...

Thanks and Regards,

Bharat Tripathi
eMedNY Data Warehouse

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