Archives of the TeradataForum

Message Posted: Thu, 16 Dec 2004 @ 13:03:51 GMT

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

     select databasename
        ,vproc
        ,currentspool
     from DBC.DiskSpace d
     where currentspool <> 0
      and  NOT EXISTS
             (sel 1
              from DBC.SessionInfo s
              where d.databasename = s.username)
     order by 1,2;

run this report

if you get a hit cnsterm 6 on pde and start updatespace go to window where update started and

     update spool space for xxxxxxxx;         where xxxxx is your hit name

Christopher Platt
Teradata Systems Administration

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