Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 08 Sep 1999 @ 21:47:38 GMT

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

Subj:   Re: Increasing Spool Space
From:   Fred Pluebell

     MODIFY DATABASE dbname AS SPOOL = newvalue;


     MODIFY USER username AS SPOOL = newvalue;

1) Must be done at the individual Database (User) level, not recursive.

2) MODIFY ... SPOOL requires DROP access rights (Does not actually DROP).

3) At the time of the MODIFY, new value specified for SPOOL bytes must not exceed SpoolSpace limit of the immediate parent of the target Database (User).

4) SPOOL for a parent Database (User) can be decreased with no effect on the limits for existing children.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023