Dropping a chunk

Posted in 2014

Summary

A user couldn't drop a chunk he had just added to dbspace dbsdata01: running "onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02" produced no error, just the onspaces usage/syntax output. Responders asked whether the chunk was empty (oncheck -ce), what onstat -d showed, and suggested adding the offset. Neil Truby pointed out that the posted command omitted the mandatory -o offset. Retrying with "-o 0" worked, and the chunk was dropped successfully.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Server Administration

Jorge — Sun, 29 Jun 2014 02:12:14 — source: IIUG Forums & Mailing Lists

Hi, Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now I like to drop the chunk in this way: onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 What am I doing wrong? Thanks in advance. Enviado desde mi iPhone

↪ replying to Jorge

Lloyd S — Sun, 29 Jun 2014 05:11:15 — source: IIUG Forums & Mailing Lists

Jorge, Is the chunk empty?  What is the error you are getting. Did you create it with an offset?Try onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02  -o 0 Run oncheck -ce to find out the contents of the chunk. Lloyd From: "Jorge" <jorgervt@gmail.com> Sent: Sun, 29 Jun 2014 07:42:45 To: ids@iiug.org Subject: Dropping a chunk [33313] Hi, Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now I like to drop the chunk in this way: onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 What am I doing wrong? Thanks in advance. Enviado desde mi iPhone *******************************************************************************  Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Lloyd S

Jorge — Sun, 29 Jun 2014 12:09:52 — source: IIUG Forums & Mailing Lists

Yes it's empty. Yes, I created with an 0 offset because it is on another device. Enviado desde mi iPhone El 28/06/2014, a las 22:11, "Lloyd S" <lloyd_s@rediffmail.com> escribió: > Jorge, > Is the chunk empty?  What is the error you are getting. Did you create it > with an offset?Try onspaces -d dbsdata01 -p > /opt/informix/data/ldatadbs02  -o 0 > > Run oncheck -ce to find out the contents of the chunk. > > Lloyd > > From: "Jorge" <jorgervt@gmail.com> > Sent: Sun, 29 Jun 2014 07:42:45 > To: ids@iiug.org > Subject: Dropping a chunk [33313] > Hi, > > Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now > > I like to drop the chunk in this way: > > onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02> > What am I doing wrong? > > Thanks in advance. > > Enviado desde mi iPhone > > > ******************************************************************************* > >  Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Lloyd S

Jorge — Sun, 29 Jun 2014 13:56:31 — source: IIUG Forums & Mailing Lists

I don't getting any error, I get the same output that onspaces -- gives. It's like a syntax error. Enviado desde mi iPhone El 28/06/2014, a las 22:11, "Lloyd S" <lloyd_s@rediffmail.com> escribió: > Jorge, > Is the chunk empty?  What is the error you are getting. Did you create it > with an offset?Try onspaces -d dbsdata01 -p > /opt/informix/data/ldatadbs02  -o 0 > > Run oncheck -ce to find out the contents of the chunk. > > Lloyd > > From: "Jorge" <jorgervt@gmail.com> > Sent: Sun, 29 Jun 2014 07:42:45 > To: ids@iiug.org > Subject: Dropping a chunk [33313] > Hi, > > Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now > > I like to drop the chunk in this way: > > onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02> > What am I doing wrong? > > Thanks in advance. > > Enviado desde mi iPhone > > > ******************************************************************************* > >  Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Jorge

Lloyd S — Sun, 29 Jun 2014 14:23:19 — source: IIUG Forums & Mailing Lists

Did you try to drop with the offset 0 onspaces -d dbsdata01 -p > /opt/informix/data/ldatadbs02 -o 0 How have you created the chunk?   Can you create a new chunk and drop it? Lloyd From: "Jorge" <jorgervt@gmail.com> Sent: Sun, 29 Jun 2014 19:27:02 To: ids@iiug.org Subject: Re: Dropping a chunk [33316] I don't getting any error, I get the same output that onspaces -- gives. It's like a syntax error. Enviado desde mi iPhone El 28/06/2014, a las 22:11, "Lloyd S" <lloyd_s@rediffmail.com> escribiãº > Jorge, > Is the chunk empty? &nbsp;What is the error you are getting. Did you create it > with an offset?Try&nbsp;onspaces -d dbsdata01 -p > /opt/informix/data/ldatadbs02&nbsp; -o 0 > > Run oncheck -ce to find out the contents of the chunk. > > Lloyd > > From: "Jorge" &lt;');">jorgervt@gmail.com>; > Sent: Sun, 29 Jun 2014 07:42:45 > To: ids@iiug.org > Subject: Dropping a chunk [33313] > Hi, > > Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now > > I like to drop the chunk in this way: > > onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 > > What am I doing wrong? > > Thanks in advance. > > Enviado desde mi iPhone > > > ******************************************************************************* > > &nbsp;Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > *******************************************************************************  Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Lloyd S

Jorge — Mon, 30 Jun 2014 15:44:06 — source: IIUG Forums & Mailing Lists

Yes I try with offset 0. Yes I created the chunk. I created the chunk using onmoniror-add a chunk. I can create a new chunk, but I can't drop it. Enviado desde mi iPhone El 29/06/2014, a las 07:23, "Lloyd S" <lloyd_s@rediffmail.com> escribió: > Did you try to drop with the offset 0 > onspaces -d dbsdata01 -p > /opt/informix/data/ldatadbs02 -o 0> > How have you created the chunk?   Can you create a new chunk and drop it? > Lloyd > > From: "Jorge" <jorgervt@gmail.com> > Sent: Sun, 29 Jun 2014 19:27:02 > To: ids@iiug.org > Subject: Re: Dropping a chunk [33316] > I don't getting any error, I get the same output that onspaces -- gives. It's > > like a syntax error. > > Enviado desde mi iPhone > > El 28/06/2014, a las 22:11, "Lloyd S" <lloyd_s@rediffmail.com> escribiãº > > > Jorge, > > > Is the chunk empty? &nbsp;What is the error you are getting. Did you > create > > it > > > with an offset?Try&nbsp;onspaces -d dbsdata01 -p > > > /opt/informix/data/ldatadbs02&nbsp; -o 0 > > > > > > Run oncheck -ce to find out the contents of the chunk. > > > > > > Lloyd > > > > > > From: "Jorge" &lt;');">jorgervt@gmail.com>; > > > Sent: Sun, 29 Jun 2014 07:42:45 > > > To: ids@iiug.org > > > Subject: Dropping a chunk [33313] > > > Hi, > > > > > > Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now > > > > > > I like to drop the chunk in this way: > > > > > > onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 > > > > > > What am I doing wrong? > > > > > > Thanks in advance. > > > > > > Enviado desde mi iPhone > > > > > > > > > > > > ******************************************************************************* > > > > > > &nbsp;Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > >  Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Jorge

Kern Do — Mon, 30 Jun 2014 17:05:04 — source: IIUG Forums & Mailing Lists

What is your onstat -d | grep dbsdata01 Looks like? > On Jun 30, 2014, at 11:44 AM, "Jorge" <jorgervt@gmail.com> wrote: > > Yes I try with offset 0. > Yes I created the chunk. I created the chunk using onmoniror-add a chunk. > I can create a new chunk, but I can't drop it. > > Enviado desde mi iPhone > >> El 29/06/2014, a las 07:23, "Lloyd S" <lloyd_s@rediffmail.com> escribió: >> >> Did you try to drop with the offset 0 >> onspaces -d dbsdata01 -p > /opt/informix/data/ldatadbs02 -o 0>> >> How have you created the chunk?   Can you create a new chunk and drop > it? >> Lloyd >> >> From: "Jorge" <jorgervt@gmail.com> >> Sent: Sun, 29 Jun 2014 19:27:02 >> To: ids@iiug.org >> Subject: Re: Dropping a chunk [33316] >> I don't getting any error, I get the same output that onspaces -- gives. > It's >> >> like a syntax error. >> >> Enviado desde mi iPhone >> >> El 28/06/2014, a las 22:11, "Lloyd S" <lloyd_s@rediffmail.com> > escribiãº >> >> > Jorge, >> >> > Is the chunk empty? &nbsp;What is the error you are getting. Did > you >> create >> >> it >> >> > with an offset?Try&nbsp;onspaces -d dbsdata01 -p >> >> > /opt/informix/data/ldatadbs02&nbsp; -o 0 >> >> > >> >> > Run oncheck -ce to find out the contents of the chunk. >> >> > >> >> > Lloyd >> >> > >> >> > From: "Jorge" &lt;');">jorgervt@gmail.com>; >> >> > Sent: Sun, 29 Jun 2014 07:42:45 >> >> > To: ids@iiug.org >> >> > Subject: Dropping a chunk [33313] >> >> > Hi, >> >> > >> >> > Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now >> >> > >> >> > I like to drop the chunk in this way: >> >> > >> >> > onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 >> >> > >> >> > What am I doing wrong? >> >> > >> >> > Thanks in advance. >> >> > >> >> > Enviado desde mi iPhone >> >> > >> >> > >> >> > > ******************************************************************************* >> >> > >> >> > &nbsp;Forum Note: Use "Reply" to post a response in the discussion >> forum. >> >> > >> >> > >> >> > > ******************************************************************************* >> >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > ******************************************************************************* >> >>  Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Jorge

NEIL TRUBY — Mon, 30 Jun 2014 19:01:58 — source: IIUG Forums & Mailing Lists

>> onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 Although you later say that you specified the offset, you *don't* in this example.

↪ replying to NEIL TRUBY

Jorge — Mon, 30 Jun 2014 19:03:50 — source: IIUG Forums & Mailing Lists

I try again with offset 0 and it works. Thank you very much. Enviado desde mi iPhone El 30/06/2014, a las 12:01, "NEIL TRUBY" <neil.truby@ardenta.com> escribió: >>> onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02> > Although you later say that you specified the offset, you *don't* in this > example. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Dropping a chunk

Related threads

Glossary

Your privacy choices