View previous topic :: View next topic
|
Author |
Message |
dappyin
New User
Joined: 23 Dec 2006 Posts: 2 Location: Gurgaon
|
|
|
|
Hi,
I am trying to figure out of it's possible to figure out when a record was added/updated into the table. I don't have any time stamp related field in the table.
Might be a wierd requirement but was just wondering if it's possible to figure it out. Based upon this I would be able to implement a solution for my problem.
Thanks!! |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
You've already alluded to the solution -- add a couple of columns to the table: updated_user and updated_timestamp. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you talk with your dba and ask about what is available via the db2 log. |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
1) Check with your DBA if there is any AUDIT table exists for the given table .
If there is AUDIT table exists for your base table , you can check when the rows were deleted and who did that .
or
2) you can follow the recommendation which was mentioned by dick in this thread |
|
Back to top |
|
|
|