|
View previous topic :: View next topic
|
| Author |
Message |
Harry_harran
New User
.jpg)
Joined: 25 Nov 2009
Posts: 10
Location: India
|
|
|
|
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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
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
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 |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
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.  |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
why be sorry...
it was on Your own time 
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 |
|
| Back to top |
|
|
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
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 |
|
|
|
|
