RE: dbspace is down ...

When I try to drop the dbspace, it reports following ... $ onspaces -d rootdbstestWARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The dbspace you wish to drop has been disabled. There may be database catalog entries for tables or indices which contain data in this dbspace. If you complete the drop they will be unusable. Do you really want to continue? (y/n)y Cannot drop the DBspace/BLOBspace. ISAM error: Unexpected internal error When I try to bring it online it reports following ... $ onspaces -s rootdbstest -p /u/IFMXDATA/AKU_shm/rootdbstest_dat.000 -o 0 -OWarning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, please wait ... Cannot change chunk status. ISAM error: Primary and Mirror chunks are bad And the 'online.log' has following entries ... 17:54:08 Assert Failed: WARNING! pthdrpage:ptalloc:bad bfget 17:54:08 Who: Session(124, informix@biruni, 20977, 273000756) Thread(156, onspace, 1043aa1c, 1) 17:54:08 Results: Cannot use TBLSpace page for TBLSpace 5242881 17:54:08 Action: Run 'oncheck -pt 5242881' 17:54:08 See Also: /tmp/af.9c1a00 17:54:42 Checkpoint Completed: duration was 8 seconds. 17:55:15 chunk failed sanity check 17:55:17 I/O error, Primary Chunk '/u/IFMXDATA/AKU_shm/rootdbstest_dat.000' -- Offline (sanity) Any more help ... Shahid Mehmood Software Designer II Information Systems Department The Aga Khan University Karachi Official:Y > -----Original Message----- > From: Dewhurst, Cy [SMTP:cy.dewhurst@rbch-tr.swest.nhs.uk] > Sent: Monday, September 04, 2000 17:45 > To: shahid.mehmood > Subject: RE: dbspace is down ... > > You can use onmonitor to drop the chunk (onmonitor -> dbspaces -> drop), > or the following onspaces command: > > onspaces -d rootdbstest> > But, these probably won't work as the chunk is already marked as down: > > 104364d4 5 5 0 10240 10187 PD- > /u/IFMXDATA/AKU_shm/rootdbstest_dat.000 > > Check your online log and see if there are any errors around the time > the chunk was created. > Unless rootdbstest_dat.000 is a symbolic link, it looks like a 'cooked' > file. > > Other than that you have two choices: > > Call informix support and see if they can remove the down chunk for > you... > Full export, destroy instance, create new instance, import... > > Sounds like you've tried to create a second rootdbs in the same > instance. Why you would want to do this I'm not sure... Best bet would > be to start again and create two separate instances, retrieving any data > you need to keep (if possible) with dbimport/dbexport. There are > various onchecks you can run to verify the consistency of the instance: > > oncheck -cr > oncheck -cc > oncheck -ce > oncheck -cI sysmaster > oncheck -cD sysmaster> > Good luck > > Cy > > > > ----Original Message----- > > From: shahid.mehmood@aku.edu [SMTP:shahid.mehmood@aku.edu] > > Sent: 04 September 2000 11:57 > > To: informix-list@iiug.org > > Subject: dbspace is down ... > > > > Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME > > ... > > > > IX: OWS 7.2, OS: SCO UNIX > > > > During my initial years as IX DBA, I tried to create two instances of > > informix ows 7.2. For this I created a dbspace using COMMAND CENTER > > from my > > windows station. then I put this name as ROOTDBS in my test ONCONFIG > > file. > > It was a failure ... off cource ... then I created a raw file, and put > > that > > name as ROOTDBS in test ONCONFIG. every thing went well ... till now. > > > > Now when I try to use 'ontape' it crashes. and the reason is the same > > dbspace mentioned above. When I try to drop that dbspace, its a > > failure ... > > > > here is the output from 'onstat -d' > > > > $ onstat -d> > > > INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:46:26 -- 8936 > > Kbytes > > > > Dbspaces > > address number flags fchunk nchunks flags owner name > > 104360e8 1 1 1 1 N informix rootdbs > > 10436750 2 1 2 1 N informix nesdata > > 104367b8 3 1 3 1 N informix > > hrmspace > > 10436820 4 1 4 2 N informix > > libspace > > 10436888 5 1 5 1 N informix > > rootdbstest > > 104368f0 6 1 7 1 N informix paydata > > 6 active, 2047 maximum > > > > Chunks > > address chk/dbs offset size free bpages flags pathname > > 10436150 1 1 0 10000 4569 PO- > > /u/IFMXDATA/AKU/ROOTD > > BS.000 > > 10436258 2 2 0 50000 49001 PO- > > /u/usr/NES/NESDATA > > 1043632c 3 3 0 500000 494575 PO- > > /u/usr/HRMS/HRMSDATA > > 10436400 4 4 0 50000 2047 PO- > > /u/usr/LIB/LIBDATA > > 104364d4 5 5 0 10240 10187 PD- > > /u/IFMXDATA/AKU_shm/rootdbstest_dat.000 > > 104365a8 6 4 0 50000 38781 PO- > > /u/usr/LIB/LIBDATA001 > > 1043667c 7 6 0 500000 216495 PO- > > /u/usr/PAY/PAYDATA > > 7 active, 2047 maximum > > > > Can any one of you help me HOW TO DROP THIS DBSPACES (rootdbstest)? > > > > I am waiting for your replies ... SORRY AGAIN FOR MIME FORMAT. > > > > Shahid Mehmood > > Software Designer II > > Information Systems Department > > The Aga Khan University > > Karachi > > Official:Y > >