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
 
DB2 -how to find the last updated user of a table

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

New User


Joined: 25 Nov 2009
Posts: 10
Location: India

PostPosted: Wed Oct 24, 2012 9:47 am    Post subject: DB2 -how to find the last updated user of a table
Reply with quote

I have to find who updated the table lastly.
How to find that through BMCADM.
Also i have to find which are the plans thats updates/inserts/deletes/selects the corresponding table.

Could you please help me out to find this?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Oct 24, 2012 6:45 pm    Post subject:
Reply with quote

Hello,

As far as i know, this would have to be recorded by some kind of auditing built into the system.

This kind of info is available via the db2 logs, but i would not recommend trying to look thru these backwards until the first activity for the table of interest is found. . .

You might ask BMC support if they have a suggestion.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Wed Oct 24, 2012 7:34 pm    Post subject: Reply to: DB2 -how to find the last updated user of a table
Reply with quote

Quote:
How to find that through BMCADM.


read the BMCADM manuals
no reason for us to do the reading and the rewriting of a BMC manual
icon_cool.gif


to make the most out of the questions You ask it would be wise for You
to meditate on
How To Ask Questions The Smart Way
http://catb.org/~esr/faqs/smart-questions.html

quoting from the linked document

Quote:
Q:

How can I use X to do Y?

A:

If what you want is to do Y, you should ask that question without pre-supposing the use of a method that may not be appropriate. Questions of this form often indicate a person who is not merely ignorant about X, but confused about what problem Y they are solving and too fixated on the details of their particular situation. It is generally best to ignore such people until they define their problem better.
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Wed Oct 24, 2012 8:27 pm    Post subject:
Reply with quote

Hi Harry,

BMCADM refers to BMC Catlog Manager?

If you want to know who loaded the table and you've BMC Catlog Manager, bring up the table in TABLE LIST panel and issue IC as line command against that table; so that you can see the details about the load.

Also, IC command gives you the below information as well if applicable on that table.

Code:
A   Alter                             
B   Rebuild Index                     
D   Check Data Log(No)                 
F   Copy Full Yes                     
I   Copy Full No                       
P   Recover ToCopy or Recover ToRBA   
Q   Quiesce                           
R   Load Replace Log(Yes)             
S   Load Replace Log(No)               
T   Term Utility command               
W   Reorg Log(No)                     
X   Reorg Log(Yes)                     
Y   Load Log(No)                       
Z   Load Log(Yes)


Quote:
I have to find who updated the table lastly.

I think, the row updates/deletes are not shown directly in BMC catlog manager. Again, BMC Catlog Manager is a user interface to DB2 system catlogs.

Quote:
Also i have to find which are the plans thats updates/inserts/deletes/selects the corresponding table.

With BMC Catlog Manager, bring up your table to TABLE LIST panel and issue PA as line command against the table which will get you "TABLE AUTHS FOR PLANS AND PACKAGES LIST" panel; there you can see the plans/packages which are referring your table. Just press a couple of PF11... and look for the values of below columns.

Code:
DELETEAUTH INSERTAUTH SELECTAUTH UPDATEAUTH


Please get back to us with your results. Thank you.

Quote:
no reason for us to do the reading and the rewriting of a BMC manual
Sorry, Enrico. Hope TS will start reading the manual if he has further questions. icon_smile.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Wed Oct 24, 2012 8:34 pm    Post subject: Reply to: DB2 -how to find the last updated user of a table
Reply with quote

why be sorry...
it was on Your own time icon_wink.gif

if You are happy, I am happy, everybody is happy
and the TS got somebody else to do the job for which he gets paid icon_cool.gif
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Oct 25, 2012 11:51 am    Post subject:
Reply with quote

why not add a column to the table - Row change timestamp - Provided you have Db2 v 9.

To find
Quote:
Also i have to find which are the plans thats updates/inserts/deletes/selects the corresponding table.


You can query SYSIBM.SYSTABAUTH table to get what packages have what privilege on tables/views.
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 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 User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 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

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