IDS Forum

Re: Migrating data from IDS 7.31 to 9.4

Posted By: Jonathan Leffler
Date: Thursday, 11 November 2004, at 12:19 p.m.

In Response To: Migrating data from IDS 7.31 to 9.4 (Adam Hanel )

"Adam Hanel " <adam.hanel@gmail.com> wrote on 11/11/2004 07:22:10 AM:
> I realize I can't do a onunload and an onload betweed different
> versions of IDS, so what's the best way to migrate data from one
> server to another running different versions of IDS?
>
> I've looked into dbexport, but in all my reading it looks like it has
> a 2gb limit per tape that it will write to.

No. If writing to a disk file, you run into problems at 2 GB. But
writing to a tape does not have that problem. (There probably is an upper
size, but it might
well be 2 billion KB or thereabouts - the tape size specified in KB times
the largest number representable in a 32-bit signed integer.)

> Would it be possible to ---
>
> 1. tar /informix on my target & source host.
> 2. Remove /informix on my target, untar the informix.tar from the
> source on my target machine (effectively creating an instance of IDS
> 7.31)
> 3. then do an onunload and onload betweed the save versions.
> 4. After migrating the database I would remove /informix on the target
> 5. then untar the targets original 9.4 tar to create the IDS 9.4
instance.
>
> Would this work? Both OS's are 32bit AIX.

What's in /informix? Is that your $INFORMIXDIR? Are all the disk files
containing IDS data actually under $INFORMIXDIR? Where do your symlinks
point to? (Whaddya mean, you haven't got any symlinks?)

Step 1 is relatively anodyne - if the information is complete. Of course,
for consistency, the servers must be down while you do the backup.

Step 2 is 'OK' if step 1 does a complete job of the back up. Radical, but
OK. I'd be more inclined to rename /informix on the target to
/informix-9.40 or something suitable like that.

Step 3 is dubious - what are you achieving here? What I'd expect to do as
step 3 is probably bring up the 7.31 server just installed by the back
door, just to do a sanity check on the transferred system. Then install
IDS 9.4 and bring that up against the migrated data - thus migrating the
server to the new version.

Then Step 4 could be onunload on the 9.4 data.

Alternatively, upgrade source server IDS to 9.4, then onunload it.
Or archive it and use the 9.4 redirected restore on the target.

--
Jonathan Leffler (jleffler@us.ibm.com)
STSM, Informix Database Engineering, IBM Data Management
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"

Messages In This Thread

• Migrating data from IDS 7.31 to 9.4
  Adam Hanel -- Thursday, 11 November 2004, at 10:22 a.m.
  • Re: Migrating data from IDS 7.31 to 9.4
    ART KAGEL, BLOOMBERG/ 499 PARK -- Thursday, 11 November 2004, at 11:53 a.m.
    • RE: Migrating data from IDS 7.31 to 9.4
      Michaelis, Daniel -- Thursday, 11 November 2004, at 1:20 p.m.
  • Re: Migrating data from IDS 7.31 to 9.4
    Jonathan Leffler -- Thursday, 11 November 2004, at 12:19 p.m.
  • Re: Migrating data from IDS 7.31 to 9.4
    Konstantin Kaduk -- Friday, 12 November 2004, at 2:47 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.