Hi all!!
Just curious to know-
If someone opens a job and saves without making any changes, can we by any chance know who has made the 'Save' ?
What in case of a job and in case of a shared container?
Because, in shared container we would not have logs stored
How do we know who mades the changes?
Moderators: chulett, rschirm, roy
How do we know who mades the changes?
Thanks and Regards!!
dspxlearn
dspxlearn
There is an audit trail loaded into the DataStage hashed file called DS_AUDIT; this does store information including which user saved a given job or container but it doesn't contain any details on what changes were made.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Modifications are actually in a nested table called DS_AUDIT_MODS. Search the forum for column names you can use to query DS_AUDIT, which you can do using DataStage/SQL, or a Hashed File or UniVerse stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
swades,
Ray's code was-
Can it be used for shared containers also?
I was using the below code for shared containers. I couldn't get any result...[/code]
Ray's code was-
Code: Select all
SELECT INSTANCE, DTM, MODIFIER, REASON
FROM DS_AUDIT
WHERE CLASS = '2' -- select only jobs
AND INSTANCE = '<<Job name>>'
AND DTM >= '<<yyyy-mm-dd>>'
WHEN DTM >= '<<yyyy-mm-dd>>'
Can it be used for shared containers also?
I was using the below code for shared containers. I couldn't get any result...
Code: Select all
SELECT INSTANCE, DTM, MODIFIER, REASON FROM DS_AUDIT
WHERE CLASS = '2'AND INSTANCE = 'sharedcont'
AND DTM >= '2007-05-07' WHEN DTM >= '2007-05-07';
Thanks and Regards!!
dspxlearn
dspxlearn
That would only work for objects called "sharedcont". Shared containers are actually in the class 24 so the original SQL wouldn't find them.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>