本文介绍了将数据插入到netezza的外部表中时发生错误[08S01]通信链接失败的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试将文本文件中的数据加载到 Netezza 中的外部表中.

这是我的命令

INSERT INTO XTABLE_DHARMESH SELECT * FROM EXTERNAL 'C:\Dhams\mergeresult.txt' 
USING (delimiter ',' REMOTESOURCE 'ODBC' LOGDIR 'C:\Dhams');

我得到ERROR [08S01] Communication link failure.

当我的文件中有100万条记录,而我的文本文件中的1000条记录运行正常时,就会发生此错误.

解决方案

我在 Windows 7 Windows Server 2008 R2 中发现了TCP烟囱设置. /p>

http://blogs.dirteam.com/blogs/sanderberkouwer/archive/2008/05/15/backward-compatible-networking-with-server-core.aspx

Folwing指令为我解决了此问题:

netsh interface tcp set global rss=disabled
netsh interface tcp set global chimney=disabled
netsh interface tcp set global autotuning=disabled 

您可以通过以下命令确认它们已被禁用

netsh int tcp show global

I am trying to load data from text file to External table in Netezza.

Here is my command

INSERT INTO XTABLE_DHARMESH SELECT * FROM EXTERNAL 'C:\Dhams\mergeresult.txt' 
USING (delimiter ',' REMOTESOURCE 'ODBC' LOGDIR 'C:\Dhams');

I am getting ERROR [08S01] Communication link failure.

This error is occurring when I have 1 millions of records in file whereas it is working fine for 1000 records in my textfile.

解决方案

I have found in Windows 7 and Windows Server 2008 R2 TCP Chimney Settings were the culprit.

http://blogs.dirteam.com/blogs/sanderberkouwer/archive/2008/05/15/backward-compatible-networking-with-server-core.aspx

The Follwing Commands Fixed this issue for me:

netsh interface tcp set global rss=disabled
netsh interface tcp set global chimney=disabled
netsh interface tcp set global autotuning=disabled 

You can confirm that they were disabled with the following command

netsh int tcp show global

这篇关于将数据插入到netezza的外部表中时发生错误[08S01]通信链接失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-26 15:52