Is there a way to look at the last time a table is loaded.

santoshkumarmanilakkoju · Posted: Sat Jun 05, 2010 12:33 pm

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

dick scherrer · Posted: Sat Jun 05, 2010 8:21 pm

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. . .

ibmmainframes.com/viewtopic.php?t=49109

santoshkumarmanilakkoju · Posted: Sun Jun 06, 2010 9:19 am

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.

sushanth bobby · Posted: Sun Jun 06, 2010 9:51 am

santoshkumarmanilakkoju,

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

santoshkumarmanilakkoju · Posted: Sun Jun 06, 2010 12:56 pm

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 = '*******';

dick scherrer · Posted: Sun Jun 06, 2010 10:56 pm

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

d