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
 

 

How to find the last date/time of a table being touched

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

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Aug 11, 2008 3:10 pm    Post subject: How to find the last date/time of a table being touched
Reply with quote

How to find ?
When was the last time a particular table was touched(inserted, deleted,updated,altered,loaded,contraint removal, etc.,)....
Back to top
View user's profile Send private message

shrivatsa
Warnings : 1

Active User


Joined: 17 Mar 2006
Posts: 171
Location: Bangalore

PostPosted: Mon Aug 11, 2008 4:38 pm    Post subject: Reply to: How to find the last date/time of a table being to
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Aug 11, 2008 5:14 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon Aug 11, 2008 5:27 pm    Post subject: Reply to: How to find the last date/time of a table being to
Reply with quote

what about starting from the tutorial to see if the product provides the function You need ?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Aug 11, 2008 5:31 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Aug 11, 2008 5:43 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon Aug 11, 2008 5:51 pm    Post subject: Reply to: How to find the last date/time of a table being to
Reply with quote

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 icon_question.gif
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Aug 11, 2008 5:55 pm    Post subject:
Reply with quote

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
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Tue Aug 12, 2008 1:43 am    Post subject: Reply to: How to find the last date/time of a table being to
Reply with quote

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
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 CICS transaction slow response time vasanthz All Other Mainframe Topics 1 Thu Jan 19, 2017 1:31 am
No new posts DD DUMMY & CPU TIME Nileshkul Testing & Performance analysis 16 Mon Dec 19, 2016 11:35 pm
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm


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