Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 01 Jun 2005 @ 19:42:46 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Spool space parameter in DATABASE
From:   Diehl, Robert

Creating a DATABASE with spool space has no impact on queries. It does set the maximum and/or default for any child USERS or DATABASES. This extends to all levels below it.

Here are two examples.

1) default. Database MASTER_DB has 100 gig of spool. If you create a USER or DATABASE under with OWNER MASTER_DB with no spool defined the USER or DATABSE will be given 100 GIG of spool

2) maximum. IF database Master_DB has 100 gig of spool. The most spool you can give a child is 100 gig. A child can have more spool than its direct owner (direct parent). To do this the Owner Database would have to have had a spool space higher or equal to the childs spool at the time the child was created. Another way a child can have more spool than a Owner is to create the User or Database under a different Owner, then GIVE the USER or Database to the Owner.

Use of profiles with spool limits on USERS breaks the rules above. Any settings in a PROFILE will override the settings given to the USER with that PROFILE.


Bob Diehl

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