DS_AUDIT not updated

mandalea · 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 · 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?

ray.wurlod · Post by **ray.wurlod** » Wed Feb 09, 2011 10:35 pm

They have stopped using DS_AUDIT. Definitely.

chulett · 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?

ray.wurlod · 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!

grasshopper · 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.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 06, 2011 5:20 am

The structures and models used in XMETA are deliberately undocumented.

grasshopper · 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.

chulett · Post by **chulett** » Tue Sep 06, 2011 7:35 am

The latter. Unless, perhaps, your official support provider can provide the details?