MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Finding when DB2 table was laste updated/inserted

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
Jimmy_Lu
Beginner


Joined: 23 Sep 2015
Posts: 9
Topics: 4

PostPosted: Mon Sep 28, 2015 1:59 am    Post subject: Finding when DB2 table was laste updated/inserted Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Mon Sep 28, 2015 10:14 am    Post subject: Reply with quote

Jimmy_Lu,

Please search before posting. Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=7563&highlight=audit
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Jimmy_Lu
Beginner


Joined: 23 Sep 2015
Posts: 9
Topics: 4

PostPosted: Mon Sep 28, 2015 10:34 am    Post subject: Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Mon Sep 28, 2015 11:56 am    Post subject: Reply with quote

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 - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group