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”

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.

Leave a Reply