> > To be honest, I don't know for sure exactly what the db2dia.log means
when
> > it said crash recovery took place. It may have only refer to a situation
> > when DB2 is activated in an inconsistent state, and not when an
application
> > crashes and rolls back to the last commit point.
> >
> "Gert van der Kooij" <gert@invalid.nl> wrote in message
> It clearly described in the manuals. Check the control center
> Concepts -> Administration -> Data recovery -> Crash recovery.
>
I looked in the DB2 Information Center (not Control Center) as you suggested
and it clearly includes that transaction failure and recovery (rolling back
updates that were not committed) are part of crash recovery (in addition to
re-starting a database in an inconsistent state).

But that does not necessarily mean that the db2dia.log logs transaction
failures and their rollbacks. It may only log crash recovery that happens
when the database is activated (as a result of a database or database
manager crash/forced shutdown). I simply don't know for certain.

But it is clear from the documentation that you referred to, that the
concept of crash recovery includes both database failures (where crash
recovery would take place when the database was re-activated) and
transaction failure (where un-committed transactions would be rolled back
immediately while DB2 was still running).