a month ago
I am trying to create a volatile table in teradata using pro ds2 but I get the following error message
LIBNAME _tdwork TERADATA SERVER=tdb AUTHDOMAIN=TeradataAuth MODE=teradata
ERROR: Compilation error. ERROR: General error No more room in database ABBCC. ERROR: Unable to execute CREATE TABLE statement for table _tdwork.cars.
But if I change the destination to the permanent library in teradata, the codes run without any problem
libname _DATALAB TERADATA server=tdb schema=&SYS_DATALAB AUTHDOMAIN=teradataauth query_band="SYS_PROJECT=&sys_project.;SYS_GROUP=&sys_group.;"; proc ds2; data _datalab.cars; method run(); set cars; end; enddata; run; quit;
Using a data step creates the volatile table with no problem
data _tdwork.cars; set cars; run;
using the fastload=yes option to upload data to the temporary library also gives the following error
data _tdwork.cars(fastload=yes); set cars; run; ERROR: Teradata connection: No more room in database ABBACC. Correct error and restart as an APPEND process with option TPT_RESTART=YES. Since no checkpoints were taken, if the previous run used FIRSTOBS=n, use the same value in the restart. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set WORK.CARS. WARNING: The data set _TDWORK.car may be incomplete. When this step was stopped there were 0 observations and 15 variables. ERROR: ROLLBACK issued due to errors for data set _TDWORK.cars.DATA.
4 weeks ago
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.