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
 

 

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
This topic is locked: you cannot edit posts or make replies. Full Time COBOL Software Development ... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:24 am
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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. Get a job submitted itself every time... arunsoods JCL & VSAM 3 Tue Nov 22, 2016 4:05 pm


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