Archives of the TeradataForum
Message Posted: Wed, 01 Jun 2005 @ 19:42:46 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|