Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 2422
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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts Getting soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us