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
 
Get information on the used extents of tablespace

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

Moderator


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

PostPosted: Thu Jun 05, 2008 11:11 pm    Post subject: Get information on the used extents of tablespace
Reply with quote

Is it possible to get information on the used extents of tablespace from systablepart and systablespace ?
Where systablepart -> I will be having the information on PQTY, SQTY AND SPACE.
How the used extents calculated from these quantities.

Thanks,
Prem
Back to top
View user's profile Send private message

am_ne

New User


Joined: 24 Mar 2007
Posts: 25
Location: Bangalore

PostPosted: Fri Jun 06, 2008 6:36 pm    Post subject:
Reply with quote

No. I don't think its possible as storage mechanism depends not only on pri quantity/ sec quantity but also depends on the parms like COMPRESS/PCTFREE/FREEPAGE etc...

If you know the underlying vsam cluster name then you can issue listc command to know the used extents.

Thanks
Amit
Back to top
View user's profile Send private message
Pandora-Box

Moderator


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

PostPosted: Sat Jun 07, 2008 4:06 pm    Post subject:
Reply with quote

Thanks am_ne yeah I know that option but I am trying to build something in the form of a report for a set of tablespaces that why I checked if it was feasible icon_smile.gif .

Regds,
Prem
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
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm
No new posts Getting information (RECFM/LRECL/BLKS... Tim Van Holder COBOL Programming 3 Wed Mar 14, 2018 2:10 pm
No new posts Get the list of data sets on DASD and... rakaitn JCL & VSAM 3 Thu Mar 08, 2018 12:38 pm
This topic is locked: you cannot edit posts or make replies. how to get Job information from IOF u... rsshanmugam CLIST & REXX 13 Mon Feb 05, 2018 4:22 pm
No new posts Need to obtain VTOC information via R... djeffbland CLIST & REXX 10 Thu Jan 11, 2018 4:13 am

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