I'm using db2 udb v7.2 on NT and
when I open log file I can't read it clearly.

what's the problem?
what I wrong?

Which log file are you talking about? If it is db2diag.log try opening with MS Wordpad.

The files under SQLOGDIR folder.
For example S0000000.LOG.

Those are the log files that are used for DB2 recovery. They are for internal use by DB2 and are not meant to be read in text format.

Thank you for your reply.
My problem is where i can read transactions on db?

Unless you log changes yourself to another table (perhaps with a trigger), you can't easily see the before or after images on the log. There may be some 3rd party tools that can read the log. I would check with BMC Software for starters.

Going forward, you might be able to use a monitor or trace to track transactions that have run and the SQL statements, but I am not sure what information you want (name of transaction, SQL statements, or actual changes to the data).

u can not read it

I think that you can read the statement of your applications with
db2 get snapshot for dynamic sql on ...

I'm having the problem here. I need to read the SQL Statements that have just been executed in the DB2.

I have ran the 'db2 get snapshot for dynamic sql on ...' but it seens that the information he returned is not cronologicaly ordered.

Is there a way to have this statement ordered cronologicaly?

Try event monitor for statements