View previous topic :: View next topic
|
Author |
Message |
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Hi,
I am trying to capture the extents information by the doing a listcat against underlined tablespace datasets.So I have a set of file to for which the extents information need to be found.
So I have a REXX program which reads the files and does a listcat and writes to output file.
So if there are 15k FILES for which I need to do listcat and get the extent information its taking long time.
How would I go about it in reducing the amount of time consumed?
Regards,
Prem |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
underlined tablespace datasets |
please clarify |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Sorry Enrico
I ment the LDS of the tablespace |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
if you are doing this in foreground, will take a while.
it should be done in batch. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
How would I go about it in reducing the amount of time consumed |
Not much you can control. . .
You might run this when the system is least busy. . .
Is there some reason you don't use the db2 statsitics rather than the listcat? The queries to select table/tablespace data execute very quickly. Is there something (useful) the "extents" will provide that the db2 catalog will not? |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Hi Dick Brenholtz,
I am executing it in batch only.
Hi Dick scherrer,
I do agree with you that you can get this information from SYSTABLEPART,SYSTABLESPACE,SYSINDEXES,SYSINDEXPART provided you have your runstats being done on a regular basis.
If you do in my approach you would get the info upto date |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
provided you have your runstats being done on a regular basis. |
And runstats should be done regularly. . .
Quote: |
If you do in my approach you would get the info upto date |
The listcat info is quite limited compared to the catalog info. There is also the matter of how much system resource is this worth?
Suggest considering the schedule be changed to do the runstats each week and these queries run immediately thereafter. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Dick,
Thanks again Dick for your suggesions.
I do agree with you but too many runstats isnt it a overhead?
Please advice.
LISTCAT info is quite limited but I am keen only on the EXTENTS so which is very needful info for DBA'S to calculate the growth. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I do agree with you but too many runstats isnt it a overhead? |
Sure, if runstats was run every hour on the hour. . . I suspect that once a week or so would not be excessive.
How does the system usage for the full listcat compare to the system usage for runstats and the queries? Suggest that runstats be kept current even if the listcat is used. . . |
|
Back to top |
|
|
|