rootspace NIGHTMARE
Bill moved the root dbspace to a new drive by copying the chunk file and editing ONCONFIG; the server started but oncheck, onstat -d and ontape -r still referenced the old chunk location, and a restore failed until he copied the file back. Clive Eisen explained that the chunk paths are stored inside the root dbspace itself, not just ONCONFIG: IDS 9.4 lets you redirect the restore destination, while earlier versions require binary-editing the root dbspace (engine offline, with backups, and unsupported by IBM). The rest of the thread is banter about doing that by hand.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
When I copied the rootspace to another drive and pointed the ONCONFIG at it,
and restarted the IDS all works fine except:
1. oncheck says it cannot find the space.
2. onstat -d shows the wrong location.
3. ontape -r fails with a message that it cannot find the rootspace
where is IDS storing the bad info?
#3 is the most deadly.
I had to restore from backup today and solved it by copying the root space
to its old location.
This is the third time I have asked this question.
I cannot believe that nobody has moved spaces before.
The install does not let me specify space info, so I just create new big
ones
on other drives and then copy the root where I want it and modify ONCONFIG.
If that is not the correct procedure, I want to know.
Thanks,
Bill
sending to informix-list
Bill Hamilton wrote:
> When I copied the rootspace to another drive and pointed the ONCONFIG at it,
> and restarted the IDS all works fine except:
> 1. oncheck says it cannot find the space.
> 2. onstat -d shows the wrong location.
> 3. ontape -r fails with a message that it cannot find the rootspace
>
> where is IDS storing the bad info?
>
> #3 is the most deadly.
> I had to restore from backup today and solved it by copying the root space
> to its old location.
>
> This is the third time I have asked this question.
> I cannot believe that nobody has moved spaces before.
> The install does not let me specify space info, so I just create new big
> ones
> on other drives and then copy the root where I want it and modify ONCONFIG.
> If that is not the correct procedure, I want to know.
> Thanks,
> Bill
>
> sending to informix-list
You don't specify
Platform
Version
or anything else useful.
Also if you had searched the archives you would have found your answer.
e.g.
http://groups.google.com/groups?q=informix+clive+eisen&start=20&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=aps4h5%24l7n%241%40terabinaries.xmission.com&rnum=21
Please try to help yourself b4 you ask others to do it for you.
9.4 which I presume you are not using allows you to change the
destination for the restore.
Previous versions don't. You can however binary edit the root dbspace
and alter all the chunk locations.
Do take backups.
Do it with the engine offline.
Don't ask IBM for support after you have done it.
--
Clive
"Clive Eisen" <clive@serendipita.com> wrote in message news:405b280e$0$31688$fa0fcedb@lovejoy.zen.co.uk... > Previous versions don't. You can however binary edit the root dbspace > and alter all the chunk locations. ... if you think you're hard enough!
Neil Truby wrote: > "Clive Eisen" <clive@serendipita.com> wrote in message > news:405b280e$0$31688$fa0fcedb@lovejoy.zen.co.uk... > > >>Previous versions don't. You can however binary edit the root dbspace >>and alter all the chunk locations. > > > ... if you think you're hard enough! > > wimp - did it 3 times a week for 2 years....
Clive Eisen wrote: > Neil Truby wrote: > >> "Clive Eisen" <clive@serendipita.com> wrote in message >> news:405b280e$0$31688$fa0fcedb@lovejoy.zen.co.uk... >> >>> Previous versions don't. You can however binary edit the root dbspace >>> and alter all the chunk locations. >> >> ... if you think you're hard enough! >> > wimp - did it 3 times a week for 2 years.... Yeah, you still got that script lying around....? :o) -- Ciao, Obnoxio Tip of the day: don't think that an in-place Linux upgrade is a likely to be painless like an Informix in-place upgrade. :o(
Obnoxio The Clown wrote: > Clive Eisen wrote: > >> Neil Truby wrote: >> >>> "Clive Eisen" <clive@serendipita.com> wrote in message >>> news:405b280e$0$31688$fa0fcedb@lovejoy.zen.co.uk... >>> >>>> Previous versions don't. You can however binary edit the root dbspace >>>> and alter all the chunk locations. >>> >>> >>> ... if you think you're hard enough! >>> >> wimp - did it 3 times a week for 2 years.... > > > Yeah, you still got that script lying around....? :o) > No - that would have involved me removing the intellectual property of my then employer - not something anyone ever does - do they?
Clive Eisen wrote: > Obnoxio The Clown wrote: > >> Clive Eisen wrote: >> >>> Neil Truby wrote: >>> >>>> "Clive Eisen" <clive@serendipita.com> wrote in message >>>> news:405b280e$0$31688$fa0fcedb@lovejoy.zen.co.uk... >>>> >>>>> Previous versions don't. You can however binary edit the root dbspace >>>>> and alter all the chunk locations. >>>> >>>> >>>> >>>> ... if you think you're hard enough! >>>> >>> wimp - did it 3 times a week for 2 years.... >> >> >> >> Yeah, you still got that script lying around....? :o) >> > No - that would have involved me removing the intellectual property of > my then employer - not something anyone ever does - do they? "Intellectual"? :o> -- Ciao, Obnoxio Tip of the day: don't think that an in-place Linux upgrade is a likely to be painless like an Informix in-place upgrade. :o(
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape