Re: What is using the space?

oncheck -pe springs to mind. I like to run it through my own lil' awkscript which summarizes it. You can download a copy from www.artentech.com/downloads.htm. Under Informix disk usage cheers j. ----- Original Message ----- From: "5 cats" <cats_five@hotmail.com> To: <informix-list@iiug.org> Sent: Thursday, May 22, 2003 6:52 AM Subject: 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. >