Archives of the TeradataForum

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

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

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.

Thanks,

Bob Diehl

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