listener-thread: err = -25573: oserr = 72

IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- Up 3 days 04:39:41 -- 6209616 Kbytes OSLEVEL: AIX 6.1.0.0 Need any thoughts on this error we have received. Has anyone else received and diagnosed the problem/error? Is the Stack Trace a new standard for this version? 05:26:42 Maximum server connections 1364 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 83, Llog used 163 05:28:36 listener-thread: err = -25573: oserr = 72: errstr = : Network driver cannot accept a connection on the port. System error = 72. 05:31:27 listener-thread: err = -25573: oserr = 72: errstr = : Network driver cannot accept a connection on the port. System error = 72. 05:31:42 Checkpoint Completed: duration was 0 seconds. 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp: 0x244f5817 Interval: 511304 08:41:49 Checkpoint Completed: duration was 0 seconds. 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp: 0x247c3392 Interval: 511342 08:41:49 Maximum server connections 2026 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 1324, Llog used 9015 08:46:04 stack trace for pid 2719848 written to /ifmx_data/tmp/af.5ab7c50b 08:46:05 stack trace for pid 2953470 written to /ifmx_data/tmp/af.260f3 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d 08:46:08 stack trace for pid 3342440 written to /ifmx_data/tmp/af.5afac510 08:46:10 stack trace for pid 1409192 written to /ifmx_data/tmp/af.98dc511 08:46:49 Checkpoint Completed: duration was 0 seconds. 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp: 0x247dcf48 Interval: 511343 08:46:49 Maximum server connections 2026 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 2, Plog used 2173, Llog used 10780 Thanks, ******************************************************************************** ********** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you.

Original post: IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- Up 3 days 04:39:41 -- 6209616 Kbytes OSLEVEL: AIX 6.1.0.0 Need any thoughts on this error we have received. Has anyone else received and diagnosed the problem/error? Is the Stack Trace a new standard for this version? 05:26:42 Maximum server connections 1364 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 83, Llog used 163 05:28:36 listener-thread: err = -25573: oserr = 72: errstr = : Network driver cannot accept a connection on the port. System error = 72. 05:31:27 listener-thread: err = -25573: oserr = 72: errstr = : Network driver cannot accept a connection on the port. System error = 72. 05:31:42 Checkpoint Completed: duration was 0 seconds. 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp: 0x244f5817 Interval: 511304 08:41:49 Checkpoint Completed: duration was 0 seconds. 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp: 0x247c3392 Interval: 511342 08:41:49 Maximum server connections 2026 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 1324, Llog used 9015 08:46:04 stack trace for pid 2719848 written to /ifmx_data/tmp/af.5ab7c50b 08:46:05 stack trace for pid 2953470 written to /ifmx_data/tmp/af.260f3 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d 08:46:08 stack trace for pid 3342440 written to /ifmx_data/tmp/af.5afac510 08:46:10 stack trace for pid 1409192 written to /ifmx_data/tmp/af.98dc511 08:46:49 Checkpoint Completed: duration was 0 seconds. 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp: 0x247dcf48 Interval: 511343 08:46:49 Maximum server connections 2026 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 2, Plog used 2173, Llog used 10780 Thanks, ******************************************************************************** ********** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you. Response: The stack trace messages are likely from somebody running onmode -X s <virtual processor id>. It looks like somebody ran that command for several of your instances virtual processors. If you got some sort of data collection script from support, it will often include such a command. Jacques Renaut IBM Informix Advanced Support APD Team

This is usually a NIC or routing problem. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 23, 2013 at 10:40 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- Up > 3 > days 04:39:41 -- 6209616 Kbytes > OSLEVEL: AIX 6.1.0.0 > > Need any thoughts on this error we have received. Has anyone else received > and > diagnosed the problem/error? Is the Stack Trace a new standard for this > version? > > 05:26:42 Maximum server connections 1364 > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked > 1, > Plog used 83, Llog used 163 > > 05:28:36 listener-thread: err = -25573: oserr = 72: errstr = : Network > driver > cannot accept a connection on the port. > System error = 72. > 05:31:27 listener-thread: err = -25573: oserr = 72: errstr = : Network > driver > cannot accept a connection on the port. > System error = 72. > 05:31:42 Checkpoint Completed: duration was 0 seconds. > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp: > 0x244f5817 > Interval: 511304 > > 08:41:49 Checkpoint Completed: duration was 0 seconds. > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp: > 0x247c3392 > Interval: 511342 > > 08:41:49 Maximum server connections 2026 > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked > 1, > Plog used 1324, Llog used 9015 > > 08:46:04 stack trace for pid 2719848 written to /ifmx_data/tmp/af.5ab7c50b > 08:46:05 stack trace for pid 2953470 written to /ifmx_data/tmp/af.260f3 > 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b > 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d > 08:46:08 stack trace for pid 3342440 written to /ifmx_data/tmp/af.5afac510 > 08:46:10 stack trace for pid 1409192 written to /ifmx_data/tmp/af.98dc511 > 08:46:49 Checkpoint Completed: duration was 0 seconds. > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp: > 0x247dcf48 > Interval: 511343 > > 08:46:49 Maximum server connections 2026 > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked > 2, > Plog used 2173, Llog used 10780 > > Thanks, > > > ******************************************************************************** ********** > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance > Sears Holdings Management Corp > > This message, including any attachments, is the property of Sears Holdings > Corporation and/or one of its subsidiaries. It is confidential and may > contain > proprietary or legally privileged information. If you are not the intended > recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133b2d04835ce04e969f676

Can it be some type of port/network congestion on the local server, from re= mote/local servers? Is it an Informix database issue or just Informix knowing there is a networ= k issue? Could it be too many port connections (max) threshold being hit and Informi= x knows to stop new connections, until reduced to lower connections? Why does Informix know, but not the Network or System Admin. They can't se= e any issue, but Informix does? Is there a remedy or monitor for this and if so by Informix or others? Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement " Yes we can make a Change! " " IF you can think it, you can do it! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s. I will protect and value integrity. I will admit and quickly correct my mistakes. I will be a self-starter. I w= ill be a caring person. I will be a good listener with an open mind. I will continue to grow and learn. I will facilitate a= nd celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K= agel Sent: Wednesday, October 23, 2013 11:14 AM To: ids@iiug.org Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31789] This is usually a NIC or routing problem.=20 Art=20 Art S. Kagel, Principal Consultant=20 Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/=20 Disclaimer: Please keep in mind that my own opinions are my own opinions an= d do not reflect on my employer, Advanced DataTools, the IIUG, nor any othe= r organization with which I am associated either explicitly, implicitly, or= by inference. Neither do those opinions reflect those of other individuals= affiliated with any entity with which I am affiliated nor those of the ent= ities themselves.=20 On Wed, Oct 23, 2013 at 10:40 AM, Knox, Ernest <Ernest.Knox@searshc.com>wro= te:=20 > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim)=20 > -- Up > 3 > days 04:39:41 -- 6209616 Kbytes > OSLEVEL: AIX 6.1.0.0 >=20 > Need any thoughts on this error we have received. Has anyone else=20 > received and diagnosed the problem/error? Is the Stack Trace a new=20 > standard for this version? >=20 > 05:26:42 Maximum server connections 1364 > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > blocked 1, Plog used 83, Llog used 163 >=20 > 05:28:36 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : Netw= ork=20 > driver cannot accept a connection on the port. > System error =3D 72.=20 > 05:31:27 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : Netw= ork=20 > driver cannot accept a connection on the port. > System error =3D 72.=20 > 05:31:42 Checkpoint Completed: duration was 0 seconds.=20 > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp:=20 > 0x244f5817 > Interval: 511304 >=20 > 08:41:49 Checkpoint Completed: duration was 0 seconds.=20 > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp:=20 > 0x247c3392 > Interval: 511342 >=20 > 08:41:49 Maximum server connections 2026 > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > blocked 1, Plog used 1324, Llog used 9015 >=20 > 08:46:04 stack trace for pid 2719848 written to=20 > /ifmx_data/tmp/af.5ab7c50b > 08:46:05 stack trace for pid 2953470 written to=20 > /ifmx_data/tmp/af.260f3 > 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b > 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d > 08:46:08 stack trace for pid 3342440 written to=20 > /ifmx_data/tmp/af.5afac510 > 08:46:10 stack trace for pid 1409192 written to=20 > /ifmx_data/tmp/af.98dc511 > 08:46:49 Checkpoint Completed: duration was 0 seconds.=20 > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp:=20 > 0x247dcf48 > Interval: 511343 >=20 > 08:46:49 Maximum server connections 2026 > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > blocked 2, Plog used 2173, Llog used 10780 >=20 > Thanks, >=20 >=20 >=20 ***************************************************************************= ***************=20 > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance Sears=20 > Holdings Management Corp >=20 > This message, including any attachments, is the property of Sears=20 > Holdings Corporation and/or one of its subsidiaries. It is=20 > confidential and may contain proprietary or legally privileged=20 > information. If you are not the intended recipient, please delete it=20 > without reading the contents. Thank you. >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --001a1133b2d04835ce04e969f676=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

When it happens, if you try an "netstat -a" does it "hang"... When I write "hang", I mean small hangs, then a little more output, another hang etc...? If this happens you have DNS issues. It could also happen if the number of open files is not enough, but I think in most modern environments this would be hard to happen... unless your hard limits are tight. Regards On Wed, Oct 23, 2013 at 3:40 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- Up > 3 > days 04:39:41 -- 6209616 Kbytes > OSLEVEL: AIX 6.1.0.0 > > Need any thoughts on this error we have received. Has anyone else received > and > diagnosed the problem/error? Is the Stack Trace a new standard for this > version? > > 05:26:42 Maximum server connections 1364 > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked > 1, > Plog used 83, Llog used 163 > > 05:28:36 listener-thread: err = -25573: oserr = 72: errstr = : Network > driver > cannot accept a connection on the port. > System error = 72. > 05:31:27 listener-thread: err = -25573: oserr = 72: errstr = : Network > driver > cannot accept a connection on the port. > System error = 72. > 05:31:42 Checkpoint Completed: duration was 0 seconds. > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp: > 0x244f5817 > Interval: 511304 > > 08:41:49 Checkpoint Completed: duration was 0 seconds. > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp: > 0x247c3392 > Interval: 511342 > > 08:41:49 Maximum server connections 2026 > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked > 1, > Plog used 1324, Llog used 9015 > > 08:46:04 stack trace for pid 2719848 written to /ifmx_data/tmp/af.5ab7c50b > 08:46:05 stack trace for pid 2953470 written to /ifmx_data/tmp/af.260f3 > 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b > 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d > 08:46:08 stack trace for pid 3342440 written to /ifmx_data/tmp/af.5afac510 > 08:46:10 stack trace for pid 1409192 written to /ifmx_data/tmp/af.98dc511 > 08:46:49 Checkpoint Completed: duration was 0 seconds. > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp: > 0x247dcf48 > Interval: 511343 > > 08:46:49 Maximum server connections 2026 > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked > 2, > Plog used 2173, Llog used 10780 > > Thanks, > > > ******************************************************************************** ********** > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance > Sears Holdings Management Corp > > This message, including any attachments, is the property of Sears Holdings > Corporation and/or one of its subsidiaries. It is confidential and may > contain > proprietary or legally privileged information. If you are not the intended > recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --089e016339d8fee80b04e96a296d

It could have just been a momentary hiccup in the NIC that didn't express for long enough to be noticed by the OS monitoring but that caught a few Informix packets in transit. Does the problem persist or was it transitory? FWIW: As was mentioned, the stack traces were probably generated by the SYSALARMPROGRAM script. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 23, 2013 at 11:22 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > Can it be some type of port/network congestion on the local server, from > re= > mote/local servers? > Is it an Informix database issue or just Informix knowing there is a > networ= > k issue? > Could it be too many port connections (max) threshold being hit and > Informi= > x knows to stop new connections, until reduced to lower connections? > Why does Informix know, but not the Network or System Admin. They can't se= > e any issue, but Informix does? > > Is there a remedy or monitor for this and if so by Informix or others? > > Thanks, > > ***************************************************************************= > *************** > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance > Sears Holdings Management Corp > 3333 Beverly Rd. > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry:=A02244650553@messaging.sprintpcs.com > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > For more information, view our DBA Wiki page link below: > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= > t#DatabaseManagement > > " Yes we can make a Change! " > " IF you can think it, you can do it! " > " IT'S always a great day to watch=A0Sports: FOOTBALL " > GSU > MISSION: > " The focus of my life begins at home with family, loved ones, and > friends.= > I want to use my resources to create a > secure environment that fosters love, learning, laughter, and mutual > succes= > s. I will protect and value integrity. I > will admit and quickly correct my mistakes. I will be a self-starter. I w= > ill be a caring person. I will be a good listener > with an open mind. I will continue to grow and learn. I will facilitate a= > nd celebrate the success of others. " > > ***************************************************************************= > *************** > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art > K= > agel > Sent: Wednesday, October 23, 2013 11:14 AM > To: ids@iiug.org > Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31789] > > This is usually a NIC or routing problem.=20 > > Art=20 > > Art S. Kagel, Principal Consultant=20 > > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/=20 > > Disclaimer: Please keep in mind that my own opinions are my own opinions > an= > d do not reflect on my employer, Advanced DataTools, the IIUG, nor any > othe= > r organization with which I am associated either explicitly, implicitly, > or= > by inference. Neither do those opinions reflect those of other individuals= > affiliated with any entity with which I am affiliated nor those of the ent= > ities themselves.=20 > > On Wed, Oct 23, 2013 at 10:40 AM, Knox, Ernest <Ernest.Knox@searshc.com > >wro= > te:=20 > > > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim)=20 > > -- Up > > 3 > > days 04:39:41 -- 6209616 Kbytes > > OSLEVEL: AIX 6.1.0.0 > >=20 > > Need any thoughts on this error we have received. Has anyone else=20 > > received and diagnosed the problem/error? Is the Stack Trace a new=20 > > standard for this version? > >=20 > > 05:26:42 Maximum server connections 1364 > > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > > blocked 1, Plog used 83, Llog used 163 > >=20 > > 05:28:36 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : > Netw= > ork=20 > > driver cannot accept a connection on the port. > > System error =3D 72.=20 > > 05:31:27 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : > Netw= > ork=20 > > driver cannot accept a connection on the port. > > System error =3D 72.=20 > > 05:31:42 Checkpoint Completed: duration was 0 seconds.=20 > > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp:=20 > > 0x244f5817 > > Interval: 511304 > >=20 > > 08:41:49 Checkpoint Completed: duration was 0 seconds.=20 > > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp:=20 > > 0x247c3392 > > Interval: 511342 > >=20 > > 08:41:49 Maximum server connections 2026 > > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > > blocked 1, Plog used 1324, Llog used 9015 > >=20 > > 08:46:04 stack trace for pid 2719848 written to=20 > > /ifmx_data/tmp/af.5ab7c50b > > 08:46:05 stack trace for pid 2953470 written to=20 > > /ifmx_data/tmp/af.260f3 > > 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b > > 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d > > 08:46:08 stack trace for pid 3342440 written to=20 > > /ifmx_data/tmp/af.5afac510 > > 08:46:10 stack trace for pid 1409192 written to=20 > > /ifmx_data/tmp/af.98dc511 > > 08:46:49 Checkpoint Completed: duration was 0 seconds.=20 > > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp:=20 > > 0x247dcf48 > > Interval: 511343 > >=20 > > 08:46:49 Maximum server connections 2026 > > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > > blocked 2, Plog used 2173, Llog used 10780 > >=20 > > Thanks, > >=20 > >=20 > >=20 > > ***************************************************************************= > ***************=20 > > Ernie Knox > > Sr. Technical Specialist, I&TG - IT Operations & Governance Sears=20 > > Holdings Management Corp > >=20 > > This message, including any attachments, is the property of Sears=20 > > Holdings Corporation and/or one of its subsidiaries. It is=20 > > confidential and may contain proprietary or legally privileged=20 > > information. If you are not the intended recipient, please delete it=20 > > without reading the contents. Thank you. > >=20 > >=20 > >=20 > >=20 >@@NL

No hanging that I've noticed, but it clears up a few minutes later. Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement " Yes we can make a Change! " " IF you can think it, you can do it! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s. I will protect and value integrity. I will admit and quickly correct my mistakes. I will be a self-starter. I w= ill be a caring person. I will be a good listener with an open mind. I will continue to grow and learn. I will facilitate a= nd celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Ferna= ndo Nunes Sent: Wednesday, October 23, 2013 11:28 AM To: ids@iiug.org Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31791] When it happens, if you try an "netstat -a" does it "hang"... When I write = "hang", I mean small hangs, then a little more output, another hang etc...?= =20 If this happens you have DNS issues.=20 It could also happen if the number of open files is not enough, but I think= in most modern environments this would be hard to happen... unless your ha= rd limits are tight.=20 Regards=20 On Wed, Oct 23, 2013 at 3:40 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrot= e:=20 > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim)=20 > -- Up > 3 > days 04:39:41 -- 6209616 Kbytes > OSLEVEL: AIX 6.1.0.0 >=20 > Need any thoughts on this error we have received. Has anyone else=20 > received and diagnosed the problem/error? Is the Stack Trace a new=20 > standard for this version? >=20 > 05:26:42 Maximum server connections 1364 > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > blocked 1, Plog used 83, Llog used 163 >=20 > 05:28:36 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : Netw= ork=20 > driver cannot accept a connection on the port. > System error =3D 72.=20 > 05:31:27 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : Netw= ork=20 > driver cannot accept a connection on the port. > System error =3D 72.=20 > 05:31:42 Checkpoint Completed: duration was 0 seconds.=20 > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp:=20 > 0x244f5817 > Interval: 511304 >=20 > 08:41:49 Checkpoint Completed: duration was 0 seconds.=20 > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp:=20 > 0x247c3392 > Interval: 511342 >=20 > 08:41:49 Maximum server connections 2026 > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > blocked 1, Plog used 1324, Llog used 9015 >=20 > 08:46:04 stack trace for pid 2719848 written to=20 > /ifmx_data/tmp/af.5ab7c50b > 08:46:05 stack trace for pid 2953470 written to=20 > /ifmx_data/tmp/af.260f3 > 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b > 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d > 08:46:08 stack trace for pid 3342440 written to=20 > /ifmx_data/tmp/af.5afac510 > 08:46:10 stack trace for pid 1409192 written to=20 > /ifmx_data/tmp/af.98dc511 > 08:46:49 Checkpoint Completed: duration was 0 seconds.=20 > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp:=20 > 0x247dcf48 > Interval: 511343 >=20 > 08:46:49 Maximum server connections 2026 > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > blocked 2, Plog used 2173, Llog used 10780 >=20 > Thanks, >=20 >=20 >=20 ***************************************************************************= ***************=20 > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance Sears=20 > Holdings Management Corp >=20 > This message, including any attachments, is the property of Sears=20 > Holdings Corporation and/or one of its subsidiaries. It is=20 > confidential and may contain proprietary or legally privileged=20 > information. If you are not the intended recipient, please delete it=20 > without reading the contents. Thank you. >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 -- Fernando Nunes Portugal=20 http://informix-technology.blogspot.com My email works... but I don't check it frequently...=20 --089e016339d8fee80b04e96a296d=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

It would be interesting to see your $ONCONFIG parameters: MAX_INCOMPLETE_CONNECTIONS LISTEN_TIMEOUT There are also TCP/IP parameters (and probably monitoring commands) that define or show the "tcp backlog"... This would be the number of connection attempts in pending state on a certain TCP/IP port... If this are set too small and you have lot's of incoming connection attempts, new ones may be dropped... Regards On Wed, Oct 23, 2013 at 4:28 PM, Fernando Nunes <domusonline@gmail.com>wrote: > When it happens, if you try an "netstat -a" does it "hang"... When I write > "hang", I mean small hangs, then a little more output, another hang etc...? > If this happens you have DNS issues. > It could also happen if the number of open files is not enough, but I think > in most modern environments this would be hard to happen... unless your > hard limits are tight. > Regards > > On Wed, Oct 23, 2013 at 3:40 PM, Knox, Ernest <Ernest.Knox@searshc.com > >wrote: > > > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- > Up > > 3 > > days 04:39:41 -- 6209616 Kbytes > > OSLEVEL: AIX 6.1.0.0 > > > > Need any thoughts on this error we have received. Has anyone else > received > > and > > diagnosed the problem/error? Is the Stack Trace a new standard for this > > version? > > > > 05:26:42 Maximum server connections 1364 > > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns > blocked > > 1, > > Plog used 83, Llog used 163 > > > > 05:28:36 listener-thread: err = -25573: oserr = 72: errstr = : Network > > driver > > cannot accept a connection on the port. > > System error = 72. > > 05:31:27 listener-thread: err = -25573: oserr = 72: errstr = : Network > > driver > > cannot accept a connection on the port. > > System error = 72. > > 05:31:42 Checkpoint Completed: duration was 0 seconds. > > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp: > > 0x244f5817 > > Interval: 511304 > > > > 08:41:49 Checkpoint Completed: duration was 0 seconds. > > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp: > > 0x247c3392 > > Interval: 511342 > > > > 08:41:49 Maximum server connections 2026 > > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns > blocked > > 1, > > Plog used 1324, Llog used 9015 > > > > 08:46:04 stack trace for pid 2719848 written to > /ifmx_data/tmp/af.5ab7c50b > > 08:46:05 stack trace for pid 2953470 written to /ifmx_data/tmp/af.260f3 > > 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b > > 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d > > 08:46:08 stack trace for pid 3342440 written to > /ifmx_data/tmp/af.5afac510 > > 08:46:10 stack trace for pid 1409192 written to /ifmx_data/tmp/af.98dc511 > > 08:46:49 Checkpoint Completed: duration was 0 seconds. > > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp: > > 0x247dcf48 > > Interval: 511343 > > > > 08:46:49 Maximum server connections 2026 > > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns > blocked > > 2, > > Plog used 2173, Llog used 10780 > > > > Thanks, > > > > > > > > ******************************************************************************** ********** > > Ernie Knox > > Sr. Technical Specialist, I&TG - IT Operations & Governance > > Sears Holdings Management Corp > > > > This message, including any attachments, is the property of Sears > Holdings > > Corporation and/or one of its subsidiaries. It is confidential and may > > contain > > proprietary or legally privileged information. If you are not the > intended > > recipient, please delete it without reading the contents. Thank you. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --089e016339d8fee80b04e96a296d > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7bd6c5d049dab004e96a55d3

Ups... those stack traces mentioned... what do they contain? On Wed, Oct 23, 2013 at 4:32 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > No hanging that I've noticed, but it clears up a few minutes later. > > Thanks, > > ***************************************************************************= > *************** > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance > Sears Holdings Management Corp > 3333 Beverly Rd. > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry:=A02244650553@messaging.sprintpcs.com > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > For more information, view our DBA Wiki page link below: > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= > t#DatabaseManagement > > " Yes we can make a Change! " > " IF you can think it, you can do it! " > " IT'S always a great day to watch=A0Sports: FOOTBALL " > GSU > MISSION: > " The focus of my life begins at home with family, loved ones, and > friends.= > I want to use my resources to create a > secure environment that fosters love, learning, laughter, and mutual > succes= > s. I will protect and value integrity. I > will admit and quickly correct my mistakes. I will be a self-starter. I w= > ill be a caring person. I will be a good listener > with an open mind. I will continue to grow and learn. I will facilitate a= > nd celebrate the success of others. " > > ***************************************************************************= > *************** > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Ferna= > ndo Nunes > Sent: Wednesday, October 23, 2013 11:28 AM > To: ids@iiug.org > Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31791] > > When it happens, if you try an "netstat -a" does it "hang"... When I write > = > "hang", I mean small hangs, then a little more output, another hang > etc...?= > =20 > If this happens you have DNS issues.=20 > It could also happen if the number of open files is not enough, but I > think= > in most modern environments this would be hard to happen... unless your ha= > rd limits are tight.=20 > Regards=20 > > On Wed, Oct 23, 2013 at 3:40 PM, Knox, Ernest <Ernest.Knox@searshc.com > >wrot= > e:=20 > > > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim)=20 > > -- Up > > 3 > > days 04:39:41 -- 6209616 Kbytes > > OSLEVEL: AIX 6.1.0.0 > >=20 > > Need any thoughts on this error we have received. Has anyone else=20 > > received and diagnosed the problem/error? Is the Stack Trace a new=20 > > standard for this version? > >=20 > > 05:26:42 Maximum server connections 1364 > > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > > blocked 1, Plog used 83, Llog used 163 > >=20 > > 05:28:36 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : > Netw= > ork=20 > > driver cannot accept a connection on the port. > > System error =3D 72.=20 > > 05:31:27 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D : > Netw= > ork=20 > > driver cannot accept a connection on the port. > > System error =3D 72.=20 > > 05:31:42 Checkpoint Completed: duration was 0 seconds.=20 > > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp:=20 > > 0x244f5817 > > Interval: 511304 > >=20 > > 08:41:49 Checkpoint Completed: duration was 0 seconds.=20 > > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp:=20 > > 0x247c3392 > > Interval: 511342 > >=20 > > 08:41:49 Maximum server connections 2026 > > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > > blocked 1, Plog used 1324, Llog used 9015 > >=20 > > 08:46:04 stack trace for pid 2719848 written to=20 > > /ifmx_data/tmp/af.5ab7c50b > > 08:46:05 stack trace for pid 2953470 written to=20 > > /ifmx_data/tmp/af.260f3 > > 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b > > 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d > > 08:46:08 stack trace for pid 3342440 written to=20 > > /ifmx_data/tmp/af.5afac510 > > 08:46:10 stack trace for pid 1409192 written to=20 > > /ifmx_data/tmp/af.98dc511 > > 08:46:49 Checkpoint Completed: duration was 0 seconds.=20 > > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp:=20 > > 0x247dcf48 > > Interval: 511343 > >=20 > > 08:46:49 Maximum server connections 2026 > > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns=20 > > blocked 2, Plog used 2173, Llog used 10780 > >=20 > > Thanks, > >=20 > >=20 > >=20 > > ***************************************************************************= > ***************=20 > > Ernie Knox > > Sr. Technical Specialist, I&TG - IT Operations & Governance Sears=20 > > Holdings Management Corp > >=20 > > This message, including any attachments, is the property of Sears=20 > > Holdings Corporation and/or one of its subsidiaries. It is=20 > > confidential and may contain proprietary or legally privileged=20 > > information. If you are not the intended recipient, please delete it=20 > > without reading the contents. Thank you. > >=20 > >=20 > >=20 > >=20 > > ***************************************************************************= > ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > >=20 > >=20 > > -- > Fernando Nunes > Portugal=20 > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently...=20 > > --089e016339d8fee80b04e96a296d=20 > > > ***************************************************************************= > **** > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > This message, including any attachments, is the property of Sears Holdings > = > Corporation and/or one of its subsidiaries. It is confidential and may > cont= > ain proprietary or legally privileged information. If you are not the > inten= > ded recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c2c7da9c1a9604e96a584c

Original post: IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- Up 3 days 04:39:41 -- 6209616 Kbytes OSLEVEL: AIX 6.1.0.0 Need any thoughts on this error we have received. Has anyone else received and diagnosed the problem/error? Is the Stack Trace a new standard for this version? 05:26:42 Maximum server connections 1364 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 83, Llog used 163 05:28:36 listener-thread: err = -25573: oserr = 72: errstr = : Network driver cannot accept a connection on the port. System error = 72. 05:31:27 listener-thread: err = -25573: oserr = 72: errstr = : Network driver cannot accept a connection on the port. System error = 72. 05:31:42 Checkpoint Completed: duration was 0 seconds. 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp: 0x244f5817 Interval: 511304 08:41:49 Checkpoint Completed: duration was 0 seconds. 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp: 0x247c3392 Interval: 511342 08:41:49 Maximum server connections 2026 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 1324, Llog used 9015 08:46:04 stack trace for pid 2719848 written to /ifmx_data/tmp/af.5ab7c50b 08:46:05 stack trace for pid 2953470 written to /ifmx_data/tmp/af.260f3 08:46:06 stack trace for pid 925852 written to /ifmx_data/tmp/af.3627b 08:46:07 stack trace for pid 950412 written to /ifmx_data/tmp/af.4627d 08:46:08 stack trace for pid 3342440 written to /ifmx_data/tmp/af.5afac510 08:46:10 stack trace for pid 1409192 written to /ifmx_data/tmp/af.98dc511 08:46:49 Checkpoint Completed: duration was 0 seconds. 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp: 0x247dcf48 Interval: 511343 08:46:49 Maximum server connections 2026 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 2, Plog used 2173, Llog used 10780 Thanks, ******************************************************************************** ********** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you. Response: Ok, so if you are concerned about the listener thread error, then what it specifically means is this. The listener thread was trying to do the socket level accept call to, and the accept call returned error 72 which is ECONNABORTED, which would imply that before the server was able to complete the accept of the client, the client had shutdown their endpoint. So it's not a server problem at all, it's just reporting that a network connection couldn't be established because during the accept call the other side closed their end of the connection pair already. You can check the man page for accept() and then look for error 72 in /usr/include/errno.h and see that's it's ECONNABORTED. Jacques Renaut IBM Informix Advanced Support APD Team

:/usr/bin>onstat -c | grep MAX_INCOMPLETE_CONNECTIONS # MAX_INCOMPLETE_CONNECTIONS - The maximum number of incomplete MAX_INCOMPLETE_CONNECTIONS 1024 :/usr/bin>onstat -c | grep LISTEN_TIMEOUT # LISTEN_TIMEOUT - The number of seconds that IDS LISTEN_TIMEOUT 60 Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement " Yes we can make a Change! " " IF you can think it, you can do it! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s. I will protect and value integrity. I will admit and quickly correct my mistakes. I will be a self-starter. I w= ill be a caring person. I will be a good listener with an open mind. I will continue to grow and learn. I will facilitate a= nd celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Ferna= ndo Nunes Sent: Wednesday, October 23, 2013 11:40 AM To: ids@iiug.org Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31794] It would be interesting to see your $ONCONFIG parameters:=20 MAX_INCOMPLETE_CONNECTIONS LISTEN_TIMEOUT=20 There are also TCP/IP parameters (and probably monitoring commands) that de= fine or show the "tcp backlog"... This would be the number of connection at= tempts in pending state on a certain TCP/IP port... If this are set too sma= ll and you have lot's of incoming connection attempts, new ones may be drop= ped...=20 Regards=20 On Wed, Oct 23, 2013 at 4:28 PM, Fernando Nunes <domusonline@gmail.com>wrot= e:=20 > When it happens, if you try an "netstat -a" does it "hang"... When I=20 > write "hang", I mean small hangs, then a little more output, another hang= etc...? > If this happens you have DNS issues.=20 > It could also happen if the number of open files is not enough, but I=20 > think in most modern environments this would be hard to happen...=20 > unless your hard limits are tight. > Regards >=20 > On Wed, Oct 23, 2013 at 3:40 PM, Knox, Ernest <Ernest.Knox@searshc.com > >wrote:=20 >=20 > > IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim)=20 > > -- > Up > > 3 > > days 04:39:41 -- 6209616 Kbytes > > OSLEVEL: AIX 6.1.0.0 > >=20 > > Need any thoughts on this error we have received. Has anyone else > received > > and > > diagnosed the problem/error? Is the Stack Trace a new standard for=20 > > this version? > >=20 > > 05:26:42 Maximum server connections 1364 > > 05:26:42 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns > blocked > > 1, > > Plog used 83, Llog used 163 > >=20 > > 05:28:36 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D :=20 > > Network driver cannot accept a connection on the port. > > System error =3D 72.=20 > > 05:31:27 listener-thread: err =3D -25573: oserr =3D 72: errstr =3D :=20 > > Network driver cannot accept a connection on the port. > > System error =3D 72.=20 > > 05:31:42 Checkpoint Completed: duration was 0 seconds.=20 > > 05:31:42 Wed Oct 23 - loguniq 689987, logpos 0x70a018, timestamp:=20 > > 0x244f5817 > > Interval: 511304 > >=20 > > 08:41:49 Checkpoint Completed: duration was 0 seconds.=20 > > 08:41:49 Wed Oct 23 - loguniq 689990, logpos 0x80d8018, timestamp:=20 > > 0x247c3392 > > Interval: 511342 > >=20 > > 08:41:49 Maximum server connections 2026 > > 08:41:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns > blocked > > 1, > > Plog used 1324, Llog used 9015 > >=20 > > 08:46:04 stack trace for pid 2719848 written to > /ifmx_data/tmp/af.5ab7c50b > > 08:46:05 stack trace for pid 2953470 written to=20 > > /ifmx_data/tmp/af.260f3 > > 08:46:06 stack trace for pid 925852 written to=20 > > /ifmx_data/tmp/af.3627b > > 08:46:07 stack trace for pid 950412 written to=20 > > /ifmx_data/tmp/af.4627d > > 08:46:08 stack trace for pid 3342440 written to > /ifmx_data/tmp/af.5afac510 > > 08:46:10 stack trace for pid 1409192 written to=20 > > /ifmx_data/tmp/af.98dc511 > > 08:46:49 Checkpoint Completed: duration was 0 seconds.=20 > > 08:46:49 Wed Oct 23 - loguniq 689990, logpos 0xaaf1018, timestamp:=20 > > 0x247dcf48 > > Interval: 511343 > >=20 > > 08:46:49 Maximum server connections 2026 > > 08:46:49 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns > blocked > > 2, > > Plog used 2173, Llog used 10780 > >=20 > > Thanks, > >=20 > >=20 > >=20 >=20 >=20 ***************************************************************************= ***************=20 > > Ernie Knox > > Sr. Technical Specialist, I&TG - IT Operations & Governance Sears=20 > > Holdings Management Corp > >=20 > > This message, including any attachments, is the property of Sears > Holdings > > Corporation and/or one of its subsidiaries. It is confidential and=20 > > may contain proprietary or legally privileged information. If you=20 > > are not the > intended > > recipient, please delete it without reading the contents. Thank you.=20 > >=20 > >=20 > >=20 > >=20 >=20 >=20 ***************************************************************************= ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > >=20 > >=20 >=20 > -- > Fernando Nunes > Portugal >=20 > http://informix-technology.blogspot.com > My email works... but I don't check it frequently...=20 >=20 > --089e016339d8fee80b04e96a296d >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 -- Fernando Nunes Portugal=20 http://informix-technology.blogspot.com My email works... but I don't check it frequently...=20 --047d7bd6c5d049dab004e96a55d3=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the

Resolution to this type of problem also includes adding the remote (application) server to the local database servers' hosts file , and/or changing the order of host lookup in the hosts file; the disabling of DNS lookup when authentication was switched to local but not carried out properly.

Thanks everyone for your replies. Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement " Yes we can make a Change! " " IF you can think it, you can do it! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s. I will protect and value integrity. I will admit and quickly correct my mistakes. I will be a self-starter. I w= ill be a caring person. I will be a good listener with an open mind. I will continue to grow and learn. I will facilitate a= nd celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MARK = JALKIEWICZ Sent: Wednesday, October 23, 2013 1:59 PM To: ids@iiug.org Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31799] Resolution to this type of problem also includes adding the remote (application) server to the local database servers' hosts file , and/or cha= nging the order of host lookup in the hosts file; the disabling of DNS look= up when authentication was switched to local but not carried out properly.= =20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

Check /usr/include/errno.h and all files included from there, what is error 72 on your platform? David. On 23 October 2013 at 19:34 "Knox, Ernest" <Ernest.Knox@searshc.com> wrote: > Thanks everyone for your replies. > > Thanks, > ***************************************************************************= > *************** > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance > Sears Holdings Management Corp > 3333 Beverly Rd. > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry:=A02244650553@messaging.sprintpcs.com > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > For more information, view our DBA Wiki page link below: > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= > t#DatabaseManagement > > " Yes we can make a Change! " > " IF you can think it, you can do it! " > " IT'S always a great day to watch=A0Sports: FOOTBALL " > GSU > MISSION: > " The focus of my life begins at home with family, loved ones, and friends.= > I want to use my resources to create a > secure environment that fosters love, learning, laughter, and mutual succes= > s. I will protect and value integrity. I > will admit and quickly correct my mistakes. I will be a self-starter. I w= > ill be a caring person. I will be a good listener > with an open mind. I will continue to grow and learn. I will facilitate a= > nd celebrate the success of others. " > ***************************************************************************= > *************** > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MARK = > JALKIEWICZ > Sent: Wednesday, October 23, 2013 1:59 PM > To: ids@iiug.org > Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31799] > > Resolution to this type of problem also includes adding the remote > (application) server to the local database servers' hosts file , and/or cha= > nging the order of host lookup in the hosts file; the disabling of DNS look= > up when authentication was switched to local but not carried out properly.= > =20 > > ***************************************************************************= > **** > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > This message, including any attachments, is the property of Sears Holdings = > Corporation and/or one of its subsidiaries. It is confidential and may cont= > ain proprietary or legally privileged information. If you are not the inten= > ded recipient, please delete it without reading the contents. Thank you. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

On Linux errno 72 is: Multihop attempted On AIX errno 72 is: Software caused abort On Solaris errno 72 is: Locked lock was unmapped On HPUX errno 72 is: Value too large to store in data type On BSD errno 72 is: RPC struct is bad OS1 and MacOSX follow BSD convention Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 24, 2013 at 11:47 AM, david@smooth1.co.uk <david@smooth1.co.uk>wrote: > Check /usr/include/errno.h and all files included from there, what is > error 72 > on your platform? > > David. > > On 23 October 2013 at 19:34 "Knox, Ernest" <Ernest.Knox@searshc.com> > wrote: > > Thanks everyone for your replies. > > > > Thanks, > > > ***************************************************************************= > > *************** > > Ernie Knox > > Sr. Technical Specialist, I&TG - IT Operations & Governance > > Sears Holdings Management Corp > > 3333 Beverly Rd. > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry:=A02244650553@messaging.sprintpcs.com > > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > > > For more information, view our DBA Wiki page link below: > > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= > > t#DatabaseManagement > > > > " Yes we can make a Change! " > > " IF you can think it, you can do it! " > > " IT'S always a great day to watch=A0Sports: FOOTBALL " > > GSU > > MISSION: > > " The focus of my life begins at home with family, loved ones, and > friends.= > > I want to use my resources to create a > > secure environment that fosters love, learning, laughter, and mutual > succes= > > s. I will protect and value integrity. I > > will admit and quickly correct my mistakes. I will be a self-starter. I > w= > > ill be a caring person. I will be a good listener > > with an open mind. I will continue to grow and learn. I will facilitate > a= > > nd celebrate the success of others. " > > > ***************************************************************************= > > *************** > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > MARK = > > JALKIEWICZ > > Sent: Wednesday, October 23, 2013 1:59 PM > > To: ids@iiug.org > > Subject: Re: listener-thread: err =3D -25573: oserr =3D 72 [31799] > > > > Resolution to this type of problem also includes adding the remote > > (application) server to the local database servers' hosts file , and/or > cha= > > nging the order of host lookup in the hosts file; the disabling of DNS > look= > > up when authentication was switched to local but not carried out > properly.= > > =20 > > > > > ***************************************************************************= > > **** > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > > > This message, including any attachments, is the property of Sears > Holdings = > > Corporation and/or one of its subsidiaries. It is confidential and may > cont= > > ain proprietary or legally privileged information. If you are not the > inten= > > ded recipient, please delete it without reading the contents. Thank you. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3c9d85efc5f04e97f5dca