Last backup dates

psdsdev · Post by **psdsdev** » Tue Apr 01, 2008 6:21 am

HI,

Is it possible to know when the last backup was taken. I mean is there any provision to check when were the backups taken earlier and who did it?

Thanks

chulett · Post by **chulett** » Tue Apr 01, 2008 7:02 am

What backup would that be?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 01, 2008 5:02 pm

Whoever took the backup should have labelled the media and, ideally, made an entry in a system administration record.

psdsdev · Post by **psdsdev** » Wed Apr 02, 2008 1:05 am

My Question is

"If Some one has taken datastage back up (.dsx) yesterday, does the information like the username, timestamp will be stored any where? Where can i see the information about the backups that were taken"

Cr.Cezon · Post by **Cr.Cezon** » Wed Apr 02, 2008 1:38 am

no, I think this information isn't saved. But if you allways (for example) save the dsx in the same path you can see in the s.o.

the information of when a object have been imported or edit is saved in a uv file called DS_AUDIT.

regards,
Cristina

ray.wurlod · Post by **ray.wurlod** » Wed Apr 02, 2008 2:06 am

The Date and Time properties in the header of the export file will tell you when the export was initially taken. If the file has been appended to you will need to scan through it for a COMMENT that indicates the date/time of lines being appended.

No information is recorded about who took the backup (export), but the owner/creator property of the export file will strongly suggest a suspect.
Look on the Owner tab of the Advanced Security Properties dialog for the file.

sunayan_pal · Post by **sunayan_pal** » Wed Apr 02, 2008 3:02 am

Hi All,
can anyone please suggest weather DS_AUDIT will list the occurrence of the exported job from that project.
as import of the datastage object information is available.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 02, 2008 3:06 am

DS_AUDIT does not report backups, only creation, modification and deletion of objects/components.

If a previously-existing object is overwritten from an import, it has its PREVDTD and PREVDELETOR then DTC and CREATOR information updated in DS_AUDIT.