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
 
LISTCAT tablespace datasets

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Sat Aug 22, 2009 3:49 pm    Post subject: LISTCAT tablespace datasets
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Sat Aug 22, 2009 3:51 pm    Post subject: Reply to: LISTCAT
Reply with quote

Quote:
underlined tablespace datasets


please clarify icon_eek.gif
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Sat Aug 22, 2009 4:20 pm    Post subject:
Reply with quote

Sorry Enrico

I ment the LDS of the tablespace
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Sat Aug 22, 2009 8:36 pm    Post subject:
Reply with quote

if you are doing this in foreground, will take a while.

it should be done in batch.
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 Aug 22, 2009 11:01 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Mon Aug 24, 2009 2:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 24, 2009 7:51 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Mon Aug 24, 2009 8:26 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 24, 2009 9:11 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts LISTCAT on a dataset with symbolic pa... shreya19 JCL & VSAM 5 Fri Apr 07, 2017 5:43 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm

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