Oninit cdi / Archive
Talk to an expert →

Problem dropping a blobspace

Posted in 2008

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

SAMUEL JAKABOWSKI — — 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 — — 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 — — 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 — — 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