Dropping a blobspace
A DBA on IDS 9.40 (Solaris 8) couldn't drop an apparently empty three-chunk blobspace: "onspaces -d <space>" gave "DBspace is not empty" and dropping by space name failed with "Dbspace does not exist", even in single-user mode. Replies explained that blob pages are only freed after all blobs are deleted and a level-0 archive is taken, and that chunks must be dropped with the chunk syntax "onspaces -d <space> -p <pathname> -o <offset>" (try onstat -d update first); the initial/last remaining chunk can't be dropped individually - you drop the whole space instead. The original poster didn't confirm success, so no outcome is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
All,
We have an unused blobspace and we would like to reallocate the space to
other dbspaces. Unfortunately, we are unable to figure out how to drop
the blobspace. We have IDS 9.40.UC6 running on SunOS 5.8 and we are
using the "Expanded chunk capacity mode". The blobspace has three
chunks. Here is what we've tried:
1. onspaces -d sods_mart_blob1 (received an error Cannot drop the Space.
ISAM error: DBspace is not empty)
2. Tried dropping the individual chunks: onspaces -d sods_mart_blob1_2
(received an error "Dbspace does not exist")
3. The manual says that in order to drop blobspaces, the engine needs to
be in single user mode so we did onmode -s and tried again with the same
errors as above.
We've looked at oncheck -pe and the results show no index or tables
using that blob. Below is the output:
Chunk Pathname Size Used
Free
24 /home/informix/smartp/links/sods_mart_blob1 1023992 4049
1019943
Disk usage for Chunk 24
Total Pages
------------------------------------------------------------------------
-------
OVERHEAD
4049
FREE
1019943
The only thing we see is overhead. Each chunk belonging to this primary
chunk contains overhead.
Any ideas or suggestions would be greatly appreciated.
Rob Schmitz
Data Management
rob.b.schmitz@sprint.com
For blobspace, all blobs have to be deleted and a level-0 archive done
to free the space, correct? Once that's done, drop the chunks in a
"last-added, first-dropped" kind of order.
Perhaps a new 'feature'?!
Bob Roussey
Unix / Informix Administration
Spirit Airlines
Robert.Roussey@SpiritAir.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Schmitz, Ro....
Sent: Tuesday, May 16, 2006 11:01 AM
To: ids@iiug.org
Subject: Dropping a blobspace [6731]
All,
We have an unused blobspace and we would like to reallocate the space to
other dbspaces. Unfortunately, we are unable to figure out how to drop
the blobspace. We have IDS 9.40.UC6 running on SunOS 5.8 and we are
using the "Expanded chunk capacity mode". The blobspace has three
chunks. Here is what we've tried:
1. onspaces -d sods_mart_blob1 (received an error Cannot drop the Space.
ISAM error: DBspace is not empty)
2. Tried dropping the individual chunks: onspaces -d sods_mart_blob1_2
(received an error "Dbspace does not exist")
3. The manual says that in order to drop blobspaces, the engine needs to
be in single user mode so we did onmode -s and tried again with the same
errors as above.
We've looked at oncheck -pe and the results show no index or tables
using that blob. Below is the output:
Chunk Pathname Size Used
Free
24 /home/informix/smartp/links/sods_mart_blob1 1023992 4049
1019943
Disk usage for Chunk 24
Total Pages
------------------------------------------------------------------------
-------
OVERHEAD
4049
FREE
1019943
The only thing we see is overhead. Each chunk belonging to this primary
chunk contains overhead.
Any ideas or suggestions would be greatly appreciated.
Rob Schmitz
Data Management
rob.b.schmitz@sprint.com
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
You can drop the chunks in any order.
When dropping a chunk it is a different syntax:-
onspaces -d <dbspace> -p< pathname> -o <offset>
Try
onstat -d update
first.
Also take a level 0 archive before trying to drop.
----- Original Message -----
From: "Robert Rous...." <Robert.Roussey@SpiritAir.com>
To: <ids@iiug.org>
Sent: Tuesday, May 16, 2006 4:15 PM
Subject: RE: Dropping a blobspace [6732]
>
> For blobspace, all blobs have to be deleted and a level-0 archive done
> to free the space, correct? Once that's done, drop the chunks in a
> "last-added, first-dropped" kind of order.
>
> Perhaps a new 'feature'?!
>
> Bob Roussey
> Unix / Informix Administration
> Spirit Airlines
> Robert.Roussey@SpiritAir.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Schmitz, Ro....
> Sent: Tuesday, May 16, 2006 11:01 AM
> To: ids@iiug.org
> Subject: Dropping a blobspace [6731]
>
> All,
>
> We have an unused blobspace and we would like to reallocate the space to
>
> other dbspaces. Unfortunately, we are unable to figure out how to drop
> the blobspace. We have IDS 9.40.UC6 running on SunOS 5.8 and we are
> using the "Expanded chunk capacity mode". The blobspace has three
> chunks. Here is what we've tried:
>
> 1. onspaces -d sods_mart_blob1 (received an error Cannot drop the Space.
>
> ISAM error: DBspace is not empty)>
> 2. Tried dropping the individual chunks: onspaces -d sods_mart_blob1_2
> (received an error "Dbspace does not exist")
>
> 3. The manual says that in order to drop blobspaces, the engine needs to
>
> be in single user mode so we did onmode -s and tried again with the same
>
> errors as above.
>
> We've looked at oncheck -pe and the results show no index or tables
> using that blob. Below is the output:
>
> Chunk Pathname Size Used
> Free
>
> 24 /home/informix/smartp/links/sods_mart_blob1 1023992 4049
> 1019943
>
> Disk usage for Chunk 24
> Total Pages
>
> ------------------------------------------------------------------------
>
> -------
> OVERHEAD
> 4049
> FREE
> 1019943
>
> The only thing we see is overhead. Each chunk belonging to this primary
> chunk contains overhead.
>
> Any ideas or suggestions would be greatly appreciated.
>
> Rob Schmitz
> Data Management
> rob.b.schmitz@sprint.com
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> [This E-mail has been scanned for viruses but it is your responsibility
> to maintain up to date anti virus software on the device that you are
> currently using to read this email. ]
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/2006
>
>
---
[This E-mail has been scanned for viruses but it is your responsibility
to maintain up to date anti virus software on the device that you are
currently using to read this email. ]
the first chunk that you've created must by the last to drop
use the sintax "onspaces -d <dbspace> -p< pathname> -o <offset>" to second and
3th in any order,
then use the sintax "onspaces -d <dbspace>" to the first you´ve created to
drop the blobspace.
Celso Coimbra
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de David
Williams
Enviada em: terça-feira, 16 de maio de 2006 13:07
Para: ids@iiug.org
Assunto: Re: Dropping a blobspace [6736]
You can drop the chunks in any order.
When dropping a chunk it is a different syntax:-
onspaces -d <dbspace> -p< pathname> -o <offset>
Try
onstat -d update
first.
Also take a level 0 archive before trying to drop.
----- Original Message -----
From: "Robert Rous...." <Robert.Roussey@SpiritAir.com>
To: <ids@iiug.org>
Sent: Tuesday, May 16, 2006 4:15 PM
Subject: RE: Dropping a blobspace [6732]
>
> For blobspace, all blobs have to be deleted and a level-0 archive done
> to free the space, correct? Once that's done, drop the chunks in a
> "last-added, first-dropped" kind of order.
>
> Perhaps a new 'feature'?!
>
> Bob Roussey
> Unix / Informix Administration
> Spirit Airlines
> Robert.Roussey@SpiritAir.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Schmitz, Ro....
> Sent: Tuesday, May 16, 2006 11:01 AM
> To: ids@iiug.org
> Subject: Dropping a blobspace [6731]
>
> All,
>
> We have an unused blobspace and we would like to reallocate the space to
>
> other dbspaces. Unfortunately, we are unable to figure out how to drop
> the blobspace. We have IDS 9.40.UC6 running on SunOS 5.8 and we are
> using the "Expanded chunk capacity mode". The blobspace has three
> chunks. Here is what we've tried:
>
> 1. onspaces -d sods_mart_blob1 (received an error Cannot drop the Space.
>
> ISAM error: DBspace is not empty)>
> 2. Tried dropping the individual chunks: onspaces -d sods_mart_blob1_2
> (received an error "Dbspace does not exist")
>
> 3. The manual says that in order to drop blobspaces, the engine needs to
>
> be in single user mode so we did onmode -s and tried again with the same
>
> errors as above.
>
> We've looked at oncheck -pe and the results show no index or tables
> using that blob. Below is the output:
>
> Chunk Pathname Size Used
> Free
>
> 24 /home/informix/smartp/links/sods_mart_blob1 1023992 4049
> 1019943
>
> Disk usage for Chunk 24
> Total Pages
>
> ------------------------------------------------------------------------
>
> -------
> OVERHEAD
> 4049
> FREE
> 1019943
>
> The only thing we see is overhead. Each chunk belonging to this primary
> chunk contains overhead.
>
> Any ideas or suggestions would be greatly appreciated.
>
> Rob Schmitz
> Data Management
> rob.b.schmitz@sprint.com
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> [This E-mail has been scanned for viruses but it is your responsibility
> to maintain up to date anti virus software on the device that you are
> currently using to read this email. ]
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/2006
>
>
---
[This E-mail has been scanned for viruses but it is your responsibility
to maintain up to date anti virus software on the device that you are
currently using to read this email. ]
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Correct me if I'm wrong here -- when you have the last chunk or your
blobspace/dbspace is now consisting of only one chunk -- then you cannot drop
that chunk, you will have to drop the blobspace/dbspace.
"Celso Cabra...." <ccoimbra@cleartech.com.br> wrote:
the first chunk that you've created must by the last to drop
use the sintax "onspaces -d -p< pathname> -o " to second and
3th in any order,
then use the sintax "onspaces -d " to the first you´ve created to
drop the blobspace.
Celso Coimbra
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de David
Williams
Enviada em: terça-feira, 16 de maio de 2006 13:07
Para: ids@iiug.org
Assunto: Re: Dropping a blobspace [6736]
You can drop the chunks in any order.
When dropping a chunk it is a different syntax:-
onspaces -d -p< pathname> -o
Try
onstat -d update
first.
Also take a level 0 archive before trying to drop.
----- Original Message -----
From: "Robert Rous...."
To:
Sent: Tuesday, May 16, 2006 4:15 PM
Subject: RE: Dropping a blobspace [6732]
>
> For blobspace, all blobs have to be deleted and a level-0 archive done
> to free the space, correct? Once that's done, drop the chunks in a
> "last-added, first-dropped" kind of order.
>
> Perhaps a new 'feature'?!
>
> Bob Roussey
> Unix / Informix Administration
> Spirit Airlines
> Robert.Roussey@SpiritAir.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Schmitz, Ro....
> Sent: Tuesday, May 16, 2006 11:01 AM
> To: ids@iiug.org
> Subject: Dropping a blobspace [6731]
>
> All,
>
> We have an unused blobspace and we would like to reallocate the space to
>
> other dbspaces. Unfortunately, we are unable to figure out how to drop
> the blobspace. We have IDS 9.40.UC6 running on SunOS 5.8 and we are
> using the "Expanded chunk capacity mode". The blobspace has three
> chunks. Here is what we've tried:
>
> 1. onspaces -d sods_mart_blob1 (received an error Cannot drop the Space.
>
> ISAM error: DBspace is not empty)>
> 2. Tried dropping the individual chunks: onspaces -d sods_mart_blob1_2
> (received an error "Dbspace does not exist")
>
> 3. The manual says that in order to drop blobspaces, the engine needs to
>
> be in single user mode so we did onmode -s and tried again with the same
>
> errors as above.
>
> We've looked at oncheck -pe and the results show no index or tables
> using that blob. Below is the output:
>
> Chunk Pathname Size Used
> Free
>
> 24 /home/informix/smartp/links/sods_mart_blob1 1023992 4049
> 1019943
>
> Disk usage for Chunk 24
> Total Pages
>
> ------------------------------------------------------------------------
>
> -------
> OVERHEAD
> 4049
> FREE
> 1019943
>
> The only thing we see is overhead. Each chunk belonging to this primary
> chunk contains overhead.
>
> Any ideas or suggestions would be greatly appreciated.
>
> Rob Schmitz
> Data Management
> rob.b.schmitz@sprint.com
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> [This E-mail has been scanned for viruses but it is your responsibility
> to maintain up to date anti virus software on the device that you are
> currently using to read this email. ]
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/2006
>
>
---
[This E-mail has been scanned for viruses but it is your responsibility
to maintain up to date anti virus software on the device that you are
currently using to read this email. ]
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
A dbspace/blobspace is a pool of chunks, you can't have a dbspaces without
chunks, it must have at least one chunk. To drop the last chunk, you have to
drop the dbspace/blobspace.
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de Kern
Doe
Enviada em: terça-feira, 16 de maio de 2006 13:26
Para: ids@iiug.org
Assunto: Re: RES: Dropping a blobspace [6739]
Correct me if I'm wrong here -- when you have the last chunk or your
blobspace/dbspace is now consisting of only one chunk -- then you cannot drop
that chunk, you will have to drop the blobspace/dbspace.
"Celso Cabra...." <ccoimbra@cleartech.com.br> wrote:
the first chunk that you've created must by the last to drop
use the sintax "onspaces -d -p< pathname> -o " to second and
3th in any order,
then use the sintax "onspaces -d " to the first you´ve created to
drop the blobspace.
Celso Coimbra
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de David
Williams
Enviada em: terça-feira, 16 de maio de 2006 13:07
Para: ids@iiug.org
Assunto: Re: Dropping a blobspace [6736]
You can drop the chunks in any order.
When dropping a chunk it is a different syntax:-
onspaces -d -p< pathname> -o
Try
onstat -d update
first.
Also take a level 0 archive before trying to drop.
----- Original Message -----
From: "Robert Rous...."
To:
Sent: Tuesday, May 16, 2006 4:15 PM
Subject: RE: Dropping a blobspace [6732]
>
> For blobspace, all blobs have to be deleted and a level-0 archive done
> to free the space, correct? Once that's done, drop the chunks in a
> "last-added, first-dropped" kind of order.
>
> Perhaps a new 'feature'?!
>
> Bob Roussey
> Unix / Informix Administration
> Spirit Airlines
> Robert.Roussey@SpiritAir.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Schmitz, Ro....
> Sent: Tuesday, May 16, 2006 11:01 AM
> To: ids@iiug.org
> Subject: Dropping a blobspace [6731]
>
> All,
>
> We have an unused blobspace and we would like to reallocate the space to
>
> other dbspaces. Unfortunately, we are unable to figure out how to drop
> the blobspace. We have IDS 9.40.UC6 running on SunOS 5.8 and we are
> using the "Expanded chunk capacity mode". The blobspace has three
> chunks. Here is what we've tried:
>
> 1. onspaces -d sods_mart_blob1 (received an error Cannot drop the Space.
>
> ISAM error: DBspace is not empty)>
> 2. Tried dropping the individual chunks: onspaces -d sods_mart_blob1_2
> (received an error "Dbspace does not exist")
>
> 3. The manual says that in order to drop blobspaces, the engine needs to
>
> be in single user mode so we did onmode -s and tried again with the same
>
> errors as above.
>
> We've looked at oncheck -pe and the results show no index or tables
> using that blob. Below is the output:
>
> Chunk Pathname Size Used
> Free
>
> 24 /home/informix/smartp/links/sods_mart_blob1 1023992 4049
> 1019943
>
> Disk usage for Chunk 24
> Total Pages
>
> ------------------------------------------------------------------------
>
> -------
> OVERHEAD
> 4049
> FREE
> 1019943
>
> The only thing we see is overhead. Each chunk belonging to this primary
> chunk contains overhead.
>
> Any ideas or suggestions would be greatly appreciated.
>
> Rob Schmitz
> Data Management
> rob.b.schmitz@sprint.com
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> [This E-mail has been scanned for viruses but it is your responsibility
> to maintain up to date anti virus software on the device that you are
> currently using to read this email. ]
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/2006
>
>
---
[This E-mail has been scanned for viruses but it is your responsibility
to maintain up to date anti virus software on the device that you are
currently using to read this email. ]
*******************************************************************************
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.
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