Maximum Server Connections

Posted in 2004

Topics: Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life

Jane Vohden — Fri, 14 May 2004 04:07:37 — source: IIUG Forums & Mailing Lists

Today we experienced an odd problem. The 51st person to access the database would get the following message: The appl process cannot connect to the database server dev. (Error -25588, ISAM8 Up until that 51st user, everything was running fine. When user connections went back down to 50 we were fine again. The 25588 error message says: An error in the application can produce this message. Check your CONNECT statement and the sqlhosts file. A system failure can also produce this message. If you can find no immediate cause for the failure, note the circumstances and contact your database server administrator for assistance. The shared memory communication subsystem is down or not functioning. Contact the database server administrator to report the problem. We are working with the vendor that maintains the software and they haven't come up with a resolution yet. I've been trying different onconfig parameter settings all night and haven't come up with anything either. I've spent the most time playing with NETTYPE. Until today I didn't even have NETTYPE defined in my onconfig. I have 3 different instances of IDS and they all are manifesting this same problem. I have attached the onconfig file if that will help. I appreciate any ideas anyone can give me. Thank you. Jane Vohden Database Administrator jvohden@co.fairbanks.ak.us HP-UX 11, IDS 9.30.hc1

↪ replying to Jane Vohden

Mark Scranton — Fri, 14 May 2004 14:49:41 — source: IIUG Forums & Mailing Lists

--0__=08BBE407DFC377148f9e8a93df938690918c08BBE407DFC37714 Content-type: multipart/alternative; Boundary="1__=08BBE407DFC377148f9e8a93df938690918c08BBE407DFC37714" --1__=08BBE407DFC377148f9e8a93df938690918c08BBE407DFC37714 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable The default max number of connections for SHM is 50 if you don't adjust/increase it with NETTYPE. This is why the 51st user is failing, = but 50 is fine. Let me know if this doesn't help. I didn't see the onconfig attached, btw. What are some of the NETTYPE settings you tried? HTH - Mark. Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Cell: 303-929-0914 email: mscranto@us.ibm.com = "Jane Vohden " = <jvohden@co.fairb = anks.ak.us> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect Maximum Server Connections [2961= ] 05/13/2004 10:07 = PM = = = = = Today we experienced an odd problem. The 51st person to access the database would get the following message= : The appl process cannot connect to the database server dev. (Error -25588, ISAM8 Up until that 51st user, everything was running fine. When user connect= ions went back down to 50 we were fine again. The 25588 error message says: An error in the application can produce this message. Check your CONNECT statement and the sqlhosts file. A system failure can also produce this message. If you can find no immediate cause for the failure, note the circumstances and contact your database server administrator for assistance. The shared memory communication subsystem is down or not functioning. Contact the database server administrator to report the problem. We are working with the vendor that maintains the software and they hav= en't come up with a resolution yet. I've been trying different onconfig parameter settings all night and haven't come up with anything either. I've spent the most time playing with NETTYPE. Until today I didn't even ha= ve NETTYPE defined in my onconfig. I have 3 different instances of IDS an= d they all are manifesting this same problem. I have attached the oncon= fig file if that will help. I appreciate any ideas anyone can give me. Thank you. Jane Vohden Database Administrator jvohden@co.fairbanks.ak.us HP-UX 11, IDS 9.30.hc1 = --1__=08BBE407DFC377148f9e8a93df938690918c08BBE407DFC37714 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> The default max number of connections for SHM is 50 if you don't adj= ust/increase it with NETTYPE. This is why the 51st user is failing, but= 50 is fine. Let me know if this doesn't help. I didn't see the onconfig attached, btw. What are some of the NETTYPE s= ettings you tried? HTH - Mark. Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Cell: 303-929-0914 email: mscranto@us.ibm.com <img src=3D"cid:10__=3D08BBE407DFC377148f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Jane Vohden &= quot; <jvohden@co.fairbanks.ak.us>">"Jane Vohden " <= jvohden@co.fairbanks.ak.us> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE40= 7DFC377148f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>"Jane Vohden " <jvohden@co.fairban= ks.ak.us> Sent by: forum.subscriber@iiug.org 05/13/2004 10:07 PM</ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE407DFC377148f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">To</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE407DFC377148f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> ids@iiug.org</td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE407DFC377148f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">cc</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE407DFC377148f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE407DFC377148f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">Subject</div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D08BBE407DFC377148f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> Maximum Server Connections [2961]</td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE407DFC3= 77148f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE407DFC377148f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <tt> Today we experienced an odd problem. The 51st person to access the database would get the following message= : The appl process cannot connect to the database server dev. (Error -25588, ISAM8   Up until that 51st user, everything was running fine. When user connect= ions went back down to 50 we were fine again. The 25588 error message says: An error in the application can produce this message. Ch

↪ replying to Jane Vohden

paul@oninit.com — Sat, 15 May 2004 09:34:38 — source: IIUG Forums & Mailing Lists

You are probably defaulting to 50 user (standard SHM setting) or else the vendor has done something clever in the app Jane Vohden wrote: > > Today we experienced an odd problem. > > The 51st person to access the database would get the following message: > > The appl process cannot connect to the database server dev. > (Error -25588, ISAM8 > > Up until that 51st user, everything was running fine. When user connections > went back down to 50 we were fine again. > > The 25588 error message says: > An error in the application can produce this message. Check your > CONNECT statement and the sqlhosts file. A system failure can also > produce this message. If you can find no immediate cause for the > failure, note the circumstances and contact your database server > administrator for assistance. > > The shared memory communication subsystem is down or not functioning. > Contact the database server administrator to report the problem. > > We are working with the vendor that maintains the software and they haven't > come up with a resolution yet. I've been trying different onconfig > parameter settings all night and haven't come up with anything either. I've > spent the most time playing with NETTYPE. Until today I didn't even have > NETTYPE defined in my onconfig. I have 3 different instances of IDS and > they all are manifesting this same problem. I have attached the onconfig > file if that will help. > > I appreciate any ideas anyone can give me. > Thank you. > Jane Vohden > Database Administrator > jvohden@co.fairbanks.ak.us > HP-UX 11, IDS 9.30.hc1 -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

Maximum Server Connections

Related threads

Glossary

Your privacy choices