All Forums Database
Elle 16 posts Joined 11/07
29 Jul 2013
Database Maxspool

Hello,
 
I understand how maxspool works for users and profiles, but am uncertain if the same rules or sizing techniques apply when creating a database.  So when I am creating a database (NOT user, NOT profile) what impact does the Spool settings have on queries?  What would be a general rule of thumb for setting spool (and temp) space for a database?
Thanks for your assistance!
 
Excerpt from "Database Administration - 13.10 " PDF
 
When using the CREATE USER, CREATE DATABASE, or CREATE PROFILE statements to
assign spool space limits, consider the settings of the following space levels, which are listed in
the DBC.DiskSpaceV view.
 
MaxSpool
A value used to limit the number of bytes the system allocates to create spool
files for a user.
The value you specify may not exceed the value of the immediate parent
(database or user) at the time you create the user. If you do not specify a value,
MaxSpool defaults to the MaxSpool value of the parent.
Specify the spool limit of each user, taking into consideration the tables they
access, to reduce the impact of “runaway” transactions, such as accidental
Cartesian product joins.

teradatauser2 236 posts Joined 04/12
02 Aug 2013

Hi,
spool is only used for uers and not databases. You can create a user under another user or database. 
Since databases and users are very similar in TD, that's why it might be mentioned here.
I have never came across spool space given to database. its given to user directly or to profile , in which users are added.
When using the CREATE USER, CREATE DATABASE, or CREATE PROFILE statements to
assign spool space limits, consider the settings of the following space levels, which are listed in
the DBC.DiskSpaceV view. - 
 

You must sign in to leave a comment.