cannot drop a chunk from sbspace used for enterpri
Hi,
We're using IDS 9.40.UC6 on Redhat 7.3 (i386), and are using ER to
replicate some tables, using CDR_QDATA_SBSPACE ersbspace .
I'm trying to drop one of the chunks from this sbspace but am getting
this error:
[informix@das-chcgate-pri informix]$ onspaces -d ersbspace
-p /opt/informix/ersbspace7 -o 0 -y
Chunk not dropped.
Smart Large Objects: Metadata area in the chunk contains data.
oncheck -pe ersbspace returns this for that chunk:
Chunk Pathname Size Used
Free
24 /opt/informix/ersbspace7 1048575 see below
see below
Description Offset
Size
------------------------------------------------------------- --------
--------
RESERVED PAGES 0
2
CHUNK FREELIST PAGE 2
1
SBLOBSpace FREE USER DATA (AREA 1) 3
198082
SBLOBSpace RESERVED USER DATA (AREA 1) 198085
209712
ersbspace:'informix'.LO_hdr_partn 407797
84278
SBLOBSpace FREE META DATA 492075
148706
SBLOBSpace RESERVED USER DATA (AREA 2) 640781
209712
SBLOBSpace FREE USER DATA (AREA 2) 850493
198082
Total Used: 84281
Total SBLOBSpace FREE META DATA: 148706
Total SBLOBSpace FREE USER DATA: 815588
I've tried this also after deleting all replicates, and deleting the
servers from this host, so I think all replication is stopped at this
point. Everything looks the same, with or without replication running.
Is there any way to drop this chunk? Do I need to tell ER to stop using
that chunk or move the metadata out somehow?
Thanks,
Brian
I believe all smartblobs from the entire dbspace need to be deleted, then a
level-0 archive should do it.
Bob
----- Original Message -----
From: "Brian Witt" <bwitt@bart.gov>
To: ids@iiug.org
Sent: Tuesday, March 23, 2010 2:17:42 PM GMT -05:00 US/Canada Eastern
Subject: cannot drop a chunk from sbspace used for ente.... [19396]
Hi,
We're using IDS 9.40.UC6 on Redhat 7.3 (i386), and are using ER to
replicate some tables, using CDR_QDATA_SBSPACE ersbspace .
I'm trying to drop one of the chunks from this sbspace but am getting
this error:
[informix@das-chcgate-pri informix]$ onspaces -d ersbspace
-p /opt/informix/ersbspace7 -o 0 -y
Chunk not dropped.
Smart Large Objects: Metadata area in the chunk contains data.
oncheck -pe ersbspace returns this for that chunk:
Chunk Pathname Size Used
Free
24 /opt/informix/ersbspace7 1048575 see below
see below
Description Offset
Size
------------------------------------------------------------- --------
--------
RESERVED PAGES 0
2
CHUNK FREELIST PAGE 2
1
SBLOBSpace FREE USER DATA (AREA 1) 3
198082
SBLOBSpace RESERVED USER DATA (AREA 1) 198085
209712
ersbspace:'informix'.LO_hdr_partn 407797
84278
SBLOBSpace FREE META DATA 492075
148706
SBLOBSpace RESERVED USER DATA (AREA 2) 640781
209712
SBLOBSpace FREE USER DATA (AREA 2) 850493
198082
Total Used: 84281
Total SBLOBSpace FREE META DATA: 148706
Total SBLOBSpace FREE USER DATA: 815588
I've tried this also after deleting all replicates, and deleting the
servers from this host, so I think all replication is stopped at this
point. Everything looks the same, with or without replication running.
Is there any way to drop this chunk? Do I need to tell ER to stop using
that chunk or move the metadata out somehow?
Thanks,
Brian
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks, makes sense; sounds like I need to delete this:
ersbspace:'informix'.LO_hdr_partn
I can't seem to figure it out. I think I need to find the table that is
associated with this object, but how do I do that? Then once I drop
that table, this object should be deleted, correct?
Thanks,
Brian
On Tue, 2010-03-23 at 16:05 -0400, rroussey@comcast.net wrote:
> I believe all smartblobs from the entire dbspace need to be deleted, then a
> level-0 archive should do it.
>
> Bob
>
> ----- Original Message -----
> From: "Brian Witt" <bwitt@bart.gov>
> To: ids@iiug.org
> Sent: Tuesday, March 23, 2010 2:17:42 PM GMT -05:00 US/Canada Eastern
> Subject: cannot drop a chunk from sbspace used for ente.... [19396]
>
> Hi,
>
> We're using IDS 9.40.UC6 on Redhat 7.3 (i386), and are using ER to
> replicate some tables, using CDR_QDATA_SBSPACE ersbspace .
>
> I'm trying to drop one of the chunks from this sbspace but am getting
> this error:
>
> [informix@das-chcgate-pri informix]$ onspaces -d ersbspace
> -p /opt/informix/ersbspace7 -o 0 -y
> Chunk not dropped.
> Smart Large Objects: Metadata area in the chunk contains data.
>
> oncheck -pe ersbspace returns this for that chunk:>
> Chunk Pathname Size Used
> Free
>
> 24 /opt/informix/ersbspace7 1048575 see below
> see below
>
> Description Offset
> Size
> ------------------------------------------------------------- --------
> --------
> RESERVED PAGES 0
> 2
> CHUNK FREELIST PAGE 2
> 1
> SBLOBSpace FREE USER DATA (AREA 1) 3
> 198082
> SBLOBSpace RESERVED USER DATA (AREA 1) 198085
> 209712
> ersbspace:'informix'.LO_hdr_partn 407797
> 84278
> SBLOBSpace FREE META DATA 492075
> 148706
> SBLOBSpace RESERVED USER DATA (AREA 2) 640781
> 209712
> SBLOBSpace FREE USER DATA (AREA 2) 850493
> 198082
>
> Total Used: 84281
> Total SBLOBSpace FREE META DATA: 148706
> Total SBLOBSpace FREE USER DATA: 815588
>
> I've tried this also after deleting all replicates, and deleting the
> servers from this host, so I think all replication is stopped at this
> point. Everything looks the same, with or without replication running.
>
> Is there any way to drop this chunk? Do I need to tell ER to stop using
> that chunk or move the metadata out somehow?
>
> Thanks,
> Brian
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>