Wednesday , April 24 2024

How to extract DB2 audit logs into files


First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated.


Below command will archive Instance level activities.


Below command will archive database level activities.


Note: Do not delete the file created by command-line “db2audit archive”


About Syed Naveed Raza

I have experience to manage DB2 & Oracle plus 3 year of experience as Temenos T24 Core Administrator on AIX & IBM Integration Bus 10.

One comment

  1. Can we copy Archive audit log Binary file from AIX platform to Linux , and then using db2audit on linux to extract this fike to be ascii?

Leave a Reply

Your email address will not be published. Required fields are marked *