HOW DO YOU FIND WHO HAS ACTUALLY LOADED THE DB2 TABLE RECENTLY
You are doing a DB2 testing. Next day you see that the data in the DB2 table that you are testing is replaced by some other data.
In BMC or FILE-AID for DB2:
- Go to DB2 catalog
- List the table (with qualifier) that you wish to see
- Provide the command IC (“IMAGECOPY list”) against the DB2 table
- You will see list of loads done for the DB2 table, with recent being on the top.
- By displaying the latest row (provide command “S”), you will see the user id, job name, time stamp and more details.