Problem removing chunks ...
Posted in 2000
Topics: Storage & Space Management, Server Administration
Hi guys !
I'm in curious situation, but very critical for me.
Last weekend was dropped one dbspace, but your chunks wasn't... And now ?
How can I drop this chunks ?
I can't use onspaces, 'cause it needs the dbsname...
Look my onstat -d:
Informix Dynamic Server Version 7.30.UC10 -- On-Line -- Up 13:52:44 --
2001504
Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
7004213c 1 2 1 1 M informix rootdbs
70069f50 2 2001 2 5 N T informix tmpdbs1
708daf8c 3 2 3 4 M informix logdbs
708db048 4 2 4 1 M informixp sapddic
708db104 5 2 5 1 M informix psapdocu
708db1c0 6 2 6 2 M informix psapel30f
708db27c 7 2 7 1 M informix psapload
708db338 8 2 8 5 M informix psapuser1
708db3f4 9 2 9 1 M informix physdbs
708db4b0 10 2 10 103 M informix psapbtab
708db56c 11 2 12 13 M informix psapclu
708db628 12 2 13 8 M informix psappool
708db6e4 13 2 15 4 M informix psapprot
708db7a0 14 2 16 11 M informix psapstab
708db85c 15 2 19 4 M informix psapes30f
708db918 16 2 20 1 M informix psapsource
708db9d4 17 2001 45 3 N T informix tmpdbs2 708dba90
18 2001 46 3 N T informix tmpdbs3
708dbb4c 19 2 158 3 M informix psapbtabi01
19 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
700421f8 1 1 4 125000 86348 PO-
/informix/A04/sapdata/physdev2/data1
...
...
...
708cf748 177 21 4 511996 511993 PO-
/informix/A04/sapdata/physdev133/data263
708cf824 178 21 4 511996 511993 PO-
/informix/A04/sapdata/physdev133/data264
708cf900 179 21 4 511996 511943 PO-
/informix/A04/sapdata/physdev139/data276
Thanks for any information.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
Christian Kondo wrote:
>
> Hi guys !
>
> I´m in curious situation, but very critical for me.
> Last weekend was dropped one dbspace, but your chunks wasn´t... And now ?
> How can I drop this chunks ?
> I can´t use onspaces, ´cause it needs the dbsname...
> Look my onstat -d:
What you are showing in the onstat -d should not be possible. You will
have to call tech support who can dial in and manually remove the last
three chunks, belonging to the missing dbspace, from the chunk table.
Onspaces should have dropped all of the chunks when you dropped the
dbspace last weekend.
--
Art S. Kagel & Family
kagel@erols.com
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