How to retrieve Cleared Log Entries.

ysrini9 · Post by **ysrini9** » Mon Jun 12, 2006 8:44 am

Hi All,

Accidentally someone cleared the dslog file entries.Could you please suggest me how to recover " Cleared Log Entries "

Regards
srini

ArndW · Post by **ArndW** » Mon Jun 12, 2006 9:09 am

You cannot, they are permanently gone.

p.s. I just cleared out several thousand jobs in development earlier today. You wouldn't happen to be working for a bank, would you?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 12, 2006 3:01 pm

If you have system backups you can recover. Restore RT_LOGnnn (a hashed file) so any location, and create a VOC pointer to it, with D_RT_LOG as the file dictionary pointer.

You now have whatever entries were backed up accessible. You can extract the entries using DataStage/SQL or even a DataStage job.

You can not, however, extract them using Director.

Do not even contemplate putting old entries back into the job log; the purge will have changed values in certain control records which renders this task impossible (without manually changing the control records).

ysrini9 · Post by **ysrini9** » Tue Jun 13, 2006 7:15 am

Is there a way to find out who has cleared the log ?

ArndW · Post by **ArndW** » Tue Jun 13, 2006 7:55 am

No, there is no way to find out who manually cleared a log or which process triggered an autopurge, this information is not part of the audit trail.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 13, 2006 3:17 pm

And even if there were, it would turn out to be dsapi_slave if initiated from a Director client.