Reg:Last committed transaction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sat - 31 Aug 2006 09:31 GMT

hi all!
Can anyone let me know how can we know what is the last
committed transaction and which application committed it?
what i found is like after we restore and rollforward it then
it is showing the last committed transaction.
but is there any command with we can find what is the last
committed transaction?

Thanks in Advance,
sat.

Reply to this Message

Knut Stolze - 31 Aug 2006 10:36 GMT

> hi all!
> Can anyone let me know how can we know what is the last
[quoted text clipped - 3 lines]
> but is there any command with we can find what is the last
> committed transaction?

Stupid question maybe, but what do you need that information for?

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Art S. Kagel - 31 Aug 2006 15:18 GMT

> hi all!
> Can anyone let me know how can we know what is the last
[quoted text clipped - 3 lines]
> but is there any command with we can find what is the last
> committed transaction?

See about the onlog utility in the Administrators Reference

Art S. Kagel

Reply to this Message

jefftyzzer - 31 Aug 2006 20:15 GMT

onlog? Are we talking about DB2 here or Informix?

> > hi all!
> > Can anyone let me know how can we know what is the last
[quoted text clipped - 7 lines]
>
> Art S. Kagel

Reply to this Message