Archives of the TeradataForum

Message Posted: Tue, 25 Oct 2011 @ 19:36:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, October 25, 2011 14:18 -->

Hi Folks,

I faced a wierd problem while using FastExport today. When I run a FExp code from UNIX, the script fails with the error : UTY8713 RDBMS failure, 2646: No more spool space in PASUSER1.

Interestingly enough, when I run the same SELECT query from SQL Assistant with the same userid, I get back results !

Can anyone please help me understand and remediate this issue. The FastExport script is given below :

     ----------------------------------------------------------------
     .LOGTABLE HCCL_SHARE.test_fexplog_L ; /* define restart log */ .LOGON
     tdpx/PASUSER1,password ; /* DBC logon string */ .BEGIN EXPORT /* specify export function
     */ SESSIONS 5; /* number of sessions to be used */ .EXPORT OUTFILE outfile1 ; /* identify
     the destination */ SELECT TOP 100 CAST(PAT_ID AS CHAR(50)), CAST(';' AS CHAR(1)),
     CAST(PAT_NAME AS CHAR(100)) FROM HCCL.PATIENT ; .END EXPORT ; /* terminate the export */
     .LOGOFF ;
     ----------------------------------------------------------------

Thanks much for your help.

	<Prev	Next>		<<First	<Prev	Next>	Last>>