5.1 conversion from 5.0

Yahoo Archive
1
I have never used the standalone option. I just put the value -1 to the
connectoptions in the VTG file. Starting in single user mode can not be done
by a remote user. Either you install vantage at a workstation or you install
the vantage clientsetup (no need for progress client networking) at the
server - save your standard vtg files first, the directories are different.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: vrijdag 7 december 2001 15:45
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Ronald,
Setting up a computer for Standalone - would that be simply reinstalling
Vantage and clicking the "StandAlone" as opposed to the TCP install? Or is
there a setting in the Command Line that will tell Vantage to start in Stand
Alone mode?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ronald van der Linden
To: vantage@yahoogroups.com
Sent: Friday, December 07, 2001 9:01 AM
Subject: RE: [Vantage] 5.1 conversion from 5.0


My reaction is a bit late because I do read the list every week.
But you get a major increase of performance when you do your conversion in
single user mode. we have found an increase of performance between
400%-500%. I believe that larger databases will benefit even more. I
tested
it on 80mb to 400mb databases.

When you run multi-user then progress has to check every record for locks.
In single user mode a record can not be locked by another user and
therefor
progress will not perform that check.

A lot of memory and a fast harddisk will help as well. I have used a
workstation with 256mb memory and 7200 tmp harddisk. Laptops are ussually
not the rigth tools to perform a database conversion or a release upgrade.
In general they have not much memory and have slower harddrives in
comparison to standard workstations.

Ronald


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, November 30, 2001 10:02 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 5.1 conversion from 5.0


Troy,

Is your laptop configured for a standalone database, or is it accessing
vantage through mapped drive letters?

I'm wondering if a standalone installation performs faster or slower for
schema changes than a networked install, where the server has the vantage
client installed, through mapped drive letters.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 29, 2001 5:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Thanks for your thorough review of your test process, Rick. It helps give
many people benchmarks to go by as they look to upgrade to 5.1. A couple
comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if
your
5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096,
solution was >>to delete 5.1 empty database and ST file, then use
>>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the
vantage.d1, vantage.b1, and vantage.db files - if the block size is
different - like you mentioned below) to get your 5.0 database copied to
5.1
before conversion. This way you don't have to turn off your 5.0 database
each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not
online
yet) did the Schema's for our 700MB database in 20 minutes. Our older
Dual
400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed
difference! I had the client installed on the server, so workstation
speed
was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I would like to hear from anyone who runs or has implemented Vantage on a
Novell network....

Thanks!

Paul

paul.siebers@...


[Non-text portions of this message have been removed]
3
I'm running 4.0, 5,0, 5.1 on NT servers on a Novell 5.0 network.
Bob Walton

Paul Siebers wrote:

> I would like to hear from anyone who runs or has implemented Vantage on a
> Novell network....
>
> Thanks!
>
> Paul
>
> paul.siebers@...
>
> [Non-text portions of this message have been removed]
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


[Non-text portions of this message have been removed]
4
Malmberg Engineering started out on Vantage 2.7 on a Novell server. With
the introduction of Vantage 3.0, Vantage only runs on a NT server.

We still have our Novell 4.11 server as our primary file and print server
(and user authentication), and a separate NT4 server for Vantage. To ease
user management on both OS's, and to synchronize user passwords, we use
Novell's NDS4NT.

If anyone else in the group wishes to discuss this in detail, we can either
do it in here, or feel free to contact me personally.

Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
Malcolm@...


> -----Original Message-----
> From: Paul Siebers [mailto:paul.siebers@...]
> Sent: Thursday, November 29, 2001 5:15 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] Vantage and Novell
>
>
> I would like to hear from anyone who runs or has implemented
> Vantage on a
> Novell network....
>
> Thanks!
>
> Paul
>
> paul.siebers@...
>
>
5
Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john
6
At 12:09 PM 11/29/2001, you wrote:
>New database service is EPIC51, port is 3500. Very nice if you want to
>run both 5.0 and 5.1 on the same server, but a real pain if you need to
>update 100+ reports before the next morning.

Vantage always overrides the server name and service when it calls the
report engine. You can get away with skipping the update. Unless, of
course, fields or tables have changed. Quickest I found is just try
running every report from Custom Report Links or your menu, and only update
the ones that won't run.

>Don't try to reuse the Progress 9.1A client, nothing but "control-frame",
>"splitter" and "widget" errors... We bit the bullet and updated 70
>workstations.

Bummer. Thanks for the info, though!

-Wayne Cox
7
Wayne,

> Vantage always overrides the server name and service when it
> calls the report engine. You can get away with skipping the
> update.

Hmmm, did not know that. About half the reports are called from
my custom menu, the rest are run from RB. Could have saved half
the time <g>.

thanks,
John

ps - to others: crash protection was turned off for schema changes.



> -----Original Message-----
> From: Wayne Cox [mailto:wmc@...]
> Sent: Thursday, November 29, 2001 11:02 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] 5.1 conversion from 5.0
8
Thanks for your thorough review of your test process, Rick. It helps give many people benchmarks to go by as they look to upgrade to 5.1. A couple comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if your 5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096, solution was >>to delete 5.1 empty database and ST file, then use >>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the vantage.d1, vantage.b1, and vantage.db files - if the block size is different - like you mentioned below) to get your 5.0 database copied to 5.1 before conversion. This way you don't have to turn off your 5.0 database each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not online yet) did the Schema's for our 700MB database in 20 minutes. Our older Dual 400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed difference! I had the client installed on the server, so workstation speed was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]
9
Troy,

Is your laptop configured for a standalone database, or is it accessing
vantage through mapped drive letters?

I'm wondering if a standalone installation performs faster or slower for
schema changes than a networked install, where the server has the vantage
client installed, through mapped drive letters.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 29, 2001 5:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Thanks for your thorough review of your test process, Rick. It helps give
many people benchmarks to go by as they look to upgrade to 5.1. A couple
comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if your
5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096,
solution was >>to delete 5.1 empty database and ST file, then use >>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the
vantage.d1, vantage.b1, and vantage.db files - if the block size is
different - like you mentioned below) to get your 5.0 database copied to 5.1
before conversion. This way you don't have to turn off your 5.0 database
each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not online
yet) did the Schema's for our 700MB database in 20 minutes. Our older Dual
400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed
difference! I had the client installed on the server, so workstation speed
was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
10
Thad,
No and No.
I did NOT check "Stand Alone" during the client install on my laptop, because that would limit me to one access to the database (ie. couldn't open Vantage & ODBC at the same time). Thusly, I'm using TCP. But I didn't map any drives - I'm using direct paths to e:\epic51\... for everything.

I don't know if it would be quicker to skip the TCP and do a direct connect to the database.

Troy Funte

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Friday, November 30, 2001 4:02 PM
Subject: RE: [Vantage] 5.1 conversion from 5.0


Troy,

Is your laptop configured for a standalone database, or is it accessing
vantage through mapped drive letters?

I'm wondering if a standalone installation performs faster or slower for
schema changes than a networked install, where the server has the vantage
client installed, through mapped drive letters.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 29, 2001 5:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Thanks for your thorough review of your test process, Rick. It helps give
many people benchmarks to go by as they look to upgrade to 5.1. A couple
comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if your
5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096,
solution was >>to delete 5.1 empty database and ST file, then use >>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the
vantage.d1, vantage.b1, and vantage.db files - if the block size is
different - like you mentioned below) to get your 5.0 database copied to 5.1
before conversion. This way you don't have to turn off your 5.0 database
each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not online
yet) did the Schema's for our 700MB database in 20 minutes. Our older Dual
400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed
difference! I had the client installed on the server, so workstation speed
was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]
11
My reaction is a bit late because I do read the list every week.
But you get a major increase of performance when you do your conversion in
single user mode. we have found an increase of performance between
400%-500%. I believe that larger databases will benefit even more. I tested
it on 80mb to 400mb databases.

When you run multi-user then progress has to check every record for locks.
In single user mode a record can not be locked by another user and therefor
progress will not perform that check.

A lot of memory and a fast harddisk will help as well. I have used a
workstation with 256mb memory and 7200 tmp harddisk. Laptops are ussually
not the rigth tools to perform a database conversion or a release upgrade.
In general they have not much memory and have slower harddrives in
comparison to standard workstations.

Ronald


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, November 30, 2001 10:02 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 5.1 conversion from 5.0


Troy,

Is your laptop configured for a standalone database, or is it accessing
vantage through mapped drive letters?

I'm wondering if a standalone installation performs faster or slower for
schema changes than a networked install, where the server has the vantage
client installed, through mapped drive letters.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 29, 2001 5:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Thanks for your thorough review of your test process, Rick. It helps give
many people benchmarks to go by as they look to upgrade to 5.1. A couple
comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if your
5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096,
solution was >>to delete 5.1 empty database and ST file, then use >>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the
vantage.d1, vantage.b1, and vantage.db files - if the block size is
different - like you mentioned below) to get your 5.0 database copied to 5.1
before conversion. This way you don't have to turn off your 5.0 database
each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not online
yet) did the Schema's for our 700MB database in 20 minutes. Our older Dual
400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed
difference! I had the client installed on the server, so workstation speed
was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
12
Ronald,
Setting up a computer for Standalone - would that be simply reinstalling Vantage and clicking the "StandAlone" as opposed to the TCP install? Or is there a setting in the Command Line that will tell Vantage to start in Stand Alone mode?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ronald van der Linden
To: vantage@yahoogroups.com
Sent: Friday, December 07, 2001 9:01 AM
Subject: RE: [Vantage] 5.1 conversion from 5.0


My reaction is a bit late because I do read the list every week.
But you get a major increase of performance when you do your conversion in
single user mode. we have found an increase of performance between
400%-500%. I believe that larger databases will benefit even more. I tested
it on 80mb to 400mb databases.

When you run multi-user then progress has to check every record for locks.
In single user mode a record can not be locked by another user and therefor
progress will not perform that check.

A lot of memory and a fast harddisk will help as well. I have used a
workstation with 256mb memory and 7200 tmp harddisk. Laptops are ussually
not the rigth tools to perform a database conversion or a release upgrade.
In general they have not much memory and have slower harddrives in
comparison to standard workstations.

Ronald


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, November 30, 2001 10:02 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 5.1 conversion from 5.0


Troy,

Is your laptop configured for a standalone database, or is it accessing
vantage through mapped drive letters?

I'm wondering if a standalone installation performs faster or slower for
schema changes than a networked install, where the server has the vantage
client installed, through mapped drive letters.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 29, 2001 5:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Thanks for your thorough review of your test process, Rick. It helps give
many people benchmarks to go by as they look to upgrade to 5.1. A couple
comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if your
5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096,
solution was >>to delete 5.1 empty database and ST file, then use >>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the
vantage.d1, vantage.b1, and vantage.db files - if the block size is
different - like you mentioned below) to get your 5.0 database copied to 5.1
before conversion. This way you don't have to turn off your 5.0 database
each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not online
yet) did the Schema's for our 700MB database in 20 minutes. Our older Dual
400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed
difference! I had the client installed on the server, so workstation speed
was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]
13
I believe you just have to reinstall the client, and specify standalone
operation.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, December 07, 2001 6:45 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Ronald,
Setting up a computer for Standalone - would that be simply reinstalling
Vantage and clicking the "StandAlone" as opposed to the TCP install? Or is
there a setting in the Command Line that will tell Vantage to start in Stand
Alone mode?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ronald van der Linden
To: vantage@yahoogroups.com
Sent: Friday, December 07, 2001 9:01 AM
Subject: RE: [Vantage] 5.1 conversion from 5.0


My reaction is a bit late because I do read the list every week.
But you get a major increase of performance when you do your conversion in
single user mode. we have found an increase of performance between
400%-500%. I believe that larger databases will benefit even more. I
tested
it on 80mb to 400mb databases.

When you run multi-user then progress has to check every record for locks.
In single user mode a record can not be locked by another user and
therefor
progress will not perform that check.

A lot of memory and a fast harddisk will help as well. I have used a
workstation with 256mb memory and 7200 tmp harddisk. Laptops are ussually
not the rigth tools to perform a database conversion or a release upgrade.
In general they have not much memory and have slower harddrives in
comparison to standard workstations.

Ronald


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, November 30, 2001 10:02 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 5.1 conversion from 5.0


Troy,

Is your laptop configured for a standalone database, or is it accessing
vantage through mapped drive letters?

I'm wondering if a standalone installation performs faster or slower for
schema changes than a networked install, where the server has the vantage
client installed, through mapped drive letters.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 29, 2001 5:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Thanks for your thorough review of your test process, Rick. It helps give
many people benchmarks to go by as they look to upgrade to 5.1. A couple
comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if
your
5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096,
solution was >>to delete 5.1 empty database and ST file, then use
>>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the
vantage.d1, vantage.b1, and vantage.db files - if the block size is
different - like you mentioned below) to get your 5.0 database copied to
5.1
before conversion. This way you don't have to turn off your 5.0 database
each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not
online
yet) did the Schema's for our 700MB database in 20 minutes. Our older
Dual
400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed
difference! I had the client installed on the server, so workstation
speed
was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
14
Roberts suggestion would be worth a try for speeding up Schema's, I think. I may give it a go later today on my laptop.
Thanks Thad.

Troy
----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Friday, December 07, 2001 2:17 PM
Subject: RE: [Vantage] 5.1 conversion from 5.0


I believe you just have to reinstall the client, and specify standalone
operation.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, December 07, 2001 6:45 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Ronald,
Setting up a computer for Standalone - would that be simply reinstalling
Vantage and clicking the "StandAlone" as opposed to the TCP install? Or is
there a setting in the Command Line that will tell Vantage to start in Stand
Alone mode?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ronald van der Linden
To: vantage@yahoogroups.com
Sent: Friday, December 07, 2001 9:01 AM
Subject: RE: [Vantage] 5.1 conversion from 5.0


My reaction is a bit late because I do read the list every week.
But you get a major increase of performance when you do your conversion in
single user mode. we have found an increase of performance between
400%-500%. I believe that larger databases will benefit even more. I
tested
it on 80mb to 400mb databases.

When you run multi-user then progress has to check every record for locks.
In single user mode a record can not be locked by another user and
therefor
progress will not perform that check.

A lot of memory and a fast harddisk will help as well. I have used a
workstation with 256mb memory and 7200 tmp harddisk. Laptops are ussually
not the rigth tools to perform a database conversion or a release upgrade.
In general they have not much memory and have slower harddrives in
comparison to standard workstations.

Ronald


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, November 30, 2001 10:02 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 5.1 conversion from 5.0


Troy,

Is your laptop configured for a standalone database, or is it accessing
vantage through mapped drive letters?

I'm wondering if a standalone installation performs faster or slower for
schema changes than a networked install, where the server has the vantage
client installed, through mapped drive letters.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 29, 2001 5:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.1 conversion from 5.0


Thanks for your thorough review of your test process, Rick. It helps give
many people benchmarks to go by as they look to upgrade to 5.1. A couple
comments on your notes...

>>Using PROCOPY to copy 5.0 database to 5.1 location >>will not work if
your
5.0 blocksize is 8192. 5.1 >>empty database uses a blocksize of 4096,
solution was >>to delete 5.1 empty database and ST file, then use
>>PROCOPY.

You can also use Prorest to restore a 5.0 backup (after deleting the
vantage.d1, vantage.b1, and vantage.db files - if the block size is
different - like you mentioned below) to get your 5.0 database copied to
5.1
before conversion. This way you don't have to turn off your 5.0 database
each time you want to update your 5.1 test database.

>>Schema changes took 25 minutes on our 1GB database.

I was thrilled to find out that our new Dell Dual 1.3GHZ server (not
online
yet) did the Schema's for our 700MB database in 20 minutes. Our older
Dual
400Mhz server took 3 hrs. My 800mhz laptop takes 7 hrs. Quite a speed
difference! I had the client installed on the server, so workstation
speed
was not a factor.


Troy Funte
Liberty Electronics
----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Thursday, November 29, 2001 12:09 PM
Subject: [Vantage] 5.1 conversion from 5.0


Hello all,

Started 5.1 upgrade at end of 1st shift yesterday. After
necessary backups, began database conversions. Here are
a few observations:

Using PROCOPY to copy 5.0 database to 5.1 location will not
work if your 5.0 blocksize is 8192. 5.1 empty database uses
a blocksize of 4096, solution was to delete 5.1 empty
database and ST file, then use PROCOPY.

Schema changes took 25 minutes on our 1GB database. Server
is dual PIII 1GHZ with 1GB RAM, workstation is Athlon 1.4GHz
with 512MB RAM. Please note that the process will appear to
hang at Phase 2, but if you watch the CPU monitors on the
server and workstation you will see intense activity. During
that time the screen will rarely update.

Database conversions took 20 minutes on same workstation.

We have a few custom forms, TRAVELER.RPT and SUBCPACK.RPT both
needed database verification, PACKSLIP.RPT and POFORM.RPT did
not, have not had time to delve further.

New database service is EPIC51, port is 3500. Very nice if
you want to run both 5.0 and 5.1 on the same server, but a real
pain if you need to update 100+ reports before the next
morning.

SQL92 ODBC seems very stable on Progress 9.1C, I am going to
see if we can get APS working again tomorrow now that ODBC
is back up.

Don't try to reuse the Progress 9.1A client, nothing but
"control-frame", "splitter" and "widget" errors (remember 4.0
update?) that will not go away. We bit the bullet and updated
70 workstations. We stopped at midnight, will be finished by
9:30 this morning. We removed the 9.1A client and then installed
the 9.1C client, no reboots necessary. All our workstations are
NT, 2K or XP Pro.

Data collection is radically different (had preview during the
AMM webinar). Our operators are really confused, but they
will learn.

That's all for now,
john



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

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



[Non-text portions of this message have been removed]