Yes, event monitor output.
Thanks for the info!

-----Original Message-----
From: Alex Levy [mailto:db2udbdba-ezmlmshield-x23295312.[Email address protected]
Sent: Tuesday, April 15, 2008 12:47 PM
To: LazyDBA Discussion
Subject: RE: Static ROllback

You can get a rollback from an explicit SQL request, or from a deadlock, a
force applications or an error.
As far as I can tell, the stmt_operation (snapshot) and operation (event
monitor) monitor elements only apply to SQL commits and rollbacks and both
call these 'STATIC COMMIT' and 'STATIC ROLLBACK'.
We'll have to assume those names are applied consistently (a big assumption)
- do you see the "static" rollbacks referenced anywhere outside the DB2
system monitor?

Regards
Alex Levy
Sustainable Software Ltd.

PS 'Is DB2 Dead?' - Fascinating blog from Scott Hayes on
http://www.ibmdatabasemag.com/bog/main/archives/2008/03/db2_luw_perform_22.h
tml


> -----Original Message-----
> From: Terry Gilbert
> [mailto:db2udbdba-ezmlmshield-x45123335.[Email address protected]
> Sent: 15 April 2008 15:49
> To: LazyDBA Discussion
> Subject: Static ROllback
>
> DB2 noob here... I did search on the forum first.
>
> Is there particular significance to the term "static" in
> "static rollback"? Is it a special, or default case of rollback?
>
> TIA
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
> E-mail message checked by Spyware Doctor (5.5.0.212) Database
> version: 5.09630 http://www.pctools.com/en/spyware-doctor/





E-mail message checked by Spyware Doctor (5.5.0.212)
Database version: 5.09630
http://www.pctools.com/en/spyware-doctor/


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page