Re: How to take off a chunck from dbspace

You can do that as long as the chunks are unused, and that looks like the case so far. You use the onspaces utility to accomplish this: onspaces -d dbspace1 -p /dev/credito/dbspace1_5 -o 0 onspaces -d dbspace1 -p /dev/credito/dbspace1_4 -o 0 Art S. Kagel ----- Original Message ----- From: Luis Reyes <lgreyes@kionetworks.com> At: 5/20 17:18 > Hi All, > > I have an instance with this configuration (onstat -d) of dbspaces: > Informix Dynamic Server Version 7.31.UD3 -- On-Line -- Up 7 days 01:36:12 -- > 292176 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > 40052150 1 1 1 1 N informix rootdbs > 40052ed0 2 2001 2 1 N T informix tempdbs1 > 40052f90 3 1 3 1 N informix logdbs > 40053050 4 1 4 1 N informix physicaldbs > 40053110 5 1 5 5 N informix dbspace1 > 5 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > 40052210 1 1 0 10000 8803 PO- /dev/credito/rootdbs > 400526d0 2 2 0 255000 254481 PO- > /dev/credito/temporal1 > 400527d0 3 3 0 255000 4947 PO- /dev/credito/logical > 400528d0 4 4 0 64000 1447 PO- /dev/credito/physical > 400529d0 5 5 0 510000 20 PO- > /dev/credito/dbspace1_1 > 40052ad0 6 5 0 510000 224015 PO- > /dev/credito/dbspace1_2 > 40052bd0 7 5 0 510000 509997 PO- > /dev/credito/dbspace1_3 > 40052cd0 8 5 0 510000 509997 PO- > /dev/credito/dbspace1_4 > 40052dd0 9 5 0 510000 509997 PO- > /dev/credito/dbspace1_5 > 9 active, 2047 maximum > > Could some body tell me if I can take off the last two chuncks of dbspace > "dbspace1" > and how to do that. > > I need assign this two choncks to another dbspace, ¿Can I do that? > > Thanks a lot. > Luis