Archives of the TeradataForum

Message Posted: Thu, 09 Nov 2006 @ 18:22:18 GMT

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

You need to check left over spool space.

You can check it with below query, login as DBC.

     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;

If it returns any rows then you need to update spool space for those users. To update space, you need to

1. login to any node as root.

2. Run cnsterm 6

3. start updatespace

4. cnsterm 1 (another unix window/shell)

5. update spool space for <Userid>;

I hope that this will help you.

Thanks & Regards,

Shrinivas Sagare

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