If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Drop Chunk

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-09-04, 05:16
g.rath g.rath is offline
Registered User
 
Join Date: Feb 2004
Location: Austria
Posts: 2
Drop Chunk

Hi,

I need help!!!

Informix Online Version 5.10.
I have add a new chunk with "tbspaces".
I used a wrong offset, now is the new chunk number 22 on the same space as the old chunk number 11.

view with tbstat -d:
Chunks
Adress chk/dbs offset size free bpages flags pathname
.
.
10040ac8 11 2 0 1000000 48 PO- /dev/ios0/rsraid01l0s9
.
.
10041150 22 3 500000 131000 130997 PO- /dev/ios0/rsraid01l0s9
.
.



Can I remove the new chunk number 22 ?

Or can I drop down the chunk, that it doesn't use, like "onspaces -d" at version 7.x ?
Reply With Quote
  #2 (permalink)  
Old 02-09-04, 05:52
Roelwe Roelwe is offline
Registered User
 
Join Date: Aug 2002
Location: Belgium
Posts: 534
Best thing you can do is drop the chunk on th einstance level. Isn't there a flag on tbspaces to drop the chunk?
__________________
rws
Reply With Quote
  #3 (permalink)  
Old 02-09-04, 06:02
g.rath g.rath is offline
Registered User
 
Join Date: Feb 2004
Location: Austria
Posts: 2
Quote:
Originally posted by Roelwe
Best thing you can do is drop the chunk on th einstance level. Isn't there a flag on tbspaces to drop the chunk?
I think at version 5.x is no flag on tbspaces t drop a chunk.
Reply With Quote
  #4 (permalink)  
Old 02-09-04, 06:25
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Re: Drop Chunk

Quote:
Originally posted by g.rath
Hi,

I need help!!!

Informix Online Version 5.10.
I have add a new chunk with "tbspaces".
I used a wrong offset, now is the new chunk number 22 on the same space as the old chunk number 11.

view with tbstat -d:
Chunks
Adress chk/dbs offset size free bpages flags pathname
.
.
10040ac8 11 2 0 1000000 48 PO- /dev/ios0/rsraid01l0s9
.
.
10041150 22 3 500000 131000 130997 PO- /dev/ios0/rsraid01l0s9
.
.



Can I remove the new chunk number 22 ?

Or can I drop down the chunk, that it doesn't use, like "onspaces -d" at version 7.x ?
Hi,

Yes, you can drop the chunk using "onmonitor" and use the proper offset value.
I suggest that run level 0 back-up before and after.

Gustavo.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On