Log files for datastage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Abhijeet
Participant
Posts: 20
Joined: Wed Jul 27, 2005 1:00 am

Log files for datastage

Post 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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply