Way to Find who creates the jobs ( 7.5.2)

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
ithirak_17
Participant
Posts: 17
Joined: Mon Sep 10, 2007 3:24 am

Way to Find who creates the jobs ( 7.5.2)

Post by ithirak_17 »

Is there any way we can find who created the datastage job in 7.5.2 Or which user modifed the datastge job? Please advice.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This information is stored in the DS_AUDIT.CREATOR column for the creator, and in the DS_AUDIT.MODIFIER column for the modifier. Note that MODIFIER is part of an association of multi-valued fields called MODS. I suggest you search DSXchange for examples of how to query DS_AUDIT.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

There is no documented means of determining that; but there is an undocument internal hashed file in each project called DS_AUDIT which contains that information.
Post Reply