Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   FastExport script failure - No more spool space
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016