Page 1 of 1

Log files for datastage

Posted: Wed Apr 26, 2006 11:32 pm
by Abhijeet
Hi,

I wanna know does DSPX maintains a log about the changes done in its repository . EG: if i wanna know when was a job deleted from the repository , is there a log file with each entry .

Thanks.

Posted: Thu Apr 27, 2006 12:53 am
by ray.wurlod
The table is called DS_AUDIT. It is not explicitly exposed in client tools, but can be queried using the Administrator client Command window. To get a list of column names in this table either search the forum or execute the following command:

Code: Select all

LIST.DICT DS_AUDIT 
(anything with type "D" or type "I" is a column name).

Only the most recent deletion of a job is recorded.