Page 1 of 1
DS_AUDIT not updated
Posted: Wed Feb 09, 2011 4:21 pm
by mandalea
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
Posted: Wed Feb 09, 2011 6:58 pm
by chulett
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?
Posted: Wed Feb 09, 2011 10:35 pm
by ray.wurlod
They have stopped using DS_AUDIT. Definitely.
Posted: Wed Feb 09, 2011 11:13 pm
by chulett
OK, verified. Any idea if there is an XMETA equivalent or have they migrated that functionality elsewhere in the suite?
Posted: Thu Feb 10, 2011 3:52 am
by ray.wurlod
Well, date/time modified is displayable and, indeed, searchable (Advanced Find) so presumably it's in XMETA somewhere!
Posted: Mon Sep 05, 2011 11:38 pm
by grasshopper
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.
Posted: Tue Sep 06, 2011 5:20 am
by ray.wurlod
The structures and models used in XMETA are deliberately undocumented.
Posted: Tue Sep 06, 2011 5:27 am
by grasshopper
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.
Posted: Tue Sep 06, 2011 7:35 am
by chulett
The latter. Unless, perhaps, your official support provider can provide the details?