 |
 |
Archives of the TeradataForum
Message Posted: Tue, 22 Aug 2006 @ 15:21:23 GMT
| 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
| |
