|
View previous topic :: View next topic
|
| Author |
Message |
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
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 |
|
 |
vasanthz
Global Moderator
Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India
|
|
|
|
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 |
|
|
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
| 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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India
|
|
|
|
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 |
|
|
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
| ok, Thanks. let me check on this.. |
|
| Back to top |
|
|
|
|
