Re: remove a chunk from "rootdbsA"
Posted in 1999
Topics: Storage & Space Management, Server Administration
zhihongyuan@263.net wrote:
>
> In article <7kr3ek$qi4$1@taliesin.netcom.net.uk>,
> "Neil Truby" <ntruby@netcomuk.co.uk> wrote:
> >
> > zhihongyuan@my-deja.com wrote in message <7kqvoh$agk$1@nnrp1.deja.com>...
> > > My rootdbs has been named as "rootdbsA",
> > >it have two chunks, when I remove one chunk
> > >from it, I get some error like "dbspace
> > >'rootdbsA' not found.
> > > How can I remove the chunk ?
> >
> > How are you trying to remove it now?
> > Can you provide an onstat -d listing, and an example of your onspaces
> > command for dropping the chunk
>
> $ onstat -d INFORMIX-OnLine Version 7.13.UC3 -- On-Line -- Up 19 days
> 13:20:46 -- 52416 Kb ytes>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> c31f90e8 1 1 1 2 N informix rootdbsA
> c31f99c0 2 1 2 1 N informix logdbsa
> c31f9a28 3 1 3 2 N informix ctsdbs
> c31f9a90 4 1 4 3 N informix savdbs
> c31f9af8 5 1 5 1 N informix chimdbs
> c31f9b60 6 2001 6 1 N T informix tmpdbsa
> 6 active, 2047 maximum
>
> Chunks
> address chk/dbs offset size free bpages flags pathname
> c31f9150 1 1 0 50000 48811 PO- /home/informix/rootdbsA
> c31f9228 2 2 0 150000 4947 PO- /home/informix/logdbsA
> c31f9300 3 3 0 300000 24036 PO- /home/informix/ctsdbs
> c31f93d8 4 4 0 900000 109488 PO- /home/informix/savdbss
> c31f9588 6 6 0 50000 49747 PO- /home/informix/tmpdbsA
> c31f9660 7 1 0 500000 499997 PO- /home/informix/savdbs1
> c31f9738 8 4 0 516000 515997 PO- /home/informix/savdbs2
> c31f9810 9 4 0 500000 499997 PO- /home/informix/savdbs3
> c31f98e8 10 3 0 200000 168319 PO- /home/informix/ctsdbs1
> 10 active, 2047 maximum
Which I guess should look like that.
> $ onspaces -d rootdbsA -p /home/informix/savdbs1 -o 0> DBspace/BLOBspace does not exist.
I've never seen mixed case object names before. Have you tried:
onspaces -d rootdbsa -p /home/informix/savdbs1 -o 0
^
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com http://www.informix.com/idn |///// / //|
|http://www.iiug.org +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |What year 2000 bug? year 2000 bug? |/// / ////|
| Fax: +27 838250 2325 |year 2000 bug? year 2000 bug? year |// / /////|
|Cell: +27 83 250 2325 |2000 bug? year 2000 bug? year 1900 |/ ////////|
+----------------------+-----------------------------------+-----------+
> >
> > $ onstat -d INFORMIX-OnLine Version 7.13.UC3 -- On-Line -- Up 19days
> > 13:20:46 -- 52416 Kb ytes
> >
> > Dbspaces
> > address number flags fchunk nchunks flags owner name
> > c31f90e8 1 1 1 2 N informix
rootdbsA
> > c31f99c0 2 1 2 1 N informix
logdbsa
> > c31f9a28 3 1 3 2 N informix
ctsdbs
> > c31f9a90 4 1 4 3 N informix
savdbs
> > c31f9af8 5 1 5 1 N informix
chimdbs
> > c31f9b60 6 2001 6 1 N T informix
tmpdbsa
> > 6 active, 2047 maximum
> >
> > Chunks
> > address chk/dbs offset size free bpages flags pathname
> > c31f9150 1 1 0 50000 48811 PO-
/home/informix/rootdbsA
> > c31f9228 2 2 0 150000 4947 PO-
/home/informix/logdbsA
> > c31f9300 3 3 0 300000 24036 PO-
/home/informix/ctsdbs
> > c31f93d8 4 4 0 900000 109488 PO-
/home/informix/savdbss
> > c31f9588 6 6 0 50000 49747 PO-
/home/informix/tmpdbsA
> > c31f9660 7 1 0 500000 499997 PO-
/home/informix/savdbs1
> > c31f9738 8 4 0 516000 515997 PO-
/home/informix/savdbs2
> > c31f9810 9 4 0 500000 499997 PO-
/home/informix/savdbs3
> > c31f98e8 10 3 0 200000 168319 PO-
/home/informix/ctsdbs1
> > 10 active, 2047 maximum
>
> Which I guess should look like that.
>
> > $ onspaces -d rootdbsA -p /home/informix/savdbs1 -o 0> > DBspace/BLOBspace does not exist.
>
> I've never seen mixed case object names before. Have you tried:
>
> onspaces -d rootdbsa -p /home/informix/savdbs1 -o 0
> ^
> Cheers,
> --
> Mark.>
Unfortunately,it is Not working!
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape