Moving a cooked chunk

Hi, I needed to move the second chunk of the rootdbs in my TEST instance (we run a LIVE and a TEST instance on the same box) It had stupidly been created (by me) in the LIVE filesystem :( After a fair bit of searching it seemed like setting up MIRROR was the best option. I did that with onspaces -m (making sure both chunks were done in the same command line). It looked ok with onstat -D I couldn't find a good procedure covering the next steps. Marking the original chunks as down, then dropping them seemed promising but Informix knows they're not empty and won't drop them. I've renamed the original cooked files but that hasn't helped. What do I need to do to clean this mess up? I thought it would be simple to promote the backups to primaries and disable the MIRROR - what am I missing? Thanks

Matt IDS Version and O/S Type and version are always useful :-) Are you on *nix and are you using links (as recommended) ? If so you just need to stop the db, move the datafile to the desired new location and then relink back to you links directory. Restart the DB and all is well. I tend to use raw chunks (for speed) with links to make their naming short and friendly and mirror within the raid so I am not familiar with mirroring cunks under informix. The manual referring to mirroring is at http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.admin.doc/id s_admin_0827.htm it seems to intimate you just need to take down the chunk http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.admin.doc/id s_admin_0841.htm. However other pages intimate that only the chunk definded as the mirror can be removed/dropped and that there is no way to switch the two chunks, once primary, always primary. Keith On 15 September 2015 at 05:45, MATT SINCLAIR <matt@hobson.com.au> wrote: > Hi, > I needed to move the second chunk of the rootdbs in my TEST instance (we > run a > LIVE and a TEST instance on the same box) It had stupidly been created (by > me) > in the LIVE filesystem :( > After a fair bit of searching it seemed like setting up MIRROR was the best > option. I did that with onspaces -m (making sure both chunks were done in > the > same command line). It looked ok with onstat -D > I couldn't find a good procedure covering the next steps. Marking the > original > chunks as down, then dropping them seemed promising but Informix knows > they're > not empty and won't drop them. I've renamed the original cooked files but > that > hasn't helped. > What do I need to do to clean this mess up? I thought it would be simple to > promote the backups to primaries and disable the MIRROR - what am I > missing? > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b5d8d398c3424051fc52318

Thanks Keith, IDS is 12.10 on Linux. The bulk of the setup was done by the ERP vendor and has NOT been done with links :( I guess that this is one of the reasons that links are recommended. Mirroring seems like a dead end. I could fix the immediate issue by leaving a link in the LIVE filesystem which points to the TEST fs, but it's not as clean as I would like. Surely I should be able to at least restore the chunk (or the entire rootdbs) to a new location ??

Matt: Restore does have a rename option which can be used to remap path during the restore. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/15/2015 04:01:00 PM: > From: "MATT SINCLAIR" <matt@hobson.com.au> > To: ids@iiug.org > Date: 09/15/2015 04:01 PM > Subject: Re: Moving a cooked chunk [35792] > Sent by: ids-bounces@iiug.org > > Thanks Keith, > IDS is 12.10 on Linux. The bulk of the setup was done by the ERP vendor and > has NOT been done with links :( > I guess that this is one of the reasons that links are recommended. > Mirroring seems like a dead end. > I could fix the immediate issue by leaving a link in the LIVE > filesystem which > points to the TEST fs, but it's not as clean as I would like. > Surely I should be able to at least restore the chunk (or the entirerootdbs) > to a new location ?? > > > ***************************************************************************= **** > Forum Note: Use "Reply" to post a response in the discussion forum. >

You can change the chunk paths when you restore - just use the rename option Cheers Paul Paul Watson Oninit www.oninit.com +1 913 387 7529 Oninit® is a Registered Trademark of Oninit LLC > On Sep 15, 2015, at 18:01, MATT SINCLAIR <matt@hobson.com.au> wrote: > > Thanks Keith, > IDS is 12.10 on Linux. The bulk of the setup was done by the ERP vendor and > has NOT been done with links :( > I guess that this is one of the reasons that links are recommended. > Mirroring seems like a dead end. > I could fix the immediate issue by leaving a link in the LIVE filesystem which > points to the TEST fs, but it's not as clean as I would like. > Surely I should be able to at least restore the chunk (or the entire rootdbs) > to a new location ?? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.