Problem dropping a blobspace

Posted in 2008

Summary

Samuel Jakabowski could not drop a 50 GB blobspace on IDS 10.0 FC4 on Solaris 10 because onspaces said it was not empty, although oncheck showed nothing in it. Clifton Bean asked for oncheck -pe output, which showed only overhead pages used. Dattatreya Govindappanavar asked for the exact error and quoted the manual that tables with TEXT or BYTE columns using it must be dropped first. Unresolved.

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

Topics: Storage & Space Management, Server Administration, Versions, Editions & End-of-Life

SAMUEL JAKABOWSKI — Fri, 11 Jul 2008 18:42:49 — source: IIUG Forums & Mailing Lists

We have a blobspace that cannot be dropped. Oncheck does not show anything in the space but onspaces claims that it is not empty. Spaces are on a SAN with symbolic links to them. We mirror the SAN to another SAN which is off-site. This is the only backup. The instance is over 4 TB in size and is expected to be in operation 24X7. IDS 10.0 FC4 Solaris 10 Is there an easy way to drop this 50 GB space?

↪ replying to SAMUEL JAKABOWSKI

Clifton Bean — Fri, 11 Jul 2008 18:51:07 — source: IIUG Forums & Mailing Lists

Please list the output of an oncheck -pe for this blobspace. Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics Main (972) 812-1411 x244 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SAMUEL JAKABOWSKI Sent: Friday, July 11, 2008 1:43 PM To: ids@iiug.org Subject: Problem dropping a blobspace [12671] We have a blobspace that cannot be dropped. Oncheck does not show anything in the space but onspaces claims that it is not empty. Spaces are on a SAN with symbolic links to them. We mirror the SAN to another SAN which is off-site. This is the only backup. The instance is over 4 TB in size and is expected to be in operation 24X7. IDS 10.0 FC4 Solaris 10 Is there an easy way to drop this 50 GB space? ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Clifton Bean

SAMUEL JAKABOWSKI — Fri, 11 Jul 2008 19:12:16 — source: IIUG Forums & Mailing Lists

Output from oncheck -pe BLOBspace Usage Report: blobspace Owner: informix Created: 01/23/2008 Chunk Pathname Size Used Free 8 /opt/IBM/informix/links/blobspace 26000000 3225 25996775 Disk usage for Chunk 8 Total Pages ------------------------------------------------------------------------------- OVERHEAD 3225 FREE 25996775

↪ replying to SAMUEL JAKABOWSKI

Dattatreya Govindappanavar — Fri, 11 Jul 2008 20:23:25 — source: IIUG Forums & Mailing Lists

What is the exact error that you are getting when you try to drop the blobspace ? Following is from Administrator's guide, it might help: "Before you drop a blobspace, you must drop all tables that have a TEXT or BYTE column that references the blobspace." "SAMUEL JAKABOWSKI" <samuel_jakabowski@wildblue.net> Sent by: ids-bounces@iiug.org 07/11/2008 02:12 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject Re: RE: Problem dropping a blobspace [12673] Output from oncheck -pe BLOBspace Usage Report: blobspace Owner: informix Created: 01/23/2008 Chunk Pathname Size Used Free 8 /opt/IBM/informix/links/blobspace 26000000 3225 25996775 Disk usage for Chunk 8 Total Pages ------------------------------------------------------------------------------- OVERHEAD 3225 FREE 25996775 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

blobspace