IDS Forum

Re: Info require about COMMIT

Posted By: Madison Pruet
Date: Thursday, 8 May 2008, at 11:03 a.m.

In Response To: Info require about COMMIT (VIKAS HIVARKAR)

When you execute a statement which is not contained within an explicit
BEGIN WORK/COMMIT, then there is an implicit BEGIN WORK/COMMIT which is=

wrapped around that statement. So in your case, the operation is
equivalent to.

BEGIN WORK;
update emp
set ename=3D'vikas' where empid=3D2;
COMMIT WORK;

However, since you are using buffered logging, then you need to underst=
and
that the operation is not hardened until the log buffer flush occurs. =
A
checkpoint would cause a log flush.

-------------------------------------
Madison Pruet, STSM
IDS Replication Architect

=

"VIKAS HIVARKAR" =

<vikashivarkar3@g =

mail.com> =
To

Sent by: ids@iiug.org =

ids-bounces@iiug. =
cc

org =

Subj=
ect

Info require about COMMIT [1203=
9]

05/08/2008 09:37 =

AM =

=

=

Please respond to =

ids@iiug.org =

=

=

Hello,

Basic question about commit!

Informix version 11.10
database in Buffered login mode.

update emp
set ename=3D'vikas' where empid=3D2;

1 rows updated.

pls let me know as i have not started the sql with begin work neighter
ended
it with commit . will this transaction be commited in database .
now if a checkpoint is completed and this transaciton is written on to =
the
disk and then the database abruptly went down (power failure)then what =
will

happen to this transaction, will it be rolled forwar or rollback in fas=
t
recovery.

Does informix performs explicit commits if the "begin work" is not used=

do we have to mention "commit" in order to commit/complete the transcti=
on.

Thanking you all in advance !

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

• Info require about COMMIT
  VIKAS HIVARKAR -- Thursday, 8 May 2008, at 10:37 a.m.
  • Re: Info require about COMMIT
    Art Kagel -- Thursday, 8 May 2008, at 10:45 a.m.
    • Re: Info require about COMMIT
      VIKAS HIVARKAR -- Thursday, 8 May 2008, at 11:14 a.m.
      • Re: Info require about COMMIT
        Art Kagel -- Thursday, 8 May 2008, at 11:21 a.m.
        • Re: Info require about COMMIT
          VIKAS HIVARKAR -- Thursday, 8 May 2008, at 11:47 a.m.
          • Re: Info require about COMMIT
            Art Kagel -- Thursday, 8 May 2008, at 12:14 p.m.
  • Re: Info require about COMMIT
    Madison Pruet -- Thursday, 8 May 2008, at 11:03 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.