IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

space calculation of a database


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Tue Feb 13, 2007 1:43 pm
Reply with quote

Guys,

How to know the storage details of a database in a stroge group.

i.e No of volumes allocated/consumed by a database
No of tracks used/ tracks left.

At database level and at the table level.......


Regards,
JR
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Wed Feb 14, 2007 1:18 am
Reply with quote

For a database managed or SMS managed storage, there is no way to relate individual volumes to tablespaces and indexspaces using catalog tables only. Maximum you can get is the storage group name associated.

You can probably use a REXX or even manually check the underlying LDS datasets using a LISTCAT.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts What database does Jobtrac use CA Products 4
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Merge 2 lines based on Space from a S... DFSORT/ICETOOL 5
Search our Forums:

Back to Top