Akshay Pande
New User
Joined: 23 Oct 2012 Posts: 3 Location: India
|
|
|
|
Hi,
I have a query regarding Reorg.
I have to find out the Reorg date for a particular table before the last reorg i.e. if the last reorg was done on 1st Jan, I want to find the date of the reorg done before that.
In my search online, I came across LIST HISTORY command but I think it can be used for UNIX and Windows but not in mainframe environment.
Also I came across the table SYSIBMADM.DB_HISTORY but that also I cant seem to find in the system.
Could you please suggest me if there is any other to find out the date of the reorg previous to the last one. |
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Akshay,
Use this query,
Code: |
SELECT dbname, tsname, timestamp
from sysibm.syscopy
where ictype in('w','x')
and dbname = 'databasename'
and tsname = 'tablespacename'
order by timestamp desc
first first 5 rows only;
|
If you know the name of the job which did the last reorg, if it is scheduled. Check the JMR for a big range.
Thanks,
Sushanth |
|