MVSFORUMS.com

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

Hi All -
After a long time.. I am back with a question.. Very Happy

.

Is it possible to get the userid or application name which updated a table in DB2 for a particular period ?

Thanks,
batu544
_________________
Regards,
batu

kolusu · Posted: Thu Aug 06, 2009 11:36 am Post subject:

batu544,

Create or ALTER the table with AUDIT ALL and set up the audit trace class. You can find all the activity on the table.

Kolusu

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

Thanks Kolusu for your reply.. but the table which I am talking about is a production table. and I am not sure whether the table has been created with this option.

One more point is, If I can alter the table with AUDIT ALL, then I can find all the activity which are done after that ...

Is there any other way .. ??

Thanks,
Batu
_________________
Regards,
batu

kolusu · Posted: Fri Aug 07, 2009 11:32 am Post subject:

batu544,

Unless you have auditing mechanism in place , I don't think you can find out the updates of the table.

Kolusu