Multi-database Installations

Yahoo Archive
1
ai is after image.

That is a log of completed transactions (in Progress's internal format -
not something you can read). It has two principle uses:apply
transactions after a restore from a back up, and as means of maintaining
a "warm" backup in situations where very rapid restart after a crash is
REALLY important.

Generally, on a well tuned system the overhead is trivial. The benefits
can be significant. After your db has crashed at 4:45 pm, and you have
recovered the backup from last night (You do have a backup from last
night, don't you?) which is easier: apply one or two ai files to add
today's work exactly as it was done during the day - resources required
1 person for 15 minutes; or keep the whole office back for 4 hours to
re-key all the days work, assuming everyone can remember exactly what
they did and in what order - resources required you do the math.

'Nuff said.

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1
2
I'm looking for other users who are running multiple live databases on one
Vantage server. I'm not talking multiple companies on one database, but
rather a separate database for each company/division/whatever.

Just trying to figure out what kind of server specs we might need to run
four live databases. Specifically, the amount of memory and number of
processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I doubt
we really need that much processing power. Still, I'm a hardware junkie.).

Also wondering about hard drive arrangement. Aside from the logistics of
hooking it all up, I assume a series of smaller drives, one drive for each
database would be better than a large drive? Again, going back to my
Progress training, I recall the best way to arrange multiple databases is
dividing the BIs and DBs (and AIs) for each database on separate drives
(i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)

Thanks
Brian Boyes,
Systems Administrator,
Precision Resource Canada Ltd.
<http://www.precisionresource.com>
<mailto:brianb@...>
3
Brian,
We have had up to five databases running at once on our old server. However, only one was our live database. The other four were various test/training databases of various versions, and therefore we had the startup parameters set in such a way as to not disturb the live database much. Having said that, I never found the test databases to appear any slower than the live database at the time.

When we were on 3.0, we had 3.0 live, 3.0 test, 4.0 test, 5.0 test & 5.0 training. This was on an HP server with Two Raid 1 drives (all databases were on one physical drive), Dual 450Mhz Pentium II (or III??) processors and 512MB of RAM.

Now on 5.0 we have 5.0 Live, 5.0 test, 5.0 Lookup, and 5.1 test. Our current server is a Dell with 2 Raid 1 drives (all databases on one physical drive), Dual 1.2Ghz Pentium III's and 1 GB Ram. I believe our network and antivirus software are our biggest source of slowdowns currently. Logging into Vantage is actually slightly slower now that on the old system for these reasons (I believe).

The biggest difference I noticed on our new server was during Schema Changes. It dropped the time from 7 hrs to about 30 minutes. Now I can convert our database multiple times during the day (if I want to) for testing purposes, or to simply refresh the 5.1 test database.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Brian Boyes
To: Vantage List (E-mail)
Sent: Monday, March 18, 2002 3:10 PM
Subject: [Vantage] Multi-database Installations


I'm looking for other users who are running multiple live databases on one
Vantage server. I'm not talking multiple companies on one database, but
rather a separate database for each company/division/whatever.

Just trying to figure out what kind of server specs we might need to run
four live databases. Specifically, the amount of memory and number of
processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I doubt
we really need that much processing power. Still, I'm a hardware junkie.).

Also wondering about hard drive arrangement. Aside from the logistics of
hooking it all up, I assume a series of smaller drives, one drive for each
database would be better than a large drive? Again, going back to my
Progress training, I recall the best way to arrange multiple databases is
dividing the BIs and DBs (and AIs) for each database on separate drives
(i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)

Thanks
Brian Boyes,
Systems Administrator,
Precision Resource Canada Ltd.
<http://www.precisionresource.com>
<mailto:brianb@...>



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]
4
From discussions in other forums, the general consensus seems to be
something like the following:
.bi on one drive
.ai on one drive
.db on one or more drives depending on number of data areas, extents
etc.

The objective here is two fold: eliminate contention, and provide the
best chances for quick and easy recovery.

Contention: reading/writing to the db an bi make up the majority of the
physical i/o that must be performed. It therefore makes sense to avoid
contention between activity in these areas.

Quick and easy recovery: AI has a number of uses, but its most critical
use is a quick recovery after a catastrophic crash, where db corruption
results in a restore from a backup. Since 9 times out of 10 the crash
will have been caused by hardware failure, the chances are good that
anything on the crashed disk(s) is suspect: if the ai is on the same
drive as the corrupted db or bi then it is likely that it is also
corrupt and unusable. Therefore, put it else where. The chances of all
three disks being lost simultaneous are minimal (always allowing the
exception of a magnatude 7 earthquake or similar, in which case there
are likely to other problems that will require attention first).

Brian Boyes wrote:
>
> I'm looking for other users who are running multiple live databases on one
> Vantage server. I'm not talking multiple companies on one database, but
> rather a separate database for each company/division/whatever.
>
> Just trying to figure out what kind of server specs we might need to run
> four live databases. Specifically, the amount of memory and number of
> processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I doubt
> we really need that much processing power. Still, I'm a hardware junkie.).
>
> Also wondering about hard drive arrangement. Aside from the logistics of
> hooking it all up, I assume a series of smaller drives, one drive for each
> database would be better than a large drive? Again, going back to my
> Progress training, I recall the best way to arrange multiple databases is
> dividing the BIs and DBs (and AIs) for each database on separate drives
> (i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1
5
William,
What in the world is an .ai file? I don't think that I've ever come across one. I just did a search on my Vantage Test machine and there is no file with an .ai extension.

Troy Funte
Liberty Electronics

----- Original Message -----
From: william
To: vantage@yahoogroups.com
Sent: Sunday, March 17, 2002 9:55 PM
Subject: Re: [Vantage] Multi-database Installations


>From discussions in other forums, the general consensus seems to be
something like the following:
.bi on one drive
.ai on one drive
.db on one or more drives depending on number of data areas, extents
etc.

The objective here is two fold: eliminate contention, and provide the
best chances for quick and easy recovery.

Contention: reading/writing to the db an bi make up the majority of the
physical i/o that must be performed. It therefore makes sense to avoid
contention between activity in these areas.

Quick and easy recovery: AI has a number of uses, but its most critical
use is a quick recovery after a catastrophic crash, where db corruption
results in a restore from a backup. Since 9 times out of 10 the crash
will have been caused by hardware failure, the chances are good that
anything on the crashed disk(s) is suspect: if the ai is on the same
drive as the corrupted db or bi then it is likely that it is also
corrupt and unusable. Therefore, put it else where. The chances of all
three disks being lost simultaneous are minimal (always allowing the
exception of a magnatude 7 earthquake or similar, in which case there
are likely to other problems that will require attention first).

Brian Boyes wrote:
>
> I'm looking for other users who are running multiple live databases on one
> Vantage server. I'm not talking multiple companies on one database, but
> rather a separate database for each company/division/whatever.
>
> Just trying to figure out what kind of server specs we might need to run
> four live databases. Specifically, the amount of memory and number of
> processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I doubt
> we really need that much processing power. Still, I'm a hardware junkie.).
>
> Also wondering about hard drive arrangement. Aside from the logistics of
> hooking it all up, I assume a series of smaller drives, one drive for each
> database would be better than a large drive? Again, going back to my
> Progress training, I recall the best way to arrange multiple databases is
> dividing the BIs and DBs (and AIs) for each database on separate drives
> (i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1


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]
6
How many Vantage companies are using ".ai" (After Image) feature of
progress?
I did not think Epicor recommended it because of the performance penalty you
pay?

-----Original Message-----
From: william [mailto:william@...]
Sent: Sunday, March 17, 2002 8:55 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Multi-database Installations


From discussions in other forums, the general consensus seems to be
something like the following:
.bi on one drive
.ai on one drive
.db on one or more drives depending on number of data areas, extents
etc.

The objective here is two fold: eliminate contention, and provide the
best chances for quick and easy recovery.

Contention: reading/writing to the db an bi make up the majority of the
physical i/o that must be performed. It therefore makes sense to avoid
contention between activity in these areas.

Quick and easy recovery: AI has a number of uses, but its most critical
use is a quick recovery after a catastrophic crash, where db corruption
results in a restore from a backup. Since 9 times out of 10 the crash
will have been caused by hardware failure, the chances are good that
anything on the crashed disk(s) is suspect: if the ai is on the same
drive as the corrupted db or bi then it is likely that it is also
corrupt and unusable. Therefore, put it else where. The chances of all
three disks being lost simultaneous are minimal (always allowing the
exception of a magnatude 7 earthquake or similar, in which case there
are likely to other problems that will require attention first).

Brian Boyes wrote:
>
> I'm looking for other users who are running multiple live databases on one
> Vantage server. I'm not talking multiple companies on one database, but
> rather a separate database for each company/division/whatever.
>
> Just trying to figure out what kind of server specs we might need to run
> four live databases. Specifically, the amount of memory and number of
> processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I
doubt
> we really need that much processing power. Still, I'm a hardware junkie.).
>
> Also wondering about hard drive arrangement. Aside from the logistics of
> hooking it all up, I assume a series of smaller drives, one drive for each
> database would be better than a large drive? Again, going back to my
> Progress training, I recall the best way to arrange multiple databases is
> dividing the BIs and DBs (and AIs) for each database on separate drives
> (i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1



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/
7
Troy,

AFAIK .ai stands for After Image, basically backing up with a transaction
log.

Paul

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, March 18, 2002 11:13 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Multi-database Installations


William,
What in the world is an .ai file? I don't think that I've ever come
across one. I just did a search on my Vantage Test machine and there is no
file with an .ai extension.

Troy Funte
Liberty Electronics

----- Original Message -----
From: william
To: vantage@yahoogroups.com
Sent: Sunday, March 17, 2002 9:55 PM
Subject: Re: [Vantage] Multi-database Installations


>From discussions in other forums, the general consensus seems to be
something like the following:
.bi on one drive
.ai on one drive
.db on one or more drives depending on number of data areas, extents
etc.

The objective here is two fold: eliminate contention, and provide the
best chances for quick and easy recovery.

Contention: reading/writing to the db an bi make up the majority of the
physical i/o that must be performed. It therefore makes sense to avoid
contention between activity in these areas.

Quick and easy recovery: AI has a number of uses, but its most critical
use is a quick recovery after a catastrophic crash, where db corruption
results in a restore from a backup. Since 9 times out of 10 the crash
will have been caused by hardware failure, the chances are good that
anything on the crashed disk(s) is suspect: if the ai is on the same
drive as the corrupted db or bi then it is likely that it is also
corrupt and unusable. Therefore, put it else where. The chances of all
three disks being lost simultaneous are minimal (always allowing the
exception of a magnatude 7 earthquake or similar, in which case there
are likely to other problems that will require attention first).

Brian Boyes wrote:
>
> I'm looking for other users who are running multiple live databases on
one
> Vantage server. I'm not talking multiple companies on one database, but
> rather a separate database for each company/division/whatever.
>
> Just trying to figure out what kind of server specs we might need to run
> four live databases. Specifically, the amount of memory and number of
> processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I
doubt
> we really need that much processing power. Still, I'm a hardware
junkie.).
>
> Also wondering about hard drive arrangement. Aside from the logistics of
> hooking it all up, I assume a series of smaller drives, one drive for
each
> database would be better than a large drive? Again, going back to my
> Progress training, I recall the best way to arrange multiple databases
is
> dividing the BIs and DBs (and AIs) for each database on separate drives
> (i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1


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/
8
Epicor has suggested it in the past, based on your configuration.

Brian

> -----Original Message-----
> How many Vantage companies are using ".ai" (After Image) feature of
> progress?
> I did not think Epicor recommended it because of the
> performance penalty you pay?
9
Is .ai something you tell Progress to set up?

Troy Funte
Liberty Electronics
----- Original Message -----
From: Paul Siebers
To: 'vantage@yahoogroups.com'
Sent: Tuesday, March 19, 2002 5:41 AM
Subject: RE: [Vantage] Multi-database Installations


Troy,

AFAIK .ai stands for After Image, basically backing up with a transaction
log.

Paul

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, March 18, 2002 11:13 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Multi-database Installations


William,
What in the world is an .ai file? I don't think that I've ever come
across one. I just did a search on my Vantage Test machine and there is no
file with an .ai extension.

Troy Funte
Liberty Electronics

----- Original Message -----
From: william
To: vantage@yahoogroups.com
Sent: Sunday, March 17, 2002 9:55 PM
Subject: Re: [Vantage] Multi-database Installations


>From discussions in other forums, the general consensus seems to be
something like the following:
.bi on one drive
.ai on one drive
.db on one or more drives depending on number of data areas, extents
etc.

The objective here is two fold: eliminate contention, and provide the
best chances for quick and easy recovery.

Contention: reading/writing to the db an bi make up the majority of the
physical i/o that must be performed. It therefore makes sense to avoid
contention between activity in these areas.

Quick and easy recovery: AI has a number of uses, but its most critical
use is a quick recovery after a catastrophic crash, where db corruption
results in a restore from a backup. Since 9 times out of 10 the crash
will have been caused by hardware failure, the chances are good that
anything on the crashed disk(s) is suspect: if the ai is on the same
drive as the corrupted db or bi then it is likely that it is also
corrupt and unusable. Therefore, put it else where. The chances of all
three disks being lost simultaneous are minimal (always allowing the
exception of a magnatude 7 earthquake or similar, in which case there
are likely to other problems that will require attention first).

Brian Boyes wrote:
>
> I'm looking for other users who are running multiple live databases on
one
> Vantage server. I'm not talking multiple companies on one database, but
> rather a separate database for each company/division/whatever.
>
> Just trying to figure out what kind of server specs we might need to run
> four live databases. Specifically, the amount of memory and number of
> processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I
doubt
> we really need that much processing power. Still, I'm a hardware
junkie.).
>
> Also wondering about hard drive arrangement. Aside from the logistics of
> hooking it all up, I assume a series of smaller drives, one drive for
each
> database would be better than a large drive? Again, going back to my
> Progress training, I recall the best way to arrange multiple databases
is
> dividing the BIs and DBs (and AIs) for each database on separate drives
> (i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1


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]
10
Troy,
This link might help a bit:


http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentry
.p?kbid=16541&keywords=ai&wintype=kbwindow

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, March 19, 2002 1:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Multi-database Installations


Is .ai something you tell Progress to set up?

Troy Funte
Liberty Electronics
----- Original Message -----
From: Paul Siebers
To: 'vantage@yahoogroups.com'
Sent: Tuesday, March 19, 2002 5:41 AM
Subject: RE: [Vantage] Multi-database Installations


Troy,

AFAIK .ai stands for After Image, basically backing up with a transaction
log.

Paul

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, March 18, 2002 11:13 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Multi-database Installations


William,
What in the world is an .ai file? I don't think that I've ever come
across one. I just did a search on my Vantage Test machine and there is no
file with an .ai extension.

Troy Funte
Liberty Electronics

----- Original Message -----
From: william
To: vantage@yahoogroups.com
Sent: Sunday, March 17, 2002 9:55 PM
Subject: Re: [Vantage] Multi-database Installations


>From discussions in other forums, the general consensus seems to be
something like the following:
.bi on one drive
.ai on one drive
.db on one or more drives depending on number of data areas, extents
etc.

The objective here is two fold: eliminate contention, and provide the
best chances for quick and easy recovery.

Contention: reading/writing to the db an bi make up the majority of the
physical i/o that must be performed. It therefore makes sense to avoid
contention between activity in these areas.

Quick and easy recovery: AI has a number of uses, but its most critical
use is a quick recovery after a catastrophic crash, where db corruption
results in a restore from a backup. Since 9 times out of 10 the crash
will have been caused by hardware failure, the chances are good that
anything on the crashed disk(s) is suspect: if the ai is on the same
drive as the corrupted db or bi then it is likely that it is also
corrupt and unusable. Therefore, put it else where. The chances of all
three disks being lost simultaneous are minimal (always allowing the
exception of a magnatude 7 earthquake or similar, in which case there
are likely to other problems that will require attention first).

Brian Boyes wrote:
>
> I'm looking for other users who are running multiple live databases on
one
> Vantage server. I'm not talking multiple companies on one database,
but
> rather a separate database for each company/division/whatever.
>
> Just trying to figure out what kind of server specs we might need to
run
> four live databases. Specifically, the amount of memory and number of
> processors. (I'm eyeing that quad-processor Dell Poweredge 8450, but I
doubt
> we really need that much processing power. Still, I'm a hardware
junkie.).
>
> Also wondering about hard drive arrangement. Aside from the logistics
of
> hooking it all up, I assume a series of smaller drives, one drive for
each
> database would be better than a large drive? Again, going back to my
> Progress training, I recall the best way to arrange multiple databases
is
> dividing the BIs and DBs (and AIs) for each database on separate
drives
> (i.e. putting DB1 and BI2 on drive 1 and DB2 and BI1 on drive 2?)
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1


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]



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/