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
 

 

To know activities on db2 tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ashek15

New User


Joined: 20 Oct 2015
Posts: 22
Location: USA

PostPosted: Fri Mar 03, 2017 11:23 pm    Post subject: To know activities on db2 tables
Reply with quote

Hi all

Can anybody tell how to find out when and how and who have inserted data in a given db2 table ? We have bmc catalog manager in our shop, but it shows there is no load job that ran and loaded data but table still has data.

Thanks.
Back to top
View user's profile Send private message

vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1474
Location: Chennai

PostPosted: Sat Mar 04, 2017 12:51 am    Post subject:
Reply with quote

Hello,
Do you have BMC LOG MASTER for DB2 along with your BMC catalog Manager.

If you have it then go to "Create Log Reports "

then mention the log filter criteria, time interval and output source. In the filter criteria you can mention the table name.

It would give you the information of what was done on that table in the mentioned timeframe, LOG master can also UNDO the changed made to the table.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 22
Location: USA

PostPosted: Sat Mar 04, 2017 1:33 am    Post subject: Reply to: To know activities on db2 tables
Reply with quote

We do not have log master. Is there any other way of finding thru mstr address space etc? ..I believe mstr will only list contention etc..but still asking
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1474
Location: Chennai

PostPosted: Sat Mar 04, 2017 4:20 am    Post subject:
Reply with quote

It is possible to get it from SMF, but you still would need MXG or MICS or some other similar software that processes SMF.
DB2ACCT - MXG dataset that has the number of SQL creates, deletes, inserts, updates information.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 22
Location: USA

PostPosted: Tue Mar 07, 2017 1:57 am    Post subject: Reply to: To know activities on db2 tables
Reply with quote

ok, Thanks. let me check on this..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    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 SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts ISPF Tables Creation newsysprg TSO/ISPF 6 Wed Jul 13, 2016 2:21 pm
No new posts New DB2 tables creation kishpra DB2 3 Tue Feb 02, 2016 7:00 pm


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