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
 
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 Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm
No new posts How syntax check at Bind time is diff... Poha Eater DB2 5 Wed Mar 21, 2018 9:16 pm
No new posts COBOL declaration for table Poha Eater DB2 3 Mon Feb 26, 2018 6:58 pm
No new posts Merging records, but not all the time prino DFSORT/ICETOOL 17 Sat Feb 17, 2018 4:20 pm

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