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: 2459
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 Facing Issue in Table Reorg satish.ms10 DB2 1 Tue Aug 07, 2018 2:44 am
No new posts SQL IN predicate using COBOL table jerryte DB2 16 Fri Jun 29, 2018 10:30 pm
No new posts Extracting DDL for all list of intere... Ashishpanpaliya DB2 5 Mon May 21, 2018 4:08 pm
No new posts Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm

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