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?????
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

momi_sabagConnect With a Mentor Commented:
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?
italoestradaAuthor Commented:
i only have the ibm db2 control center......
so you can't view it
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.
italoestradaAuthor Commented:
Thanks for the answer....
All Courses

From novice to tech pro — start learning today.