Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Aug 2006 @ 15:21:23 GMT


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


Subj:   Help needed with Fexport job
 
From:   Jeyaraj, Rameshkumar

Hi All,

The following Fexport failed.I have created a named pipe to parallely write(Fexport) and read (Mload)


     ---------------------------------------------------------------
          -                                                        -
          -          FastExport Initial Phase                      -
          -                                                        -
     ---------------------------------------------------------------
     **** 09:39:32 UTY8700 Options in effect for this FastExport task:
          .       Sessions:    64 session(s).
          .                    Minimum of 16 export session(s) requested.
          .       Mode:        INDICATOR
          .       Blocksize:   64260 bytes.
          .       Outlimit:    No limit in effect.
          .       Tenacity:    2 hour limit to successfully connect load sessions.
          .       Sleep   :    5 minute(s).
     **** 09:39:32 UTY8715 FastExport is submitting the following request:
          Select NULL from p_bcd_ut1.cl_bill_rbp_log where (LogType = 220) and (Seq =
          1) and (FExptSeq = 0);
     **** 09:39:46 UTY8705 EXPORT session(s) requested: 64.
     **** 09:39:46 UTY8706 EXPORT session(s) connected: 64.
     **** 09:39:46 UTY8715 FastExport is submitting the following request:
          BT;BEGIN FASTEXPORT;
     **** 09:39:46 UTY8715 FastExport is submitting the following request:
          SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER), MiscInt3 (INTEGER),FExptSeq
          (INTEGER), FExptCkpt (VARBYTE(1024)) from p_bcd_ut1.cl_bill_rbp_log WHERE
          (LogType = 210) and (Seq = 1) and (FExptSeq IN (SELECT MAX(FExptSeq) from
          p_bcd_ut1.cl_bill_rbp_log where (LogType = 210) and (Seq = 1)));
     **** 09:39:46 UTY8715 FastExport is submitting the following request:
          SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER),  MiscInt3 (INTEGER),FExptSeq
          (INTEGER), FExptCkpt (VARBYTE(1024)) from p_bcd_ut1.cl_bill_rbp_log WHERE
          (LogType = 212) and (Seq = 1) and (FExptSeq IN (SELECT MAX(FExptSeq) from
          p_bcd_ut1.cl_bill_rbp_log where (LogType = 212) and (Seq = 1)));
     **** 09:41:09 UTY8715 FastExport is submitting the following request:
            select * from test.cl_d1  where timed > 6267;
     **** 09:41:09 UTY8724 Select request submitted to the RDBMS.
     **** 09:41:31 UTY8725 Select execution completed. 94719 data blocks generated.
     **** 09:41:32 UTY4014 Access module error '34' received during 'write' operation: 'pmunxWBuf:
          fwrite byte count error (System error message detected: 32)'
     **** 09:41:32 UTY8721 Error attempting to write file
          /test/cl_d1.pipe, return code

Regards,

Ram



     
  <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