RE: dropping temporary db space that is on bad disk

Thank you so very much! I have done testing along the lines of your suggestion. My temp spaces are symb links to raw devices. I have created identical tempdbs6 and tempdbs7 and then removed the link for tempdbs6 and relinked it to the same raw device as tempdbs7 and then successfully dropped both db spaces tempdbs6 and tempdbs7. I really hope if I relink tempdbs1 to something else (identical unused tempspace) it will work. We do not have support contract. Thanks Ljubica -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Neil Truby Sent: 12 January 2004 19:02 To: informix-list@iiug.org Subject: Re: dropping temporary db space that is on bad disk One for tech support I'd guess. Perhaps you can touch a filesystem file and link /var/informix/db/tempdbs1 to it, they can dial in and patch it to make it look like an empty tempdbs so you can drop it? Or, if you're feeling really adventurous, create an identical temp dbspace on a dummy instance, dd its contents to /var/informix/db/tempdbs1 and see if you can get the instance to accept it when it starts, so you can drop it. Or .... "Ljubica Cica" <ljubica@bibliotech.net> wrote in message news:btupll$ato$1@terabinaries.xmission.com... > > Hello, > > I am having problems dropping the temporary db space. Any help would be > appreciated. > platform: SunOS, sun4u sparc SUNW,Ultra-4 > informix: Informix Dynamic Server 2000 Version 9.21.UC1 > > Three days ago I had realized that the disk on which is my tempdbsp1 is bad > and sorting resulted in assertion failure which crashed the db server. > > I have edited TEMPDBS in onconfig file so it doesn't use that temp dbspace > and restarted the db server. > The disk was deemed ok then(as in /var/adm/messages 'disk ok') and > tempdbs1(only chunk in db space) was not marked as down. > Then the day after disk went down (forever) and is now 'offline'. > > I have just attempted to drop that temporary space using onspaces which > returned - can't dropp DB Space - no such dbspace and error in online.log > > I/O read chunk 4, pagenum 2, pagecnt 1 --> errno = 5 > > whith errors in /var/adm/messages > > Jan 12 16:53:48 dbasd unix: WARNING: /pci@6,4000/scsi@4,1/sd@0,0 (sd105): > Jan 12 16:53:48 dbasd i/o to invalid geometry > > So onstat -d says it is there and I can't drop it for obvious reasons. > > dbasd1$ onstat -d|grep tempdbs1 > 37dee598 4 0x2001 4 1 N T informix tempdbs1 > 3713c998 4 4 2 1048573 1048520 PO- > /var/informix/db/tempdbs1> > How can I get rid of it now (I know I should have dropped it immediately > after restarting db server with TEMPDBS without it)? Why Informix doesn't > mark it as down? (As once a day some cron job(?) attempts to access it and I > have assertion failure with the same error > mt_aio_wait(491a6c00) > 16:53:48 chunkio(7, 0x1ac38800, 0x2, 1, 0x3713c998, 33, 1) errno 5> > > Many thanks > > > Ljubica Cica - Informix DBA > _____ > > BiblioTech > > > > > > This email has been scanned for viruses. > > sending to informix-list This email has been scanned for viruses. sending to informix-list