Re: Logging off a database

Posted in 1993

bernier@netmanager.dotc.gov.au — Mon, 20 Sep 93 09:55:32 PDT — source: Informix-list mailing list archive (1991-1998)

In article <92660002@hpwad.wad.hp.com>, <ulil@hpwad.wad.hp.com> writes: > From: ulil@hpwad.wad.hp.com (Ulrich Liebig) > Date: Fri, 17 Sep 1993 11:05:51 GMT > Subject: Re: Logging off a database > Message-ID: <92660002@hpwad.wad.hp.com> > Organization: Hewlett-Packard Waldbronn, Germany > Path: netmanager-2.dotc.gov.au!newshost.anu.edu.au!munnari.oz.au!news.Hawaii.Edu!ames!elroy.j pl.nasa.gov!sdd.hp.com!col.hp.com!news.dtc.hp.com!hpscit.sc.hp.com!hplextra!hpcc05!hpbb n!hpwad!ulil > Newsgroups: comp.databases.informix > References: <92660001@hpwad.wad.hp.com> > Lines: 42 > > Thank you for responding on that misleading message . > > Details are: > > After calling LOGOUT or CLOSEDATABASE functions the current database > will not disconnect DataLink when a remote database is opened. > > After trying to loggout sqlexec process on the server isn't present anymore. > > The following processlist items are present for the current > session on client machine. > > > PID TTY TIME COMMAND > 9819 ttys2 0:07 Wingz > 9822 ttys2 0:00 engine > 9825 ttys2 0:00 sqlexec > > There is no process activity beloging to the above processes. > The client is showing only the hourglass. > > > Connected or disconnect DataLink with a local installed database is > no problem. > > The same problem occurs with Online on the server an I-Star installed there. > > > Thank you in advance. > > -- > > +----------------------------------------------------------------------------+ > | _ ___ | ADDRESS: Hewlett Packard GmbH | > | \\ / / \\ | \\ | Hewlett Packard Str. | > | \\ _ / /___\\ | | | Attn to: Ulrich Liebig (APE) | > | \\/ \\/ / \\ |___/ | 76337 Waldbronn | > | Waldbronn Analytical Division | Germany | > | APE Application and Process | PHONE: 49-7243-602-489 | > | Engineering | HPDESK: | > | | e-mail ulil@hpbbn.bbn.hp.com | > +----------------------------------------------------------------------------+ Ulrich What does db:dbstate() return when you process the logout() call? From what you have indicated I see no reason why the logout process would not complete. regards bernie ryan canberra, australia bernier@netmanager.dotc.gov.au