IDS Forum

RE: which data migration tool to use?

Posted By:
Date:

If databases are not big and each database is not spread on different
dbspaces, then I would suggest simple dbexport (without -ss)/dbimport.

All tables are created with single extent for each table with simple
dbimport option. If -ss option used, it creates using existing table extent
sizes.

thanks
Ravi Yarlagadda

-----Original Message-----
From: Kheng Siang.... [mailto:ks_hor1@yahoo.com]
Sent: Tuesday, March 11, 2003 10:07 PM
To: ids@iiug.org
Subject: RE: which data migration tool to use? [653]


Hi Keith,

My source machine is HP-UX 10.20 (32bit) running IDS
7.30.

My target machine is HP-UX 11.00 (64bit) running IDS
7.31.

IDS 7.31 cannot be installed in hpux 10.2 and vice
versa. So the suggestion of installing 2 version in
one machine will not work.

Obviously I tried to using ontape but it failed, error
message is ".... unable to fork server connection ..."
I guest ontape is not a suggested way to go and it is
dangerous.

So I give up and will try using dbimport and dbexport
with -ss option. I've requested my administratio to
add a big harddisk for the staging area for unloading
.unl files.

Kheng

--- "Simmons, Keith" <keith.simmons@bbslimited.co.uk>
wrote:
> Kheng
>
> What are your source are target machine and O/S?
> The easiest way is to install a copy of 7.30 on you
> target machine, restore
> an archive into it then shut the engine down.
> Install 7.31 over the 7.30 and
> start the engine again. Informix will take care of
> all structure conversions
> and all you will need to do is to update statistics.
> There is a bit of dependency here on having
> compatible tape drives and being
> able to get 7.30 for your new machine. (you could
> try migrating on the old
> machine and then restoring an archive to the new).
>
> Incidentally which sub-version of 7.31 are you using
> as there are some
> show-stopping bugs and 'need to knows' in some
> sub-versions.
>
> Keith
>
> -> -----Original Message-----
> -> From: Kheng Siang.... [mailto:ks_hor1@yahoo.com]
> -> Sent: Monday, March 10, 2003 4:38 PM
> -> To: ids@iiug.org
> -> Subject: which data migration tool to use? [636]
> ->
> ->
> -> Hi,
> ->
> -> I am planning to migrate my IDS from version 7.30
> to
> -> 7.31.
> ->
> -> I have setup the same instance name and dbspace
> name
> -> and chunk softlink in the target machine.
> ->
> -> Can someone advice me on which tool is easiest
> best
> -> used to migrate the data from 7.30 to 7.31
> version
> -> without hassle of loading or unloading individual
> -> tables?
> ->
> -> Can ontape restore the data from older version to
> -> later version?
> ->
> -> Pls recommend me an appropriate tool that offers
> -> hassle free migration. Many thanks.
> ->
> -> Kheng
> ->
> ->
> __________________________________________________
> -> Do you Yahoo!?
> -> Yahoo! Tax Center - forms, calculators, tips,
> more
> -> http://taxes.yahoo.com/
> ->
>
>
****************************************************************************
******
> This message is sent in strict confidence for the
> addressee only. It may
> contain legally privileged information. The contents
> are not to be disclosed
> to anyone other than the addressee. Unauthorised
> recipients are requested
> to preserve this confidentiality and to advise the
> sender immediately of any
> error in transmission.
> This footnote also confirms that this email message
> has been swept for the
> presence of computer viruses, however we cannot
> guarantee that this message
> is free from such problems.
>
****************************************************************************
******


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com

Messages In This Thread

• which data migration tool to use?
  Kheng Siang Hor -- Monday, 10 March 2003, at 11:38 a.m.
  • RE: which data migration tool to use?
    Simmons, Keith -- Tuesday, 11 March 2003, at 3:57 a.m.
  • RE: which data migration tool to use?
    Kheng Siang Hor -- Tuesday, 11 March 2003, at 10:06 p.m.
    • RE: which data migration tool to use?
      Yarlagadda, Ravi -- Wednesday, 12 March 2003, at 8:48 a.m.
    • RE: which data migration tool to use?
      Jerry Williamson -- Wednesday, 12 March 2003, at 12:30 p.m.
    • RE: which data migration tool to use?
      Bishop, Ron -- Wednesday, 12 March 2003, at 8:21 p.m.
      • Re: Build duplicate databases
        ART KAGEL, BLOOMBERG/ 65E 55TH -- Wednesday, 10 December 2003, at 10:14 a.m.
        • RE: Build duplicate databases
          Support Informix -- Monday, 15 December 2003, at 3:07 a.m.
          • RE: Build duplicate databases
            bjleb@harland.net -- Monday, 15 December 2003, at 10:10 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.