Its a chunk free ?

Hi, I like to reassign an index chunk to a data dbspace, but how can I know if the index chunk it's free? I used onstad -d and it shows a size of 2097152 and a free of 2097149, so I assume it's free, am I correct ? Thanks in advance.

Most likely, yes it is free. But just run an onspaces -d to drop the chunk and if there's anything wtill in there it will refuse to drop. Once it drops you will be able to reassign the file/device to another dbspace. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Apr 7, 2017 at 3:04 PM, jorge valenzuela <jorgervt@gmail.com> wrote: > Hi, > I like to reassign an index chunk to a data dbspace, but how can I know if > the > index chunk it's free? > I used onstad -d and it shows a size of 2097152 and a free of 2097149, so I > assume it's free, am I correct ? > > Thanks in advance. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11467f589155a8054c98a3f9

You can also do an oncheck -pe which will show you every chunk and what's in it. If all you have is TABLESPACE, then it's empty. j. On 4/7/17 3:29 PM, Art Kagel wrote: > Most likely, yes it is free. But just run an onspaces -d to drop the chunk > and if there's anything wtill in there it will refuse to drop. Once it > drops you will be able to reassign the file/device to another dbspace. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Fri, Apr 7, 2017 at 3:04 PM, jorge valenzuela <jorgervt@gmail.com> wrote: > >> Hi, >> I like to reassign an index chunk to a data dbspace, but how can I know if >> the >> index chunk it's free? >> I used onstad -d and it shows a size of 2097152 and a free of 2097149, so I >> assume it's free, am I correct ? >> >> Thanks in advance. >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --001a11467f589155a8054c98a3f9 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Thanks very much. > El 07/04/2017, a las 12:29, Art Kagel <art.kagel@gmail.com> escribió: > > Most likely, yes it is free. But just run an onspaces -d to drop the chunk > and if there's anything wtill in there it will refuse to drop. Once it > drops you will be able to reassign the file/device to another dbspace. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > >> On Fri, Apr 7, 2017 at 3:04 PM, jorge valenzuela <jorgervt@gmail.com> wrote: >> >> Hi, >> I like to reassign an index chunk to a data dbspace, but how can I know if >> the >> index chunk it's free? >> I used onstad -d and it shows a size of 2097152 and a free of 2097149, so I >> assume it's free, am I correct ? >> >> Thanks in advance. >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a11467f589155a8054c98a3f9 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >