Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 1529
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: 1529
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 Obtaining file information pahiker COBOL Programming 25 Tue Sep 27, 2016 7:25 pm
No new posts Need information on COBOL MOVE CORRES... subratarec COBOL Programming 10 Tue Jun 28, 2016 10:38 pm
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts Passing information through JCL as in... Pia Baruah JCL & VSAM 5 Wed May 25, 2016 2:22 pm
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us