datastage因ftp作业超时报错的解决



作业报错信息如下：

ECIF_FTP,0: error: ftp returned 426

ftp msg: 426 Data connection: Error 0

错误分析：

CBS_BDSKH中sql语句如下：

SELECT a.kehhao, a.gerzwm,a.gerywm, a.guobdm,a.jinnbz, a.xngbie, a.chusrq,a.zhjnzl, a.zhjhao,a.dzyjdz,a.fazjig,a.fzjgdq,a.zjdjdz,a.ywendz,a.danwxz,a.gngzdw,a.bangdh,a.bangdz,a.czhenh,a.danwyb,a.katuor, a.zhiche, a.xuelii, a.funyck,a.zzaidz,a.dianhh,a.dsyhyb,a.zhiwuu,a.zhiyee, a.dizhii, a.youzbm, a.lxdiah, a.wgktyw, a.khjgdh, a.ka1hgy, a.kaihrq,a.weihgy, a.weihrq, a.jiluzt, b.yngyjg,a.zinuck,a.yuesur

FROM bdskh a left join pgycs b on a.weihgy=b.guiydh 

order by a.kehhao

此sql执行效率较低，单纯执行sql耗时9分钟左右，此时ftp链接已断。

解决方法：

登录ftp服务器，修改配置文件的data_connection_timeout=1200