Chunk Not empty

Hi, I am trying to drop a dbspace (named conversion). That dbspace originally was consisted from 10 chunks (conv_dat.000 to conv_dat.009). I have dropped successfully up to conv_dat.005 chunk. When I try to drop conv_dat.004 chunk (using the onspaces -d conversion -p E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.004 -o 0 -y command) I get the following error message ' Chunk conv_dat.004 can't be dropped (Chunk is not empty)' Giving the oncheck -pe command and isolating the refercnces about the conversion dbspace I get the following output: ***************************************************************************** ****************************** DBspace Usage Report: conversion Owner: informix Created: 06/26/2004 Chunk Pathname Size Used Free 303 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.000 500000 103 499897 Description Offset Size ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 conversion:'informix'.TBLSpace 3 50 FREE 53 497035 conversion:'informix'.TBLSpace 497088 50 FREE 497138 2862 Total Used: 103 Total Free: 499897 Chunk Pathname Size Used Free 304 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.001 500000 3 499997 Description Offset Size ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 FREE 3 499997 Total Used: 3 Total Free: 499997 Chunk Pathname Size Used Free 305 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.002 500000 3 499997 Description Offset Size ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 FREE 3 499997 Total Used: 3 Total Free: 499997 Chunk Pathname Size Used Free 306 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.003 500000 3 499997 Description Offset Size ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 FREE 3 499997 Total Used: 3 Total Free: 499997 Chunk Pathname Size Used Free 307 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.004 500000 53 499947 Description Offset Size ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 FREE 3 261874 conversion:'informix'.TBLSpace 261877 50 FREE 261927 238073 Total Used: 53 Total Free: 499947 ***************************************************************************** ********************* It seems that something occupies (conversion:'informix'.TBLSpace) 50 pages from the chunk BUT I don't know what. Before start dropping chunks I have dropped all the tables on the conversion dbspace using a script that the table creator give to me in order to delete them. Any advices? Thanks in Advance SZ

Hi Sergios, those 50 pages are tblspacetblspace pages, there was a bug where the drop didn't work as the chunk contains tblspace extended pages even when the chunk has no user table pages. I think this is your problem. The best thing to do is open a case with tech support they will be able to drop that chunk and also will tell you what IDS version has a fix for this problem. Regards esteban.- --- "sergios.zag...." <sergios.zagotsis@egnatiabank.gr> escribis: > Hi, > > I am trying to drop a dbspace (named conversion). > That dbspace originally was > consisted from 10 chunks (conv_dat.000 to > conv_dat.009). I have dropped > successfully up to conv_dat.005 chunk. > > When I try to drop conv_dat.004 chunk > (using the onspaces -d conversion -p > E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.004 -o 0 -y > command) > > I get the following error message > ' Chunk conv_dat.004 can't be dropped (Chunk is not > empty)' > > Giving the oncheck -pe command and isolating the > refercnces about the > conversion dbspace I get the following output: > > ***************************************************************************** > ****************************** > > DBspace Usage Report: conversion Owner: > informix Created: > 06/26/2004 > > > Chunk Pathname > Size Used > Free > 303 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.000 > 500000 103 > 499897 > > Description > Offset > Size > > ------------------------------------------------------------- > -------- > -------- > RESERVED PAGES > 0 > 2 > CHUNK FREELIST PAGE > 2 > 1 > conversion:'informix'.TBLSpace > 3 > 50 > FREE > 53 > 497035 > conversion:'informix'.TBLSpace > 497088 > 50 > FREE > 497138 > 2862 > > Total Used: 103 > Total Free: 499897 > > > Chunk Pathname > Size Used > Free > 304 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.001 > 500000 3 > 499997 > > Description > Offset > Size > > ------------------------------------------------------------- > -------- > -------- > RESERVED PAGES > 0 > 2 > CHUNK FREELIST PAGE > 2 > 1 > FREE > 3 > 499997 > > Total Used: 3 > Total Free: 499997 > > > Chunk Pathname > Size Used > Free > 305 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.002 > 500000 3 > 499997 > > Description > Offset > Size > > ------------------------------------------------------------- > -------- > -------- > RESERVED PAGES > 0 > 2 > CHUNK FREELIST PAGE > 2 > 1 > FREE > 3 > 499997 > > Total Used: 3 > Total Free: 499997 > > > Chunk Pathname > Size Used > Free > 306 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.003 > 500000 3 > 499997 > > Description > Offset > Size > > ------------------------------------------------------------- > -------- > -------- > RESERVED PAGES > 0 > 2 > CHUNK FREELIST PAGE > 2 > 1 > FREE > 3 > 499997 > > Total Used: 3 > Total Free: 499997 > > > Chunk Pathname > Size Used > Free > 307 E:\\\\IFMXDATA\\\\ol_prime\\\\conv_dat.004 > 500000 53 > 499947 > > Description > Offset > Size > > ------------------------------------------------------------- > -------- > -------- > RESERVED PAGES > 0 > 2 > CHUNK FREELIST PAGE > 2 > 1 > FREE > 3 > 261874 > conversion:'informix'.TBLSpace > 261877 > 50 > FREE > 261927 > 238073 > > Total Used: 53 > Total Free: 499947 > > ***************************************************************************** > ********************* > > It seems that something occupies > (conversion:'informix'.TBLSpace) 50 pages > from the chunk BUT I don't know what. > > Before start dropping chunks I have dropped all the > tables on the conversion > dbspace using a script that the table creator give > to me in order to delete > them. > > Any advices? > > > Thanks in Advance > > === message truncated === ___________________________________________________________ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar