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
 
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: 10327
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: 6968
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: 10327
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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm

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