Maximum server connections 0

Posted in 2003

Topics: Storage & Space Management, Logging & Checkpoints

Li Jingjing-yeah — Mon, 17 Mar 2003 11:42:32 — source: IIUG Forums & Mailing Lists

Get following message in the online.log.All client can't connect to IDS. I found the "Maximum server connections 0" in the log file.So I thing the problem is related about the message. I search the problem in the internet,but I can't get solution. Give me a hand. Thank in advance. ============================================ 18:54:37 Physical Recovery Started at Page(3:2804). 18:54:37 Physical Recovery Complete: 0 Pages Examined 0 Pages Restored. 18:54:37 Logical Recovery Started. 18:54:37 20 recovery worker threads will be started. 18:54:41 Logical Recovery has reached the transaction cleanup phase. 18:54:41 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 18:54:42 Dataskip is now OFF for all dbspaces 18:54:42 Checkpoint Completed: duration was 0 seconds. 18:54:42 Checkpoint loguniq 7, logpos 0x2a018 18:54:42 Maximum server connections 0 18:54:42 On-Line Mode ============================================ Larry Li

↪ replying to Li Jingjing-yeah

Simmons, Keith — Mon, 17 Mar 2003 13:24:35 — source: IIUG Forums & Mailing Lists

Larry The Maximum Server Connections in the online log shows the maximum number of connections in use since the last checkpoint, not the maximum number of allowed connections. As you have just started your server has it been left in quiescent state of is it fully online? Are there any messages coming back from your client connection attempts? Keith -> -----Original Message----- -> From: Li Jingjing.... [mailto:lijingjing@yeah.net] -> Sent: Monday, March 17, 2003 11:43 AM -> To: ids@iiug.org -> Subject: Maximum server connections 0 [734] -> -> -> Get following message in the online.log.All client can't -> connect to IDS. -> I found the "Maximum server connections 0" in the log file.So I thing -> the problem is related about the message. I search the problem in the -> internet,but I can't get solution. Give me a hand. Thank in advance. -> -> ============================================ -> -> 18:54:37 Physical Recovery Started at Page(3:2804). -> 18:54:37 Physical Recovery Complete: 0 Pages Examined 0 -> Pages Restored. -> -> 18:54:37 Logical Recovery Started. -> 18:54:37 20 recovery worker threads will be started. -> 18:54:41 Logical Recovery has reached the transaction cleanup phase. -> 18:54:41 Logical Recovery Complete. -> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks -> -> 18:54:42 Dataskip is now OFF for all dbspaces -> 18:54:42 Checkpoint Completed: duration was 0 seconds. -> 18:54:42 Checkpoint loguniq 7, logpos 0x2a018 -> -> 18:54:42 Maximum server connections 0 -> 18:54:42 On-Line Mode -> -> ============================================ -> -> Larry Li -> -> -> -> -> -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

↪ replying to Li Jingjing-yeah

Martin Fuerderer — Mon, 17 Mar 2003 13:29:48 — source: IIUG Forums & Mailing Lists

Hi, online.log message log contains only messages from the server (not from any client). Since it obviously doesn't contain any error or warning message, but only shows normal operation, I guess you need to look at the client side for more information. Probably the client will produce some sort of error when it tries to connect. You need to get this error (code or message) to find out, what the problem is. Apart from the above, I can only guess, that you have some sort of configuration problem on the client side. Either they are trying to connect to a wrong server (check clients' sqlhosts file(s) and INFORMIXSERVER env variable setting), or they try to connect to the wrong machine (also sqlhosts file) or they are trying to use the wrong protocol (for which the server has no listener running, also check sqlhosts file). Otherwise you may have any kind of network issue. Anyway, the error code/message on the client side should give you a better clue of the problem. The "Maximum server connections 0" in the message log only tells you, that for the time the server has been running, the maximum number of connections (so far) has been zero, which means, that no client has connected yet. Well, for your case this is quite correct, as you have noticed this fact already. [ It doesn't mean that there is a (hard) limit of that many possible connects. ] Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "Li Jingjing...." <lijingjing@yeah.net> Sent by: forum.subscriber@iiug.org 17.03.2003 12:42 To: ids@iiug.org cc: Subject: Maximum server connections 0 [734] Get following message in the online.log.All client can't connect to IDS. I found the "Maximum server connections 0" in the log file.So I thing the problem is related about the message. I search the problem in the internet,but I can't get solution. Give me a hand. Thank in advance. ============================================ 18:54:37 Physical Recovery Started at Page(3:2804). 18:54:37 Physical Recovery Complete: 0 Pages Examined 0 Pages Restored. 18:54:37 Logical Recovery Started. 18:54:37 20 recovery worker threads will be started. 18:54:41 Logical Recovery has reached the transaction cleanup phase. 18:54:41 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 18:54:42 Dataskip is now OFF for all dbspaces 18:54:42 Checkpoint Completed: duration was 0 seconds. 18:54:42 Checkpoint loguniq 7, logpos 0x2a018 18:54:42 Maximum server connections 0 18:54:42 On-Line Mode ============================================ Larry Li

↪ replying to Li Jingjing-yeah

Laila H. Larsen — Mon, 17 Mar 2003 14:18:24 — source: IIUG Forums & Mailing Lists

Hi You have to luck for the problem in another place, the message only = show the maximum number off Connections to the IDS. In a given time , time =3D = beteen start IDS og stop IDS. The message appeart from IDS 9.30.xxx. M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F 33 - 959944 Denmark -----Oprindelig meddelelse----- Fra: Li Jingjing.... [mailto:lijingjing@yeah.net]=20 Sendt: 17. marts 2003 12:43 Til: ids@iiug.org Emne: Maximum server connections 0 [734]=20 Get following message in the online.log.All client can't connect to = IDS. I found the "Maximum server connections 0" in the log file.So I thing the problem is related about the message. I search the problem in the internet,but I can't get solution. Give me a hand. Thank in advance.=20 =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =20 18:54:37 Physical Recovery Started at Page(3:2804). 18:54:37 Physical Recovery Complete: 0 Pages Examined 0 Pages = Restored. =20 18:54:37 Logical Recovery Started. 18:54:37 20 recovery worker threads will be started. 18:54:41 Logical Recovery has reached the transaction cleanup phase. 18:54:41 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks =20 18:54:42 Dataskip is now OFF for all dbspaces 18:54:42 Checkpoint Completed: duration was 0 seconds. 18:54:42 Checkpoint loguniq 7, logpos 0x2a018 =20 18:54:42 Maximum server connections 0 18:54:42 On-Line Mode =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Larry Li=20 =20 =20 ------_=_NextPart_001_01C2EC8F.9E09DC40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2652.35"> <TITLE>SV: Maximum server connections 0 [734] </TITLE> </HEAD> <BODY> Hi You have to luck for the problem in another place, = the message only show the maximum number off Connections to the IDS. In = a given time , time =3D beteen start IDS og stop IDS. The message appeart from IDS 9.30.xxx. M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F 33 - 959944 Denmark -----Oprindelig meddelelse----- Fra: Li Jingjing.... [<A = HREF=3D"mailto:lijingjing@yeah.net">mailto:lijingjing@yeah.net</A>] = Sendt: 17. marts 2003 12:43 Til: ids@iiug.org Emne: Maximum server connections 0 [734] Get following message in the online.log.All client = can't connect to IDS. I found the "Maximum server connections = 0" in the log file.So I thing the problem is related about the = message. I search the problem in the internet,but I can't get solution. = Give me a hand. Thank in advance.   =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</F= ONT>   18:54:37  Physical Recovery Started at = Page(3:2804). 18:54:37  Physical Recovery Complete: 0 Pages = Examined 0 Pages Restored.   18:54:37  Logical Recovery Started. 18:54:37  20 recovery worker threads will be = started. 18:54:41  Logical Recovery has reached the = transaction cleanup phase. 18:54:41  Logical Recovery = Complete.           0 = Committed, 0 Rolled Back, 0 Open, 0 Bad Locks   18:54:42  Dataskip is now OFF for all = dbspaces 18:54:42  Checkpoint Completed:  duration = was 0 seconds. 18:54:42  Checkpoint loguniq 7, logpos = 0x2a018   18:54:42  Maximum server connections 0 18:54:42  On-Line Mode   =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</F= ONT> Larry Li     </BODY> </HTML> ------_=_NextPart_001_01C2EC8F.9E09DC40-- ------=_NextPartTM-000-60ffdd6b-b93b-40ea-9f1e-9a22ebdeca39--

↪ replying to Laila H. Larsen

Simmons, Keith — Mon, 17 Mar 2003 15:37:17 — source: IIUG Forums & Mailing Lists

***** PLEASE DON'T POST HTML ***** -> -----Original Message----- -> From: Laila H. Larsen [mailto:LHL@DJOEF.DK] -> Sent: Monday, March 17, 2003 2:18 PM -> To: ids@iiug.org -> Subject: SV: Maximum server connections 0 [738] -> -> <SNIPPED RUBBISH> -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

Maximum server connections 0

Related threads

Glossary

Your privacy choices