A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
mandalea
Participant
Posts: 7 Joined: Sun Nov 13, 2005 5:56 am
Post
by mandalea » Wed Feb 09, 2011 4:21 pm
Hi,
As per my understanding 'DS_AUDIT' can be used to track audit information on datatstage job. However I have modified a job using 2 different user ids but none of this information ( DTM, MODFIER) is updated in DS_AUDIT. Am I missing some step? I have used following query to get the information. 'SELECT INSTANCE, DTM, MODIFIER , REASON FROM DS_AUDIT WHERE INSTANCE = <jobname>
Regards
Anand
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Feb 09, 2011 6:58 pm
That certainly was the place to check in the pre 8.x world, not so sure it can be counted on any longer. Perhaps there is an XMETA equivalent you can query?
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Feb 09, 2011 10:35 pm
They have stopped using DS_AUDIT. Definitely.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Feb 09, 2011 11:13 pm
OK, verified. Any idea if there is an XMETA equivalent or have they migrated that functionality elsewhere in the suite?
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Feb 10, 2011 3:52 am
Well, date/time modified is displayable and, indeed, searchable (Advanced Find) so presumably it's in XMETA somewhere!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
grasshopper
Participant
Posts: 10 Joined: Fri Jan 28, 2011 1:07 am
Location: Mumbai
Post
by grasshopper » Mon Sep 05, 2011 11:38 pm
does any one has more information about this? I am trying to enable the Audit trail and later get the details about who did what. If you can point me to the document or some link which shows how to enable audit trail, that would be great help.
Thank you
GH.
Thank you and Regards,
Soham
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Sep 06, 2011 5:20 am
The structures and models used in XMETA are deliberately undocumented.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
grasshopper
Participant
Posts: 10 Joined: Fri Jan 28, 2011 1:07 am
Location: Mumbai
Post
by grasshopper » Tue Sep 06, 2011 5:27 am
so it means there is no way to get the Audit trail for 8.x versions? Or it is something we have to explore on our own and get the data?
Thank you for you help so far.
Thank you and Regards,
Soham
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Sep 06, 2011 7:35 am
The latter. Unless, perhaps, your official support provider can provide the details?
-craig
"You can never have too many knives" -- Logan Nine Fingers