Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2003 @ 20:41:05 GMT


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


Subj:   OLE LOAD ISSUE
 
From:   Joan Robertson

We currently have an issue using OLE load pulling data from Sybase to Teradata. On a few occasions the Sybase database went down during an OLE load process. However, the OLE load continued running, and the Teradata table continued receiving the same row of data. This cycle continued until the Teradata database finally ran out of space.

**** 12:36:04 RDBMS error 2644: No more room in database
              Deck_Stage_Tbls.
**** 12:36:04 Increase database size and restart FastLoad

The Sybase table contains only 1.2 million rows, but Teradata received nearly 25.8 million before the space issue aborted the job. Does anyone know how OLE load works, and in what way Teradata would be notified of a problem like this, and therefore end with an error code?

Thanks



     
  <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: 15 Jun 2023