How to get the information about the Table updation

gvel19

Hi,

1) I want to know the time and date, on which a particular table was updated. Where does the information is stored and how to check it.

2)Suppose there is a job which updates a particular table was abended while uploading the records. Say a flat file has 250 records has to be loaded into a table. In which 100 record was uploaded and then because of duplicate record (i.e., 101 record) the job was abended
.
a.) Now how do I remove those 100 records which was uploaded earlier.
b.) How do I confirm that the first 100 records was uploaded successfully and how to find the duplicate record.

Thanks,
Velmurugan G