How can I drop an empty chunk that is bad

Recently we stopped and started our Informix instance using onmode -yuk and oninit -vyTwo non critical empty chunks did not start. The instance started ok however. The application doesn't work though, I'm thinking because of the bad chunks. So I want to drop these two empty bad chunks. But it won't drop them because they are bad. onspaces -d pdrug_dbs -p /worx/informix/dev/prod/pdrug_chunk2 -o 12results: chunk not dropped ISAM error: primary and mirror chunks are bad How can I get this to work? Thanks for any ideas.

Call tech support. They can mark the chunks back online. They will also have to drop any objects (tables, indexes, etc) that reside in those chunks (yes there might be something there that you don't know about like tablespace tablespace pages). They you or they will be able to drop the chunks. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, May 13, 2010 at 5:51 PM, DENISE MCMILLAN <dmcmillan@mgh.org> wrote: > Recently we stopped and started our Informix instance using onmode -yuk and > oninit -vy> Two non critical empty chunks did not start. The instance started ok > however. > The application doesn't work though, I'm thinking because of the bad > chunks. > So I want to drop these two empty bad chunks. But it won't drop them > because > they are bad. > > onspaces -d pdrug_dbs -p /worx/informix/dev/prod/pdrug_chunk2 -o 12> results: chunk not dropped > > ISAM error: primary and mirror chunks are bad> > How can I get this to work? Thanks for any ideas. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636e0a6aebc8575048681fff1