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 forTBLSpace 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 Information Systems Department The Aga Khan University, Karachi, Pakistan __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

I looks like the reason the dbspace is marked down is that the chunk is no longer a viable file/device and cannot be read/written. If that is the case you will not be able to drop it. On UNIX you would relink the file to a new one and restore from an archive then you would be able to drop it. On NT you cannot do that so... call tech support they can dial in and MAY be able to drop it if there are not too many objects dependent on its existence. Can you fix/replace the file/device so you can restore it? Art S. Kagel Shahid Mehmood wrote: > > When I try to drop the dbspace, it reports following > ... > > $ onspaces -d rootdbstest> WARNING: 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 -O> Warning: 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 > Information Systems Department > The Aga Khan University, > Karachi, Pakistan > > __________________________________________________ > Do You Yahoo!? > Yahoo! Mail - Free email you can access from anywhere! > http://mail.yahoo.com/