View previous topic :: View next topic
|
Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
How to find ?
When was the last time a particular table was touched(inserted, deleted,updated,altered,loaded,contraint removal, etc.,).... |
|
Back to top |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
You have to do Log Analysis. We have an Option in our Shop, with that we can see who Updated the table with Date and Time.
Please check in your shop whether you have DB2 Log Analyzer. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
I have Unicenter Log Analyzer. I want to checkout when was a table in a database was updated last.
It has many options............. I don't know what to choose. I check'd the process log. But, it is not asking for a table name.
Code: |
Log Reporting Services Miscellaneous Functions
1 - Process Log P - Profile
2 - Strategy Services BP - Batch Processor
3 - Source Mapping T - Tutorial
X - Exit Log Analyzer
Administration Aids
4 - List Log Inventory
5 - Image Copy Reporting
6 - SMF Audit Trace Option
7 - DSN1LOGP Wizard
8 - DSN1COPY Wizard
|
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
what about starting from the tutorial to see if the product provides the function You need ? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
read something??
why have this forum to supply ready made answers, code etc... for the mentally challanged if you are going to tell them to read a tutorial or god forbid - PF1. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Guyz,
Requirement : I want to know when was a particular table was touched(DML,DDL so & so).
My TECH SPEC : I am using Unicenter Platinum Tools
Information Got So Far : By using DB2 Log Analyzer. I can get my requirement.
Idea : As said iam using unicenter Log Analyzer. If you able to do the requirement i specified using ur tool. You can explain me that process. So that i could get an idea. How to do it in my tool. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
first of all, no need to assume a patronizing attitude
Quote: |
...How to do it in my tool. ... |
why don' t You read Your tool documentation |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
I saw the documentations. I doesn't give any examples like that. It just gives the basic definations in one or two lines. what each menu does.
That doesn't help me. At the same time, i am googling to find the results.
Please Help.....
Thank You Very Much In Advance,
SUSHANTH |
|
Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008 Posts: 50 Location: Olympia, WA, USA
|
|
|
|
Hi SUSHANTH,
I think you need to do auditing.
Check all the options related to auditing the user activities.
I think using the audit options you can determine who has changed a
particular piece of data. Use filters, i think that will give u some results. |
|
Back to top |
|
|
|