RE: Constant online log errors on all servers
Posted in 2006
>> the problem started at exactly the same time on exactly the same day
on all 3.
So what was different about that time/day than the others?
Did some new process start running at that time?
Did a new user process start accessing one of the DBs at that time?
I think since your network admins won't help you, you may have to do
some sniffing yourself.
In your orig post you said changing the port number fixes it. maybe you
are getting some type of network flood on that port?
If you don't get other ideas, you might want to download ethereal from
w w w dot ethereal dot com. Snippet from the site:
Ethereal(r) is used by network professionals around the world for
troubleshooting, analysis, software and protocol development, and
education
759 protocols can currently be dissected.
Ethereal is Open Source software released under the GNU General Public
License.
Norma Jean Sebastian
ERP Support Administration
GIS- Enterprise Technical Services
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Neil Truby
Sent: Monday, November 27, 2006 5:37 PM
To: informix-list@iiug.org
Subject: Re: Constant online log errors on all servers
"Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> wrote in message
news:mailman.380.1164669679.29126.informix-list@iiug.org...
>> Poor you.... DB guy stuck in the middle.
Yes, poor me. And I get paid a pittance :-(
>> what does your sqlhost file look like, assume these errors are all
coming via network access versus shared mem?
What are you NETTYPE settings in ONCONFIG?
Yes, connections will be coming via tcp/ip. There are 3 servers, live,
the
one with the live HDR secondary, and a test one all affected (and the
problem started at exactly the same time on exactly the same day on all
3).
Here's the test one:
ifx_shm_11 onipcshm xxxtestdb01 dummy_11
appname_test_tcp onsoctcp xxxtestdb01 appname_test_tcp
appname_test_tcp_crap onsoctcp xxxtestdb01
appname_test_tcp_crap
(appname and the xxxs are substituted for something that might identify
the
customer's name). The _crap connection listens on a different port
number:
when it's the only tcp/ip connection enabled we don't get the problem.
NETTYPE ipcshm,1,50,CPU # Configure poll
thread(s)
for nettype
NETTYPE soctcp,2,200,NET # Configure poll
thread(s)
for nettype
rgds
Neil
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================