View previous topic :: View next topic
|
Author |
Message |
rajandhla
Active User
Joined: 18 Oct 2005 Posts: 182 Location: Luton UK
|
|
|
|
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 |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
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 |
|
|
|