Check with your DBAs what they see on their side (if they are the kind to reply to emails that is). It looks like one method (proc DS2) uses resources that the other method (data step) doesn't need. My hunch is that the data step processes one record a at time and therefore needs has low "temp" space needs, but who knows...    In any case the message is clear: No more room for what you are trying to do. Unless someone with deep knowledge of Teradata (and DS2) can answer your question here, I'd try to solve this with the DBAs.   Once you've solved the issue, please kindly post what you have learnt. Many here would undoubtedly be interested.             ... View more