Re: default exit behaviour?

Hi, > ========== > comp.databases/informix #919, from mikehunt@algonet.se, 821 chars, 5 Dec 1994 11:32:43 +0 > ---------- > Article: 11797 of comp.databases.informix > Message-ID: <3buq8b$1nt@aristotle.algonet.se> > NNTP-Posting-Host: aristotle.algonet.se > X-Newsreader: TIN [version 1.2 PL2] > > Can anyone tell me what the default behaviour of the Online > database server is if its client has exitted without doing > a $close database or anything like that? Specifically, if > a $begin work has been done but no $commit or $rollback, what > does the database server do, commit or rollback? > > Mike. > Depends on the mode of the database but if logging is used and there was a beign with no commit and no close database then the engine will roll back the work when the session is terminated, you can try this on your port by a) run the dbaccess or isql program on the pc. b) isql script begin work; insert into table X values (1,2,3,4... ) c) on the server check it go there with dbaccess using a select after set isolation mode dirty read; d) just turn off the pc at the mains or re-boot e) check on the server if the process is gone if not then kil with tbmode -z f) on the server run the dbaccess again to see the reord has gone. hope this helps graham. G.K. Twaddle Technical Director Beta Computers (Europe) Ltd West of Scotland Science Park Maryhill Road Glasgow G20 OSP Scotland. tel 44-41-945-3855 beta@cix.compulink.co.uk { ask not what the net cn do for you but what you can do for the net }