Re: onunload / onload filesize issues
"Art S. Kagel" wrote:
>
> On Tue, 16 Mar 2004 06:37:34 -0500, Geezer From Freezer wrote:
>
> > I've noticed that onunload will not create a file bigger than the 2Gb file
> > limit.
> > (i.e. its not largefile aware) - anyway to overcome this?
> >
> > Informix 7.31.UC4
> Upgrade to 9.40
>
> Art S. Kagel
I've never done an upgrade before, how easy/difficult/involved is it?
On Thu, 18 Mar 2004 05:39:42 -0500, Geezer From Freezer wrote:
> "Art S. Kagel" wrote:
>>
>> On Tue, 16 Mar 2004 06:37:34 -0500, Geezer From Freezer wrote:
>>
>> > I've noticed that onunload will not create a file bigger than the 2Gb
>> > file limit.
>> > (i.e. its not largefile aware) - anyway to overcome this?
>> >
>> > Informix 7.31.UC4
>> Upgrade to 9.40
>>
>> Art S. Kagel
>
> I've never done an upgrade before, how easy/difficult/involved is it?
Not hard. IDS 9.4 will convert any disk structure changes on the fly when it
is first started up and unless you take advantage of new engine or schema
features you can revert back to 7.3 if there are any show stopper problems
(at least if you use 9.4?C3 or later the reversion is broken in C1 & 2). The
steps are simple also:
1) create a new INFORMIXDIR to hold the new software so you can easily revert
by changing INFORMIXDIR back.
2) re-install any older software you are not upgrading to the same level as
the engine (ex: ISQL 7.3, C/R4GL 7.3, etc).
3) install the new engine release
4) install the latest iConnect or iSDK software
5) copy the sqlhosts file and ONCONFIG files from the original INFORMIXDIR
6) adjust the ONCONFIG file to take advantage of new parameters (ex: 7.3 uses
NUMCPUVPS, NUMAOIVPS, AFF_NPROCS, AFF_SPROC to manage threads, these have
been replaced in 9.4+ with a new parameter - see the 9.4 Administrator's
Guide and Reference manuals and the release notes for details).
7) shutdown the old version instance
8) change INFORMIXDIR for user informix and for all users (or rename the old
INFORMIXDIR and create a link the new one with the old name if every user
does not use a central environment script to set INFORMIXDIR).
9) start the new version instance and wait for conversions to complete.
Art S. Kagel
directory to the