Upgrade question
User upgrading Informix 9.3 to 11.10 on new hardware wanted to restore backups to different dataspaces. Expert clarified that archives cannot be restored across versions. Recommended either in-place upgrade followed by moving tables to new dbspaces, or exporting data from 9.3 and importing into fresh 11.10 instance. Suggested using myexport/myimport utility with HPLoader and parallel processing for faster migration.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We are attempting to do an upgrade of hardware and software at the same time (Informix 9.3 to 11.10). We wish to change the dataspaces (and chunks) to take advantage of the new server abilities. What is the preferred method people use to backup and restore the DATABASE to the new server? We have netbackup but it seems to require the restore to be to the same dataspace name. I created the new schema's in the new spaces but I do not want to do manual unloads and loads. Even using ipload it would take some time. We wish to have minimal time (and mistakes) during the final cut over. Suggestions are welcome and thanked in advance! Tim Ertl 413-442-9000 x6211
Please post your hardware specs as well. Sun? Linux? HP? AIx? Microsoft? Are u doing anything fancy with your backups to netbackup or just standard level-0? And disk level things like EMC BCVs/mirrors that could be useful? ----- Original Message ----- From: ids-bounces@iiug.org <ids-bounces@iiug.org> To: ids@iiug.org <ids@iiug.org> Sent: Mon Jul 14 17:52:03 2008 Subject: Upgrade question [12690] We are attempting to do an upgrade of hardware and software at the same time (Informix 9.3 to 11.10). We wish to change the dataspaces (and chunks) to take advantage of the new server abilities. What is the preferred method people use to backup and restore the DATABASE to the new server? We have netbackup but it seems to require the restore to be to the same dataspace name. I created the new schema's in the new spaces but I do not want to do manual unloads and loads. Even using ipload it would take some time. We wish to have minimal time (and mistakes) during the final cut over. Suggestions are welcome and thanked in advance! Tim Ertl 413-442-9000 x6211 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================
Pardon me, must be that new blackberry-verizon language I am using :-) What I meant to say (and hopefully it comes through better now): Please post your hardware specs as well. Sun? Linux? HP? AIx? Microsoft? Are u doing anything fancy with your backups to netbackup or just standard level-0? And disk level things like EMC BCVs/mirrors that could be useful? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Tim Ertl Sent: Monday, July 14, 2008 5:52 PM To: ids@iiug.org Subject: Upgrade question [12690] We are attempting to do an upgrade of hardware and software at the same time (Informix 9.3 to 11.10). We wish to change the dataspaces (and chunks) to take advantage of the new server abilities. What is the preferred method people use to backup and restore the DATABASE to the new server? We have netbackup but it seems to require the restore to be to the same dataspace name. I created the new schema's in the new spaces but I do not want to do manual unloads and loads. Even using ipload it would take some time. We wish to have minimal time (and mistakes) during the final cut over. Suggestions are welcome and thanked in advance! Tim Ertl 413-442-9000 x6211 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================
You CANNOT restore an archive from one version into another version of IDS.
It won't work.
You either have to perform an in-place upgrade from 9.3 to 11.10 or export
the data from 9.3, create a new 11.10 instance with the new dbspaces and
chunks and the import the data.
Obviously, the in-place upgrade will leave you with the same dbspaces and
chunks you had originally. The solution for that is to enable large chunks
in the instance after the upgrade (onmode -BC 2) then create new dbspaces
using larger chunks and possibly larger page sizes, and move tables,
indexes, and fragments thereof to the new dbspaces. Eventually you may be
able to drop many of the original dbspaces (though likely not any dbspace
containing a database's system catalog tables.
Art
On Mon, Jul 14, 2008 at 6:52 PM, Tim Ertl <tim@lmrgroup.com> wrote:
> We are attempting to do an upgrade of hardware and software at the same
> time
> (Informix 9.3 to 11.10). We wish to change the dataspaces (and chunks) to
> take advantage of the new server abilities.
> What is the preferred method people use to backup and restore the DATABASE
> to the new server?
>
> We have netbackup but it seems to require the restore to be to the same
> dataspace name.
>
> I created the new schema's in the new spaces but I do not want to do manual
> unloads and loads. Even using ipload it would take some time. We wish to
> have minimal time (and mistakes) during the final cut over.
>
> Suggestions are welcome and thanked in advance!
>
> Tim Ertl
> 413-442-9000 x6211
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
11.10 and more disk drives to spread out the I/O!.
The migration guide suggest dbexport/dbimport but I wonder if there is a
better way.
Thanks for your time...
,,,Tim
Tim Ertl
413-442-9000 x6211
Get my dbexport/dbimport replacement utility, myexport. It can use the
HPLoader to export and import your data and it can do all tables in parallel
for maximum throughput. To use myexport you will also need my utils2_ak
package for my dbschema replacement utility myschema, Jonathan Leffler's
sqlcmd utility (which myexport/myimport uses by default for moving data),
and Ravi Krishna's myonpload utility that lets myexport/myimport run the
HPLoader from the commandline.
For fastest loading use the -p (parallel), -C (HPLoader), and -m (create
indexes and constraints after the load) options for myexport and -p, -H D
(HPLoader in deluxe mode), and -m for myimport. Myimport can also create
the database and load the tables into different dbspaces than they were
exported from using the -T <mapfile> option. See the README.1st file and
the sample mapping files in the package.
Art
On Tue, Jul 15, 2008 at 9:05 AM, Tim Ertl <tim@lmrgroup.com> wrote:
> Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
> informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
> 11.10 and more disk drives to spread out the I/O!.
>
> The migration guide suggest dbexport/dbimport but I wonder if there is a
> better way.
>
> Thanks for your time...
>
> ,,,Tim
>
> Tim Ertl
> 413-442-9000 x6211
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
Art, wow! the myexport stuff lead me into its requirements that are a whole
bunch of neat Informix programs. Great stuff! We should have had a session
at the IIUG about non-IBM user utilities!
In anycase the utils2_ak had an issue I do not see a fix for in the
Makefile.
make: Fatal error in reader: Makefile, line 72: Unexpected end of line seen
If you have any quick thoughts on this problem I welcome the help.
,,,Thanks,,,
Tim Ertl
413-442-9000 x6211
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
Kagel
Sent: Tuesday, July 15, 2008 10:03 AM
To: ids@iiug.org
Subject: Re: Upgrade question [12703]
Get my dbexport/dbimport replacement utility, myexport. It can use the
HPLoader to export and import your data and it can do all tables in parallel
for maximum throughput. To use myexport you will also need my utils2_ak
package for my dbschema replacement utility myschema, Jonathan Leffler's
sqlcmd utility (which myexport/myimport uses by default for moving data),
and Ravi Krishna's myonpload utility that lets myexport/myimport run the
HPLoader from the commandline.
For fastest loading use the -p (parallel), -C (HPLoader), and -m (create
indexes and constraints after the load) options for myexport and -p, -H D
(HPLoader in deluxe mode), and -m for myimport. Myimport can also create
the database and load the tables into different dbspaces than they were
exported from using the -T <mapfile> option. See the README.1st file and
the sample mapping files in the package.
Art
On Tue, Jul 15, 2008 at 9:05 AM, Tim Ertl <tim@lmrgroup.com> wrote:
> Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
> informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
> 11.10 and more disk drives to spread out the I/O!.
>
> The migration guide suggest dbexport/dbimport but I wonder if there is a
> better way.
>
> Thanks for your time...
>
> ,,,Tim
>
> Tim Ertl
> 413-442-9000 x6211
>
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Tim,
as you have seen, Art has given great suggestions.
One thing you didn't mention is if your informix version is going 64
bit. You said informix 9.3 to 11.10, but did not specify 9.3.Uxx
(32bit) versus 11.10.Fxx (64 bit)... The letters indicating 32 versus 64
if memory serves me correctly. You are going from a 32 bit Sun server
to 64, so why not do it with your informix too?
I think you may have some wiggle room short of the dbexport/dbimport,...
The devil is in the details and depends if you have test servers you can
experiment with before go-live.....
I remember doing this several years back on Sun, I don't remember all
the details, but we did not dbexport/dbimport.
Norma Jean Sebastian
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Tim Ertl
Sent: Tuesday, July 15, 2008 8:06 AM
To: ids@iiug.org
Subject: Re: Upgrade question [12700]
Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
11.10 and more disk drives to spread out the I/O!.
The migration guide suggest dbexport/dbimport but I wonder if there is a
better way.
Thanks for your time...
,,,Tim
Tim Ertl
413-442-9000 x6211
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================
Sounds like you don't have, or at least are not using, GNU Make. The
makefile has to be edited to work with std UNIX make. On line 71 or so
there's a conditional block like:
ifeq ($(ESQL),c4gl)
cpp -DC4GL_720_COMPILER=1 $? >$@_4gl.ec
INFORMIXC=$(INFORMIXC) $(ESQL) $(ECFLAGS) -o $@ $@_4gl.ec
rm $@_4gl.ec
else
INFORMIXC=$(INFORMIXC) $(ESQL) $(ECFLAGS) -o $@ $?endif
Just remove everything except the line immediately above the endif (or use
GNU Make). You'll have to edit the myschema makefile also and make the same
change there. That's the file myschema.mk.norcs in the myschema.d
subdirectory.
Oh, unless the update went in today (I uploaded it a week ago but it wasn't
there as of yesterday), the copy you have may have a compile time bug in the
file myschema.d/print_procedures.ec. Updated version is attached, just
replace the one you have with this new one.
Art
On Tue, Jul 15, 2008 at 4:04 PM, Tim Ertl <tim@lmrgroup.com> wrote:
> Art, wow! the myexport stuff lead me into its requirements that are a whole
> bunch of neat Informix programs. Great stuff! We should have had a session
> at the IIUG about non-IBM user utilities!
>
> In anycase the utils2_ak had an issue I do not see a fix for in the
> Makefile.
> make: Fatal error in reader: Makefile, line 72: Unexpected end of line seen
>
> If you have any quick thoughts on this problem I welcome the help.
>
> ,,,Thanks,,,
>
> Tim Ertl
> 413-442-9000 x6211
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Tuesday, July 15, 2008 10:03 AM
> To: ids@iiug.org
> Subject: Re: Upgrade question [12703]
>
> Get my dbexport/dbimport replacement utility, myexport. It can use the
> HPLoader to export and import your data and it can do all tables in
> parallel
>
> for maximum throughput. To use myexport you will also need my utils2_ak
> package for my dbschema replacement utility myschema, Jonathan Leffler's
> sqlcmd utility (which myexport/myimport uses by default for moving data),
> and Ravi Krishna's myonpload utility that lets myexport/myimport run the
> HPLoader from the commandline.
>
> For fastest loading use the -p (parallel), -C (HPLoader), and -m (create
> indexes and constraints after the load) options for myexport and -p, -H D
> (HPLoader in deluxe mode), and -m for myimport. Myimport can also create
> the database and load the tables into different dbspaces than they were
> exported from using the -T <mapfile> option. See the README.1st file and
> the sample mapping files in the package.
>
> Art
>
> On Tue, Jul 15, 2008 at 9:05 AM, Tim Ertl <tim@lmrgroup.com> wrote:
>
> > Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
> > informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
> > 11.10 and more disk drives to spread out the I/O!.
> >
> > The migration guide suggest dbexport/dbimport but I wonder if there is a
> > better way.
> >
> > Thanks for your time...
> >
> > ,,,Tim
> >
> > Tim Ertl
> > 413-442-9000 x6211
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
>
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those
>
> opinions reflect those of other individuals affiliated with any entity with
> which I am affiliated nor those of the entities themselves.
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
Norma Jean Sebastian,
Yes on the upgrade to 64bits we are going to 64bit Informix. We were
9.30.UC1 32 bit and I am going to 11.10.FC2 which is 64bits.
The 64bit server is a brand new server and I am doing all sorts of testing
on it. The export needs to come from the production 32bit system sooner or
later but I am trying this on the new server first. At the moment the
utils2_ak Makefile seems to have some sort of odd error/or/dependency in it.
We do not do upgrades in place so I can usually get a server to test on. Sun
had a 45% off try and buy program that was too good to be true.
Tim Ertl
413-442-9000 x6211
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Sebastian, Norma J.
Sent: Tuesday, July 15, 2008 4:05 PM
To: ids@iiug.org
Subject: RE: Upgrade question [12710]
Tim,
as you have seen, Art has given great suggestions.
One thing you didn't mention is if your informix version is going 64
bit. You said informix 9.3 to 11.10, but did not specify 9.3.Uxx
(32bit) versus 11.10.Fxx (64 bit)... The letters indicating 32 versus 64
if memory serves me correctly. You are going from a 32 bit Sun server
to 64, so why not do it with your informix too?
I think you may have some wiggle room short of the dbexport/dbimport,...
The devil is in the details and depends if you have test servers you can
experiment with before go-live.....
I remember doing this several years back on Sun, I don't remember all
the details, but we did not dbexport/dbimport.
Norma Jean Sebastian
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Tim Ertl
Sent: Tuesday, July 15, 2008 8:06 AM
To: ids@iiug.org
Subject: Re: Upgrade question [12700]
Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
11.10 and more disk drives to spread out the I/O!.
The migration guide suggest dbexport/dbimport but I wonder if there is a
better way.
Thanks for your time...
,,,Tim
Tim Ertl
413-442-9000 x6211
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Tim,
Here's a thought. Is your 32bit informix certified to run on that new
server? (they are both sparc) I don't have a link for the support
matrix. You could install Informix 9.30.UC1 on the 64bit server (32bit
software should be fine on 64bit o/s). If that is possible, you now
have informix 9.30.UC1 on both sparc machines (Sun Enterprise 250 & Sun
T5120). You could set up the chunks on new server the same or different
than old server, just have the links in place to support the 9.30 setup
and enough space to take the restore. Run the IDS 9.30 restore to the
new server. Now you are in an inplace upgrade situation. Again, I
don't have a link to any matrix in front of me, can you go directly from
IDS 9.30 to 11.10? My memory is fuzzy, point your environment to the
new binaries and start her up?.... Even if I am wrong, you are playing
on a test server, it might be worth a try....
I could be way off base, so it's good to pursue Art's method as well
(he's likely right on target).....
Enjoy the experiment :-)
NJ
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Tim Ertl
Sent: Tuesday, July 15, 2008 3:18 PM
To: ids@iiug.org
Subject: RE: Upgrade question [12712]
Norma Jean Sebastian,
Yes on the upgrade to 64bits we are going to 64bit Informix. We were
9.30.UC1 32 bit and I am going to 11.10.FC2 which is 64bits.
The 64bit server is a brand new server and I am doing all sorts of
testing
on it. The export needs to come from the production 32bit system sooner
or
later but I am trying this on the new server first. At the moment the
utils2_ak Makefile seems to have some sort of odd error/or/dependency in
it.
We do not do upgrades in place so I can usually get a server to test on.
Sun
had a 45% off try and buy program that was too good to be true.
Tim Ertl
413-442-9000 x6211
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Sebastian, Norma J.
Sent: Tuesday, July 15, 2008 4:05 PM
To: ids@iiug.org
Subject: RE: Upgrade question [12710]
Tim,
as you have seen, Art has given great suggestions.
One thing you didn't mention is if your informix version is going 64
bit. You said informix 9.3 to 11.10, but did not specify 9.3.Uxx
(32bit) versus 11.10.Fxx (64 bit)... The letters indicating 32 versus 64
if memory serves me correctly. You are going from a 32 bit Sun server
to 64, so why not do it with your informix too?
I think you may have some wiggle room short of the dbexport/dbimport,...
The devil is in the details and depends if you have test servers you can
experiment with before go-live.....
I remember doing this several years back on Sun, I don't remember all
the details, but we did not dbexport/dbimport.
Norma Jean Sebastian
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Tim Ertl
Sent: Tuesday, July 15, 2008 8:06 AM
To: ids@iiug.org
Subject: Re: Upgrade question [12700]
Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
11.10 and more disk drives to spread out the I/O!.
The migration guide suggest dbexport/dbimport but I wonder if there is a
better way.
Thanks for your time...
,,,Tim
Tim Ertl
413-442-9000 x6211
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================