Is there a way to Audit who cleared a table - iSeries...

DBohner-(db)

Legendary Poster
Howdy Campers,

This morning I received a wake-up call from some of my users, apparently on of their tables had been cleared (yup, it was empty).

I'm unaware of any applications / UBEs that could clear the table - so I'm not sure how it was cleared (I have suspects, but more unknowns)...

Is anyone aware of a process on the iSeries that allows us to audit, in some fashion, who (or what) might have cleared a table?

Thoughts - appreciated!

(db)
 
I think you can check your journals for that, but it's been awhile since I've dug in to DB2. Check out DSPJRN and go through there.
 
Az TFZ pointed out, you can check the journals...provided you have turned on journaling to capture system activity.
 
Back
Top