Ver 4, 5 Fast Schema Change

Thanks for all of the replies. I tried the "Fast" method on
our test server today and got a 1.25 GB Database done
in about 2 hours.

Wayne, The fast method is from Vantage support, and
is basically manually loading the DF files to do the
schema change. Support has documents and VTG files
that are setup to do this. The startup procedure in the
VTG file is gui\_admin instead of the applydf.w that is
in the Schema Change.vtg file.

1 Hour until Conversions start!!!!


----- Original Message -----
From: "Wayne Cox" <wmc@...>
To: <vantage@yahoogroups.com>
Sent: Friday, June 29, 2001 4:57 PM
Subject: Re: [Vantage] Ver 4, 5 Fast Schema Change


> At 09:33 AM 6/29/2001 , you wrote:
> >Has anyone done the conversions to 4 or 5 using
> >the fast schema change procedures from Support?
>
> While you're at it, make sure the -B parameter in Startup.pf is big
> enough. I suspect a lot of Vantage users have this set way too low to
> utilize all their server's memory. Might explain the 1/2 hour vs 20 hour
> conversions.
>
> 25000 is about 100MB of ram for DB caching. If you have 512MB or more
(who
> doesn't?) 50000 or 100000 or more isn't unreasonable.
>
> >Should I truncate the DB files before conversion?
>
> The BI you mean? Nah, I wouldn't. Don't think there's any overhead
(other
> that disk space) to a bigg'un. If it does need to grow, it's faster to
> have it pre-allocated. Is the "fast" method where you turn off the DB
> recovery? That might not even utilize the BI file?
>
> -Wayne Cox
>
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
Has anyone done the conversions to 4 or 5 using
the fast schema change procedures from Support?
I have a couple of questions:

Ver 3 to 4
Which database does this get applied to? The 3.0
copy or the 4.0 copy after the 3.0 copy have been
put into the 4.0 Directory? Is this the same thing for
4 to 5?

Do I just stop the 3 to 4 process to apply these
changes?

Should I truncate the DB files before conversion?

Thanks for any help or suggestions, Hopefully we
are live on 5 on Monday Morning!!


Tim Care
Electro Chemical Finishing
Vantage 5 Conversion is TODAY
I got some intructions on the 4 to 5 Fast Schema change, but got nervous when I saw all the steps. I stuck with the 'slow' way.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Tim Care
To: vantage@yahoogroups.com
Sent: Friday, June 29, 2001 9:33 AM
Subject: [Vantage] Ver 4, 5 Fast Schema Change


Has anyone done the conversions to 4 or 5 using
the fast schema change procedures from Support?
I have a couple of questions:

Ver 3 to 4
Which database does this get applied to? The 3.0
copy or the 4.0 copy after the 3.0 copy have been
put into the 4.0 Directory? Is this the same thing for
4 to 5?

Do I just stop the 3 to 4 process to apply these
changes?

Should I truncate the DB files before conversion?

Thanks for any help or suggestions, Hopefully we
are live on 5 on Monday Morning!!


Tim Care
Electro Chemical Finishing
Vantage 5 Conversion is TODAY


To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I used the fast schema change when I installed it on my V5 test
server, and my 1.4G db took less than 2 hours. I also ran
the client on the server.
At 09:33 AM 6/29/2001 , you wrote:
>Has anyone done the conversions to 4 or 5 using
>the fast schema change procedures from Support?

While you're at it, make sure the -B parameter in Startup.pf is big
enough. I suspect a lot of Vantage users have this set way too low to
utilize all their server's memory. Might explain the 1/2 hour vs 20 hour
conversions.

25000 is about 100MB of ram for DB caching. If you have 512MB or more (who
doesn't?) 50000 or 100000 or more isn't unreasonable.

>Should I truncate the DB files before conversion?

The BI you mean? Nah, I wouldn't. Don't think there's any overhead (other
that disk space) to a bigg'un. If it does need to grow, it's faster to
have it pre-allocated. Is the "fast" method where you turn off the DB
recovery? That might not even utilize the BI file?

-Wayne Cox