What is using the space?

I am working on a layout for a new machine an IDS customer has brought. At present the indexes are in the dbspaces with the tables. Some of the data has a round-robin fragmentation but the indexes are each in a single dbspace. However the various indexes on each table are different sizes (of course!) so I am seeking to put them into their own dbspace(s) to get round this problem - however I can't remember how to find the space taken in a dbspace by the index and the data. Any clues would be most gratefully welcome.

cats_five@hotmail.com (5 cats) wrote in message news:<85c6f42b.0305220252.610e6496@posting.google.com>... > I am working on a layout for a new machine an IDS customer has > brought. At present the indexes are in the dbspaces with the tables. > Some of the data has a round-robin fragmentation but the indexes are > each in a single dbspace. However the various indexes on each table > are different sizes (of course!) so I am seeking to put them into > their own dbspace(s) to get round this problem - however I can't > remember how to find the space taken in a dbspace by the index and the > data. > > Any clues would be most gratefully welcome. Folks, I think that oncheck -pt is giving me what I need e.g. the number of data pages and index pages used. If I am wrong please point me in the right direction!