Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Can we tell what updated a table?

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
satyapn9

New User


Joined: 08 Oct 2010
Posts: 27
Location: India

PostPosted: Tue Mar 27, 2012 4:17 pm    Post subject: Can we tell what updated a table?
Reply with quote

Hi,

Is there a way we can find out which job/process/person last updated a table looking at system tables or something in DB2?

In IBM-DB2 System Catalog, we can see only the IMAGE COPY Job/Process.

Can someone help in this please?
Back to top
View user's profile Send private message

Parthiban DS

New User


Joined: 07 Aug 2011
Posts: 5
Location: India

PostPosted: Tue Mar 27, 2012 5:09 pm    Post subject:
Reply with quote

Look into SYSCOPY table.

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2.doc.sqlref%2Fzcopy.htm
Back to top
View user's profile Send private message
satyapn9

New User


Joined: 08 Oct 2010
Posts: 27
Location: India

PostPosted: Mon Feb 11, 2013 8:24 pm    Post subject: Can we tell what updated a table?
Reply with quote

Hello, This might be very delayed reply to this question. But I do not see a direct/quick solution posted for this.


Yes, you can see the table details in IBM-DB2 System Catalog using below options:
1) Select a table using T option
2) Give a command "I" against the table and this brings you the details of table "DB2P Interpretation of an Object in SYSTABLES". It will have a lot more details.

Also you can query SYSIBM.SYSTABLES for this type of information.
Back to top
View user's profile Send private message
Binop B

Active User


Joined: 18 Jun 2009
Posts: 407
Location: Nashville, TN

PostPosted: Mon Feb 11, 2013 9:51 pm    Post subject:
Reply with quote

Sorry... I could't stop myself from replying to this post... Did Mr. Satya Prasad reply to his own question which he posted almost a year ago... icon_smile.gif

This is the first time am seeing something like that... icon_wink.gif
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Feb 13, 2013 10:33 am    Post subject:
Reply with quote

Binop B wrote:
Sorry... I could't stop myself from replying to this post... Did Mr. Satya Prasad reply to his own question which he posted almost a year ago... icon_smile.gif

This is the first time am seeing something like that... icon_wink.gif


icon_biggrin.gif

Satya did not understand his own question.

You need to read DB2 Logs, Tools like CA Log Analyzer will help you get that information.

Regards,
Sushanth
Back to top
View user's profile Send private message
razesh84

New User


Joined: 05 Apr 2010
Posts: 41
Location: Kolkata,India

PostPosted: Thu Feb 14, 2013 3:07 pm    Post subject:
Reply with quote

I once tracked some records which were accidentally created & then deleted few days after by some users.

Well I used CA Log analyser but there also I only found Plan name for Online programs.I did not find any User ids there.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2442
Location: Netherlands, Amstelveen

PostPosted: Thu Feb 14, 2013 3:20 pm    Post subject:
Reply with quote

Ask your DB2 administrator if SMF is activated for DB2. Record types 100,101,102. If yes, see IBM DB2 Administration Guide for these record types.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us