dbspace not empty

Hi Thanks for all the suggestions about the database reorg - when I finally managed to export all the data I ran an oncheck -pe and 5 of my chunks had data in them and they weren't related to any of my databases - see attached oncheck -pe. Any idea how to clear them out as I can't drop them because they still have data in them. (note we use PeopleSoft databases so perhaps it's thier fault) cheers Bridget PS everything else went really well - so far Disk usage for Chunk 3 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 768 TBLSPACE TBLSPACE 821 50 FREE 871 800 TBLSPACE TBLSPACE 1671 50 FREE 1721 800 TBLSPACE TBLSPACE 2521 50 FREE 2571 800 TBLSPACE TBLSPACE 3371 50 FREE 3421 800 TBLSPACE TBLSPACE 4221 50 FREE 4271 800 TBLSPACE TBLSPACE 5071 50 FREE 5121 800 TBLSPACE TBLSPACE 5921 50 FREE 5971 800 TBLSPACE TBLSPACE 6771 50 FREE 6821 800 TBLSPACE TBLSPACE 7621 50 FREE 7671 800 TBLSPACE TBLSPACE 8471 50 FREE 8521 800 TBLSPACE TBLSPACE 9321 50 FREE 9371 800 TBLSPACE TBLSPACE 10171 50 FREE 10221 800 TBLSPACE TBLSPACE 11021 50 FREE 11071 800 TBLSPACE TBLSPACE 11871 50 FREE 11921 800 TBLSPACE TBLSPACE 12721 50 FREE 12771 800 TBLSPACE TBLSPACE 13571 100 FREE 13671 1600 TBLSPACE TBLSPACE 15271 100 FREE 15371 9812 TBLSPACE TBLSPACE 25183 100 FREE 25283 2400 TBLSPACE TBLSPACE 27683 100 FREE 27783 2400 TBLSPACE TBLSPACE 30183 100 FREE 30283 2400 TBLSPACE TBLSPACE 32683 100 FREE 32783 2400 TBLSPACE TBLSPACE 35183 100 FREE 35283 2400 TBLSPACE TBLSPACE 37683 100 FREE 37783 2376 TBLSPACE TBLSPACE 40159 100 FREE 40259 2400 TBLSPACE TBLSPACE 42659 100 FREE 42759 2400 TBLSPACE TBLSPACE 45159 100

TBLSPACE is used by Informix to store information about the various tblspaces in the dbspace (one row per extent, I guess). I've run into a similar problem some time back - finally, I had to get Tech Support to dial in to fix it so that I could drop the dbspace/chunk. Rudy Bridget Reitsma wrote: > Hi > > Thanks for all the suggestions about the database reorg - when I finally > managed to export all the data I ran an oncheck -pe and 5 of my chunks > had data in them and they weren't related to any of my databases - see > attached oncheck -pe. Any idea how to clear them out as I can't drop > them because they still have data in them. (note we use PeopleSoft > databases so perhaps it's thier fault) > > cheers Bridget > > PS everything else went really well - so far > > Disk usage for Chunk 3 Start Length > ------------------------------------------- --------- --------- > OTHER RESERVED Pages 0 2 > CHUNK FREE LIST PAGE 2 1 > TBLSPACE TBLSPACE 3 50