If possible do an upgrade/test what you need to do on a lab. machine.


J.

-----Original Message-----
From: "William Weaver" <wweaver (AT) amicus (DOT) com>
To: <informix-list (AT) iiug (DOT) org>
Date: Tue, 16 Aug 2005 12:48:56 -0500
Subject: Upgrade recommendations

We have a client coming on board with us that currently is running the
following versions:



SE 7.24_UC8

4GL 7.20_UE1 (RDS)



As part of bringing them on board, we'll need to take them to the latest
Informix versions. This includes migrating them from SE to IDS 10 as well
as upgrading their 4GL. Being such a large version jump in both products,
I'm leery that there may be several "gotchas" in the process. Can any of
you provide some things we need to look out for? Any specific advice?
Also, because of our environment, we may have to transition them from RDS to
compiled 4GL in addition to the version upgrade. What should we look out
for there? I've never really had many issues with Informix upgrades in the
past, but I've never been through this large of a leap before so I'm
understandably paranoid. Unfortunately, we probably won't have the luxury
of doing this incrementally but rather will have to do it in one huge swath.



Bill Weaver

Director of Engineering

Amicus, Inc.

512-531-3463 (office)

512-531-3401 (fax)



"A lie told often enough becomes the truth." - Lenin



"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong



"Life can only be understood backwards; but it must be lived forwards." -
Soren Kierkegaard



"To err is human--and to blame it on a computer is even more so." - Robert
Orben



"To be upset over what you don't have is to waste what you do have." - Ken
S. Keyes







Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) gmail (DOT) com

sending to informix-list

We will definitely have that opportunity and there will also be an extended
and extensive testing period before cutting over, but any suggestions to
make that whole process much smoother?

Bill Weaver
Director of Engineering
Amicus, Inc.
512-531-3463 (office)
512-531-3401 (fax)

"A lie told often enough becomes the truth." - Lenin

"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong

"Life can only be understood backwards; but it must be lived forwards." -
Soren Kierkegaard

"To err is human--and to blame it on a computer is even more so." - Robert
Orben

"To be upset over what you don't have is to waste what you do have." - Ken
S. Keyes



-----Original Message-----
From: Jean Sagi [mailto:jeansagi (AT) myrealbox (DOT) com]
Sent: Tuesday, August 16, 2005 2:30 PM
To: wweaver (AT) amicus (DOT) com
Cc: informix-list (AT) iiug (DOT) org
Subject: Re: Upgrade recommendations

If possible do an upgrade/test what you need to do on a lab. machine.


J.

-----Original Message-----
From: "William Weaver" <wweaver (AT) amicus (DOT) com>
To: <informix-list (AT) iiug (DOT) org>
Date: Tue, 16 Aug 2005 12:48:56 -0500
Subject: Upgrade recommendations

We have a client coming on board with us that currently is running the
following versions:



SE 7.24_UC8

4GL 7.20_UE1 (RDS)



As part of bringing them on board, we'll need to take them to the latest
Informix versions. This includes migrating them from SE to IDS 10 as well
as upgrading their 4GL. Being such a large version jump in both products,
I'm leery that there may be several "gotchas" in the process. Can any of
you provide some things we need to look out for? Any specific advice?
Also, because of our environment, we may have to transition them from RDS to
compiled 4GL in addition to the version upgrade. What should we look out
for there? I've never really had many issues with Informix upgrades in the
past, but I've never been through this large of a leap before so I'm
understandably paranoid. Unfortunately, we probably won't have the luxury
of doing this incrementally but rather will have to do it in one huge swath.



Bill Weaver

Director of Engineering

Amicus, Inc.

512-531-3463 (office)

512-531-3401 (fax)



"A lie told often enough becomes the truth." - Lenin



"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong



"Life can only be understood backwards; but it must be lived forwards." -
Soren Kierkegaard



"To err is human--and to blame it on a computer is even more so." - Robert
Orben



"To be upset over what you don't have is to waste what you do have." - Ken
S. Keyes







Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) gmail (DOT) com


sending to informix-list

Well there are a lot of onconfig settings to move/tune if you are going from SE 7.x to IDS 10.x.

Would be used the same machine?

Or there are newer hardware (Memory/Disks-San/MultiCPUs/OS,etc) ?

You have to test your 4gl code, it won't be hurt by the upgrade but pay special atention on the way that null/empty strings are handled.


J.

-----Original Message-----
From: "William Weaver" <wweaver (AT) amicus (DOT) com>
To: "'Jean Sagi'" <jeansagi (AT) myrealbox (DOT) com>
Date: Tue, 16 Aug 2005 14:52:04 -0500
Subject: RE: Upgrade recommendations

We will definitely have that opportunity and there will also be an extended
and extensive testing period before cutting over, but any suggestions to
make that whole process much smoother?

Bill Weaver
Director of Engineering
Amicus, Inc.
512-531-3463 (office)
512-531-3401 (fax)

"A lie told often enough becomes the truth." - Lenin

"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong

"Life can only be understood backwards; but it must be lived forwards." -
Soren Kierkegaard

"To err is human--and to blame it on a computer is even more so." - Robert
Orben

"To be upset over what you don't have is to waste what you do have." - Ken
S. Keyes



-----Original Message-----
From: Jean Sagi [mailto:jeansagi (AT) myrealbox (DOT) com]
Sent: Tuesday, August 16, 2005 2:30 PM
To: wweaver (AT) amicus (DOT) com
Cc: informix-list (AT) iiug (DOT) org
Subject: Re: Upgrade recommendations

If possible do an upgrade/test what you need to do on a lab. machine.


J.

-----Original Message-----
From: "William Weaver" <wweaver (AT) amicus (DOT) com>
To: <informix-list (AT) iiug (DOT) org>
Date: Tue, 16 Aug 2005 12:48:56 -0500
Subject: Upgrade recommendations

We have a client coming on board with us that currently is running the
following versions:



SE 7.24_UC8

4GL 7.20_UE1 (RDS)



As part of bringing them on board, we'll need to take them to the latest
Informix versions. This includes migrating them from SE to IDS 10 as well
as upgrading their 4GL. Being such a large version jump in both products,
I'm leery that there may be several "gotchas" in the process. Can any of
you provide some things we need to look out for? Any specific advice?
Also, because of our environment, we may have to transition them from RDS to
compiled 4GL in addition to the version upgrade. What should we look out
for there? I've never really had many issues with Informix upgrades in the
past, but I've never been through this large of a leap before so I'm
understandably paranoid. Unfortunately, we probably won't have the luxury
of doing this incrementally but rather will have to do it in one huge swath.



Bill Weaver

Director of Engineering

Amicus, Inc.

512-531-3463 (office)

512-531-3401 (fax)



"A lie told often enough becomes the truth." - Lenin



"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong



"Life can only be understood backwards; but it must be lived forwards." -
Soren Kierkegaard



"To err is human--and to blame it on a computer is even more so." - Robert
Orben



"To be upset over what you don't have is to waste what you do have." - Ken
S. Keyes







Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) gmail (DOT) com



Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) gmail (DOT) com

sending to informix-list

I'm very familiar with the setup and such of Informix, including onconfig.
I don't really anticipate many issues with the SE to IDS 10 migration itself
but am more concerned about the application migration.

We will be setting up a new, clean, pristine machine from scratch and
migrating their data and applications to it so we'll have plenty of
opportunity to test, rebuild, etc. without impacting their current
environment. They are currently on an old AIX box but we'll probably be
moving them to a Linux server (yet another variable).

Bill Weaver
Director of Engineering
Amicus, Inc.
512-531-3463 (office)
512-531-3401 (fax)

-----Original Message-----
From: Jean Sagi [mailto:jeansagi (AT) myrealbox (DOT) com]
Sent: Tuesday, August 16, 2005 3:04 PM
To: wweaver (AT) amicus (DOT) com
Cc: informix-list (AT) iiug (DOT) org
Subject: Re: RE: Upgrade recommendations

Well there are a lot of onconfig settings to move/tune if you are going from
SE 7.x to IDS 10.x.

Would be used the same machine?

Or there are newer hardware (Memory/Disks-San/MultiCPUs/OS,etc) ?

You have to test your 4gl code, it won't be hurt by the upgrade but pay
special atention on the way that null/empty strings are handled.


J.




sending to informix-list

How big is this database / databases (instance) ?


-----Original Message-----
From: owner-informix-list (AT) iiug (DOT) org [mailtowner-informix-list (AT) iiug (DOT) org]
On Behalf Of William Weaver
Sent: 16 August 2005 09:52 PM
To: 'Jean Sagi'
Cc: informix-list (AT) iiug (DOT) org
Subject: RE: Upgrade recommendations

We will definitely have that opportunity and there will also be an
extended
and extensive testing period before cutting over, but any suggestions to
make that whole process much smoother?

Bill Weaver
Director of Engineering
Amicus, Inc.
512-531-3463 (office)
512-531-3401 (fax)

"A lie told often enough becomes the truth." - Lenin

"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong

"Life can only be understood backwards; but it must be lived forwards."
-
Soren Kierkegaard

"To err is human--and to blame it on a computer is even more so." -
Robert
Orben

"To be upset over what you don't have is to waste what you do have." -
Ken
S. Keyes



-----Original Message-----
From: Jean Sagi [mailto:jeansagi (AT) myrealbox (DOT) com]
Sent: Tuesday, August 16, 2005 2:30 PM
To: wweaver (AT) amicus (DOT) com
Cc: informix-list (AT) iiug (DOT) org
Subject: Re: Upgrade recommendations

If possible do an upgrade/test what you need to do on a lab. machine.


J.

-----Original Message-----
From: "William Weaver" <wweaver (AT) amicus (DOT) com>
To: <informix-list (AT) iiug (DOT) org>
Date: Tue, 16 Aug 2005 12:48:56 -0500
Subject: Upgrade recommendations

We have a client coming on board with us that currently is running the
following versions:



SE 7.24_UC8

4GL 7.20_UE1 (RDS)



As part of bringing them on board, we'll need to take them to the latest
Informix versions. This includes migrating them from SE to IDS 10 as
well
as upgrading their 4GL. Being such a large version jump in both
products,
I'm leery that there may be several "gotchas" in the process. Can any
of
you provide some things we need to look out for? Any specific advice?
Also, because of our environment, we may have to transition them from
RDS to
compiled 4GL in addition to the version upgrade. What should we look
out
for there? I've never really had many issues with Informix upgrades in
the
past, but I've never been through this large of a leap before so I'm
understandably paranoid. Unfortunately, we probably won't have the
luxury
of doing this incrementally but rather will have to do it in one huge
swath.



Bill Weaver

Director of Engineering

Amicus, Inc.

512-531-3463 (office)

512-531-3401 (fax)



"A lie told often enough becomes the truth." - Lenin



"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong



"Life can only be understood backwards; but it must be lived forwards."
-
Soren Kierkegaard



"To err is human--and to blame it on a computer is even more so." -
Robert
Orben



"To be upset over what you don't have is to waste what you do have." -
Ken
S. Keyes







Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) gmail (DOT) com


sending to informix-list

sending to informix-list

Almost 18GB in its current form.

By the way, that leads me to another related question. I've never done an
SE to IDS conversion before. In terms of sizing of tables/indexes for
extents in IDS, are the .dat and .idx files of SE comparable in terms of
their space requirements? In other words, can I calculate the extent size
based directly on the size of these files or do I need to add/subtract some
amount of fudge factor?

Bill Weaver
Director of Engineering
Amicus, Inc.
512-531-3463 (office)
512-531-3401 (fax)

-----Original Message-----
From: Dirk Moolman [mailtoirkM (AT) caretech (DOT) co.za]
Sent: Wednesday, August 17, 2005 1:20 AM
To: William Weaver
Cc: informix-list (AT) iiug (DOT) org
Subject: RE: Upgrade recommendations

How big is this database / databases (instance) ?


-----Original Message-----
From: owner-informix-list (AT) iiug (DOT) org [mailtowner-informix-list (AT) iiug (DOT) org]
On Behalf Of William Weaver
Sent: 16 August 2005 09:52 PM
To: 'Jean Sagi'
Cc: informix-list (AT) iiug (DOT) org
Subject: RE: Upgrade recommendations

We will definitely have that opportunity and there will also be an
extended
and extensive testing period before cutting over, but any suggestions to
make that whole process much smoother?

Bill Weaver
Director of Engineering
Amicus, Inc.
512-531-3463 (office)
512-531-3401 (fax)

"A lie told often enough becomes the truth." - Lenin

"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong

"Life can only be understood backwards; but it must be lived forwards."
-
Soren Kierkegaard

"To err is human--and to blame it on a computer is even more so." -
Robert
Orben

"To be upset over what you don't have is to waste what you do have." -
Ken
S. Keyes



-----Original Message-----
From: Jean Sagi [mailto:jeansagi (AT) myrealbox (DOT) com]
Sent: Tuesday, August 16, 2005 2:30 PM
To: wweaver (AT) amicus (DOT) com
Cc: informix-list (AT) iiug (DOT) org
Subject: Re: Upgrade recommendations

If possible do an upgrade/test what you need to do on a lab. machine.


J.

-----Original Message-----
From: "William Weaver" <wweaver (AT) amicus (DOT) com>
To: <informix-list (AT) iiug (DOT) org>
Date: Tue, 16 Aug 2005 12:48:56 -0500
Subject: Upgrade recommendations

We have a client coming on board with us that currently is running the
following versions:



SE 7.24_UC8

4GL 7.20_UE1 (RDS)



As part of bringing them on board, we'll need to take them to the latest
Informix versions. This includes migrating them from SE to IDS 10 as
well
as upgrading their 4GL. Being such a large version jump in both
products,
I'm leery that there may be several "gotchas" in the process. Can any
of
you provide some things we need to look out for? Any specific advice?
Also, because of our environment, we may have to transition them from
RDS to
compiled 4GL in addition to the version upgrade. What should we look
out
for there? I've never really had many issues with Informix upgrades in
the
past, but I've never been through this large of a leap before so I'm
understandably paranoid. Unfortunately, we probably won't have the
luxury
of doing this incrementally but rather will have to do it in one huge
swath.



Bill Weaver

Director of Engineering

Amicus, Inc.

512-531-3463 (office)

512-531-3401 (fax)



"A lie told often enough becomes the truth." - Lenin



"I believe that every human has a finite number of heart-beats. I don't
intend to waste any of mine running around doing exercises." - Neil
Armstrong



"Life can only be understood backwards; but it must be lived forwards."
-
Soren Kierkegaard



"To err is human--and to blame it on a computer is even more so." -
Robert
Orben



"To be upset over what you don't have is to waste what you do have." -
Ken
S. Keyes







Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) gmail (DOT) com


sending to informix-list

sending to informix-list

William Weaver wrote:
It depends on how fancy you want to get, but to a first order
approximation, the sizes will be the same. The data section will be
slightly larger under IDS because of the internal fragmentation of pages
and because of the page overhead (28 + 4 * N) bytes per page for N rows
in a page. The index section will be slightly larger too because SE
applies leading and trailing compression to character keys, and because
IDS uses more bytes to identify where each row is (4 in SE, 5 or 9 in
IDS). It also depends on whether you delete rows from your SE tables,
and if so, how much spare space is allocated, and what fill factor you
use when you create your IDS indexes, and so on.


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/