RE: Dropping a dbspace
errror message "waiting for shutdown or override" -
maybe you can try to run
onmode -O (to override)it will disable that db space and db server will come
up...
HTH
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of
TBP@Nospam.Nothere.Co.Uk
Sent: 02 February 2004 23:43
To: informix-list@iiug.org
Subject: Re: Dropping a dbspace
Chariya Peterson wrote:
>
> "TBP@Nospam.Nothere.Co.Uk" wrote:
>
>>Chariya Peterson wrote:
>>
>>
>>>I have a bad dbspace I wanted to drop (and recreated). But I have some
>>>problem.
>>>Here is the output form onstat -d:
>>>
>>>5010c7d8 1 0x20001 1 1 N informix
>>>dbroot_test3
>>>5020dcb0 2 0x20005 2 1 ND informix dbdata
>>>5020de00 3 0x2001 3 1 N T informix
>>>dbtemp01
>>>
>>>5010c928 1 1 0 50000 45561 PO--
>>>/usr/informix/dev-links/DBROOT_TEST3
>>>5021cc50 2 2 1 208000 0 PD--
>>>/usr/informix/dev-links/DBDATA_TEST3
>>>5021cdd0 3 3 1 50000 49947 PO--
>>>/usr/informix/dev-links/DBTEMP1_TEST3
>>>
>>>I tried to drop dbdata, but both onmonitor and onspaces just hang.
>>>We are using Informix 9.4.
>>>
>>>Thanks,
>>>Chariya
>>
>>Platform??
>
>
> AIX RS6000
>
>
>
>>What "went bad"?
>
> The DBDATA dbspace is down (with flag = ND). I wanted to drop and
> import the database from another server but have to get the dbspace
> online (or drop/recreate) first.
>
>
> Here is the error messages from onmode/oninit
> ----
> informix@saatest3 $ onmode -ky
> Warning: checkpoint appears to be stalled and is not complete.
> Continuing shutdown
> ----
> informix@saatest3 $
> informix@saatest3 $ oninit
> SENDER IS NULL NO MAIL WILL BE SENT
> oninit: Cannot open chunk '/usr/informix/dev-links/DBDATA_TEST3'. errno
> = 2
> ----
#define ENOENT 2 /* No such file or directory */
>
>>What error is in the online log when you try and drop it?
>
> 16:19:04 Dataskip is now OFF for all dbspaces
> 16:19:04 Checkpoint blocked by down space, waiting for override or> shutdown
>>What does ls -l /usr/informix/dev-links/DBTEMP1_TEST3 show?
>
> Seems normal.
> ls -l
> lrwxrwxrwx 1 informix informix 19 Apr 14 2003
> /usr/informix/dev-links/DBDATA_TEST3@ -> /dev/dbdata_testdb
>
>>What does ls -L /usr/informix/dev-links/DBDATA1_TEST3 show?
>
> ls -L
> /dev/dbdata_testdb
>
>
>>On the assumption that you have some logical logs, and a bit of physical
>>log, I wonder how much actual "data" is left in the instance with this
>>dbspace dbdata marked as down.
>
>
> There is no need to recover the data. I simply want to drop and
> recreate this dbspace (DBDATA). Then import the database.
>
> Chariya
Humm, well, err, oh, so, re-create the instance from scratch ;)
Also,
#define ENOENT 2 /* No such file or directory */
so make sure that /usr/informix/dev-links/DBDATA_TEST3@ ->
/dev/dbdata_testdb actually points to a bit of useable disk.
Try :
dd if=/usr/informix/dev-links/DBDATA_TEST3 bs=4k count=1 of=/dev/null
This email has been scanned for viruses.
sending to informix-list