Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / August 2004

Tip: Looking for answers? Try searching our database.

Imported restore using ISM

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
malcolm weallans - 27 Aug 2004 11:23 GMT
For reasons that are still not exactly clear to me I
have been asked to migrate a complete IDS system from
one IDS 9.40 server to another.  I think it has
something to do with a SAGE support statement that
they don't support moving databases using
dbexport/dbimport.

Anyway, has anybody else been through the imported
restore using ISM procedure.  I feel that every page I
turn is yet another challenge.  

Firstly I have discovered that whilst it is possible
to have IDS 9.3 and IDS 9.4 on the same machine, and
it is possible to have both running at the same time,
the two versions use different versions of ISM.  And
as the current version is pointed to by a link called
/nsr it is only possible to have one version of ISM
running.

Thta was problem number ~15.  I had already
encountered the difficulties of backing up dbspaces of
more than 2Gbytes using ISM, the problem of how to tar
the output of ISM into one file for ease of transfer
across the network, and numerous other little UNIX
type quirks.

Then I discovered that if you follow the instructions
in the manual you have to be very careful about
continuation lines.  The nsradmin command on page 5-12
of the Informix Storage Manager manual for IDS 9.4 is
in fact one line.  

And then I following the instruction on page 5-13 I
worked out that I would be tryin to execute the
command

ln -s /usr/informix/informix94 /usr/informix

Which even I realised would not have the desired
effect.  

So back into UNIX admin problems.  And /usr/informix
is a mount point so I couldn't even rename it.

If I ever finish this migration please suscribe freely
to "Big Issue".  It'll probably be me begging.

regards

Malcolm

But if anybody has any bright ideas of how to migrate
IDS systems from machine  to machine b easily please
let me know.

sending to informix-list
Clive Eisen - 27 Aug 2004 12:14 GMT
> Malcolm
>
> But if anybody has any bright ideas of how to migrate
> IDS systems from machine  to machine b easily please
> let me know.

If I have understood you correctly

Can you take the source database down?

dd the chunks over the network?

Bring up 9.3 and check all ok

Do inplace upgrade to 9.4
Neil Truby - 27 Aug 2004 12:29 GMT
Would only work if the original chunks are on file system.
However, if you can take the network hit, Informix mirroring could be made
to make this idea work I guess ...
Personally I've not found redirected restores diffficult, but admittedly
we've done them with ontape.

Signature

Neil Truby                       t:01932 724027
Director                         m:07798 811708
Ardenta Limited              e:neil.truby@ardenta.com

> > Malcolm
> >
[quoted text clipped - 11 lines]
>
> Do inplace upgrade to 9.4
Clive Eisen - 27 Aug 2004 23:15 GMT
> Would only work if the original chunks are on file system.
> However, if you can take the network hit, Informix mirroring could be made
> to make this idea work I guess ...
> Personally I've not found redirected restores diffficult, but admittedly
> we've done them with ontape.

No - I've done it raw - why do you think it only works with cooked?
Neil Truby - 27 Aug 2004 23:20 GMT
> > Would only work if the original chunks are on file system.
> > However, if you can take the network hit, Informix mirroring could be made
[quoted text clipped - 3 lines]
> >
> No - I've done it raw - why do you think it only works with cooked?

>> ... dd the chunks over the network ...

Here I'd taken you to mean via NFS.  But perhaps you meant a dd piped
through a remsh between raw devices, in which case sorry, I misunderstood.
Clive Eisen - 28 Aug 2004 09:42 GMT
> Here I'd taken you to mean via NFS.  But perhaps you meant a dd piped
> through a remsh between raw devices, in which case sorry, I misunderstood.
exactly
Savio Pinto \(s\) - 27 Aug 2004 16:22 GMT
we used to move our 600GB-800GB informix databases across machines using ISM quite often, here are few steps on how to do it, hope it helps

1) copy the ism backup directory from source to target machine
2) initialize the ism on the target machine
3) remove the default device from the target machine
4) ism data files have hostname embedded in it, you will need to run the nsradmin with -s and -i options to change it(just one command will do the trick)
5) recreate the ism catalog data using the ism_catalog -recreate_from <backup_dir_name>
6) sync the media with nsrim command
7) make device appendable using ism_op command
8) replace source instance name with target instance name in ixbar
9) copy oncfg file from source system to target system
10) start the restore

-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of malcolm weallans
Sent: Friday, August 27, 2004 5:23 AM
To: informix-list@iiug.org
Subject: Imported restore using ISM

For reasons that are still not exactly clear to me I
have been asked to migrate a complete IDS system from
one IDS 9.40 server to another.  I think it has
something to do with a SAGE support statement that
they don't support moving databases using
dbexport/dbimport.

Anyway, has anybody else been through the imported
restore using ISM procedure.  I feel that every page I
turn is yet another challenge.  

Firstly I have discovered that whilst it is possible
to have IDS 9.3 and IDS 9.4 on the same machine, and
it is possible to have both running at the same time,
the two versions use different versions of ISM.  And
as the current version is pointed to by a link called
/nsr it is only possible to have one version of ISM
running.

Thta was problem number ~15.  I had already
encountered the difficulties of backing up dbspaces of
more than 2Gbytes using ISM, the problem of how to tar
the output of ISM into one file for ease of transfer
across the network, and numerous other little UNIX
type quirks.

Then I discovered that if you follow the instructions
in the manual you have to be very careful about
continuation lines.  The nsradmin command on page 5-12
of the Informix Storage Manager manual for IDS 9.4 is
in fact one line.  

And then I following the instruction on page 5-13 I
worked out that I would be tryin to execute the
command

ln -s /usr/informix/informix94 /usr/informix

Which even I realised would not have the desired
effect.  

So back into UNIX admin problems.  And /usr/informix
is a mount point so I couldn't even rename it.

If I ever finish this migration please suscribe freely
to "Big Issue".  It'll probably be me begging.

regards

Malcolm

But if anybody has any bright ideas of how to migrate
IDS systems from machine  to machine b easily please
let me know.

sending to informix-list

sending to informix-list
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.