| 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: 12378
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: 12378
Topics: 75
Location: San Jose
|
| Posted: Mon Sep 28, 2015 11:56 am Post subject: |
|
|
| Jimmy_Lu wrote: | 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 ? |
Yes, every single action is logged.
You may want to read the following red books for more information
Securing and Auditing Data on DB2 for z/OS
Security Functions of IBM DB2 10 for z/OS
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
