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 Profile Log in to check your private messages Log in
 
Is there a way to look at the last time a table is loaded.

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

New User


Joined: 24 Nov 2009
Posts: 37
Location: Don't know

PostPosted: Sat Jun 05, 2010 12:33 pm    Post subject: Is there a way to look at the last time a table is loaded.
Reply with quote

Hi,

Problem:
We need the job details which is loading a DB2 tablespace.
We tried out serching the table name by all possible means through source codes/procs/loadreps/loadres but could not find it.

Can some one let me know, if their is any way to check a particular table's last laoded date/time.

FYI...We use BMC Catalogue Manager
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jun 05, 2010 8:21 pm    Post subject:
Reply with quote

Hello,

If you had done a search in the forum, you would have found this current active topic and gotten an answer when you asked the question. . . icon_sad.gif

http://ibmmainframes.com/viewtopic.php?t=49109
Back to top
View user's profile Send private message
santoshkumarmanilakkoju

New User


Joined: 24 Nov 2009
Posts: 37
Location: Don't know

PostPosted: Sun Jun 06, 2010 9:19 am    Post subject:
Reply with quote

Hi d.sch,

I have searched the forum and also had a look at this current topic before my current post, but my question is a little different;

We can know the last update/reorg/runstats from the catalogue manager or from the query as in the other post.

But how can we know the last time, a table is loaded

Hope I am clear.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sun Jun 06, 2010 9:51 am    Post subject:
Reply with quote

santoshkumarmanilakkoju,

LOADLASTTIME <-- this is a column name. Table name is given in the link posted by d.sch.

Quote:
FYI...We use BMC Catalogue Manager

I use DB2 Catalog tables.

Sushanth
Back to top
View user's profile Send private message
santoshkumarmanilakkoju

New User


Joined: 24 Nov 2009
Posts: 37
Location: Don't know

PostPosted: Sun Jun 06, 2010 12:56 pm    Post subject: Reply to: Is there a way to look at the last time a table is
Reply with quote

Thank you Sushanth and d.sh,

I could get the last load stats by the below qeury:

SELECT LOADRLASTTIME FROM SYSIBM."SYSTABLESPACESTATS"
WHERE DBNAME = '*******' AND
NAME = '*******';
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jun 06, 2010 10:56 pm    Post subject: Reply to: Is there a way to look at the last time a table is
Reply with quote

Good to hear you have what you were looking for - thanks for letting us know icon_smile.gif

d
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 Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm

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