View previous topic :: View next topic |
Author |
Message |
Jimmy_Lu Beginner
Joined: 23 Sep 2015 Posts: 9 Topics: 4
|
Posted: Mon Sep 28, 2015 1:59 am Post subject: Finding when DB2 table was laste updated/inserted |
|
|
Hello All
Is there any way we can find out when the table was last updated or when last time records were inserted in that table.
These table don't have times tramp column nor any date column.
I am using below query to find out
Code: | SELECT * FROM SYSIBM.SYSTABLES
WHERE TSNAME = 'xxxx'
AND DBNAME = 'xxxxx'
FOR FETCH ONLY WITH UR; |
But problem with this query is it even shows when the table was last accessed and it doesn't tell if the tables gets updated outside of mainframe environment. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12358 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
Jimmy_Lu Beginner
Joined: 23 Sep 2015 Posts: 9 Topics: 4
|
Posted: Mon Sep 28, 2015 10:34 am Post subject: |
|
|
Great Thanks Kolusu !!!
Just one thought
Even when the tables are defined with AUDIT,will it identify the application
which is updating/accessing the table outside of mainframe environment
Like if the .Net application is accessing the table will it able to identify ? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12358 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|