how can i view the db2 history log????

In db2 how can i see the db2 history log,, by code or in the control center,,,,,,,
i mean, if i do 3 inserts to de database and 5 uptades,,, how can i see this log,,, and when a trigger has been executed?????
italoestradaAsked:
Who is Participating?
 
momi_sabagCommented:
you can't
if you would like to see future activity, you can try to capture it using triggers or by implementing replication
if you want to see past activity you would need to buy a tool that can parse the log file
which platform are you using?
0
 
italoestradaAuthor Commented:
i only have the ibm db2 control center......
0
 
momi_sabagCommented:
so you can't view it
0
 
ghp7000Commented:
you can see all of this by activiting db2 auditing. Please refer to db2 documentation for explaantion of how to set it up, what can be audited and the overhead required to run the audit utility. Momo, you should know better.
0
 
italoestradaAuthor Commented:
Thanks for the answer....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.