which data migration tool to use?

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/

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. ******************************************************************************** **

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

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

Kheng, Hi. We will be doing a similar migration soon as well. Going from HPUX 10.20 with IDS 9.21 to HPUX 11i with IDS 9.21 or 9.3 (new server). Have you considered using onunload/onload to migrate the databases? I have heard that there are some caveats with onunload/onload, but would be curious to know if it would work in your situation (and mine). I was planning to give it a go when the new server arrives. Cheers, Jerry Williamson Grossmont-Cuyamaca Community College District -----Original Message----- From: Kheng Siang.... [mailto:ks_hor1@yahoo.com] Sent: Tuesday, March 11, 2003 7: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

I just did upgraded from 7.30.UC5 to 7.31.UC4 on HP-UX 10.20. I installed 7.31 over top of the 7.30 and everything worked just fine. -----Original Message----- From: Kheng Siang.... [mailto:ks_hor1@yahoo.com] Sent: Tuesday, March 11, 2003 7: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