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:

1. Go to DB2 catalog
2. List the table (with qualifier) that you wish to see
3. Provide the command IC (“IMAGECOPY list”) against the DB2 table
4. You will see list of loads done for the DB2 table, with recent being on the top.
5. By displaying the latest row (provide command “S”), you will see the user id, job name, time stamp and more details.

——————————————————————————————————–

In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at: