Is there any relationship between this error and db utilization factor ?
Get Teradata No More Spool Space
Pictures. Roughly speaking, teradata spool is the space dbas assign to each user account as work space for queries. In that i am getting 'no more spool space in database'.
Troubleshooting Sas And Teradata Query Performance Problems Manualzz from s1.manualzz.com
1gb of spool space is available on each amp under this user. It's my client computer, so i'm not always in front of her, most work at home. The amount of permanent space is divided among the number of amps.whenever per amp limit exceeds the allocated space of amp, 'no more room in database'.
Roughly speaking, teradata spool is the space dbas assign to each user account as work space for queries.
Max spool used by a session (since the last diskspace table reset) is found in the dbc.diskspace view. So my question is : For the second two tactics i'll show. 1gb of spool space is available on each amp under this user.
