上一篇  |  下一篇
数据库技术
Connections to IDS hang

Problem(Abstract)


Connections to Informix Dynamic Server (IDS) hang or take a long time to connect. Other users who are already connected do not see a performance problem. Once a user is connected there is no performance problem.

Symptom

Connections to Informix Dynamic Server (IDS) hang or take a long time to connect. Other users who are already connected do not see a performance problem. Once a user is connected there is no performance problem. Users connecting by way of shared memory do not experience a connection hang. Only users using network connections see this problem.

Cause

There are not enough files descriptors allocated for IDS to effectively handle the number of network connections. See the Related information section for a link to more information regarding file descriptors.

Note: This is only one possible cause.

Resolving the problem

1. Increase the number of file descriptors available to a process. Ask your operating system administrator to increase the number of file descriptors .The suggested are values 2048, 4096, or unlimited. You can temporarily increase the number of file descriptors by running the ulimit -n command:

    ulimit -n 4096

2. Restart IDS after the file descriptor increase is implemented.

Note: If this does not resolve the problem then look for the Collecting Data document that will help you collect the correct troubleshooting data for a hang. After you collect this data contact technical support.

Also look at this document; Slow connect time to Informix when using TCP/IP

Related information

UNIX File-Descriptor Parameters
Database Server Connections Hang on Solaris

本日志由 flyinweb 于 2011-08-16 16:49:28 发表，目前已经被浏览 901 次，评论 0 次；

作者添加了以下标签： Connections to IDS hang，连接IDS挂起；

引用通告：http://www.517sou.net/Article/649/Trackback.ashx

评论订阅：http://www.517sou.net/Article/649/Feeds.ashx

评论列表

    暂时没有评论
(必填)
(必填，不会被公开)