RE: Dropping a dbspace
You need to make it available again to drop it. You do that with onspaces -s ... or restore from archive.
Otherwise the easiest is to reinitialise and start again.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Chariya Peterson
> Sent: Tuesday, 3 February 2004 11:17 a.m.
> To: informix-list@iiug.org
> Subject: Re: Dropping a dbspace
>
>
>
>
> "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
> ----
>
>
>
>
> > 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
> 16:20:00 (4) connection rejected - no calls allowed for sqlexec
> 16:20:00 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode.
> ----
>
>
>
> > 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
sending to informix-list
sending to informix-list