RE: Help: onstat -u

Posted in 2000

Farmer, Byrd G - CFC — Wed, 19 Jan 2000 14:24:08 -0800 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF62CB.E7D271F8 Content-Type: text/plain; charset="iso-8859-1" We see the same thing in 7.3 when we do a "onstat -g sql". It seems to happen when we are running a stored procedure. All we can do is wait until the procedure completes and look again. -----Original Message----- From: Debbie Butler [mailto:dbutler@harland.net] Sent: Wednesday, January 19, 2000 10:26 AM To: informix-list@iiug.org Subject: Re: Help: onstat -u I have seen this on Sun Solaris 7.?? versions. It happens in the following 2 cases: 1)Bug hit in an early 7.x release (can't remember exactly) where client connections had machines with a hostname > 8 characters. For a Windows box this is the IDENTIFICATION Name of the machine in the TCP/IP setup. This was fixed in a later release and you could find the problem by looking at the SMIT tables. I think one of the views had a bad definition. (?? syscbllst???) 2)Running onbar and a logical log is backing up or the backup is hung for some reason. onbar updates the SMI tables and I have seen this when a logical log backup is hung or running a long time. Do a ps and grep for the backup. Hope this Helps Debbie Butler Art S. Kagel wrote in message <3884E35E.5CA3FD0C@bloomberg.net>... >Depending on the version of IDS you are using it is either just a VERY busy >server (unlikely if it almost always happens) or a bug in onstat that was >fixed in later versions. It usually helps to post platform and version >information. > >Art S. Kagel > >lily wrote: >> >> hi, all >> >> I meet a strange things. When I use the command 'onstat -u', at the end >> of the output, it doesn't give the maximum concurrent users number, it give >> such a line: >> >> ...... >> Changing data structure forced command termination. >> >> I'd like to know what cause it happen. >> >> Thanks in advance. >> >> lily ------_=_NextPart_001_01BF62CB.E7D271F8 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.2448.0"> <TITLE>RE: Help: onstat -u</TITLE> </HEAD> <BODY> We see the same thing in 7.3 when we do a = "onstat -g sql".  It seems to happen when we are running = a stored procedure.  All we can do is wait until the procedure = completes and look again. -----Original Message----- From: Debbie Butler [<A = HREF=3D"mailto:dbutler@harland.net">mailto:dbutler@harland.net</A>]</FON= T> Sent: Wednesday, January 19, 2000 10:26 AM To: informix-list@iiug.org Subject: Re: Help: onstat -u I have seen this on Sun Solaris 7.?? = versions.    It happens in the following 2 cases: 1)Bug hit in an early 7.x release (can't remember = exactly) where client connections had machines with a hostname > 8 = characters.  For a Windows box this is the IDENTIFICATION Name of the machine in = the TCP/IP setup.  This was fixed in a later release and you could find the = problem by looking at the SMIT tables.  I think one of the views had = a bad definition.  (?? syscbllst???) 2)Running onbar and a logical log is backing up or = the backup is hung for some reason.   onbar updates the SMI = tables and I have seen this when a logical log backup is hung or running a long = time.  Do a ps and grep for the backup. Hope this Helps Debbie Butler Art S. Kagel wrote in message = <3884E35E.5CA3FD0C@bloomberg.net>... >Depending on the version of IDS you are using it = is either just a VERY busy >server (unlikely if it almost always happens) or = a bug in onstat that was >fixed in later versions.  It usually helps = to post platform and version >information. > >Art S. Kagel > >lily wrote: >> >> hi, all >> >>     I meet a strange = things. When I use the command 'onstat -u', at the end >> of the output, it doesn't give the maximum = concurrent users number, it give >> such a line: >> >>     ...... >>     Changing data = structure forced command termination. >> >>     I'd like to know = what cause it happen. >> >>     Thanks in = advance. >> >> lily </BODY> </HTML> ------_=_NextPart_001_01BF62CB.E7D271F8--

RE: Help: onstat -u

Related threads

Your privacy choices