Bi File Blank Title 86276

Yahoo Archive
1
The BI file is where records are written before they are committed to the database. Epicor recommends that this file be truncated before it gets to 2GB. You use the proutil command to truncate the file. (proutil mfgsys -C truncate bi).

A large BI file will slow down a database restart after it has crashed. I have seen a 1GB BI file take 90 minutes to process before the database would restart after a crash.

Troy

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: January-06-10 11:00 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Bi File



Our BI is 1.7 Gigs which is larger than the DB file itself. 300MB doesn't
sound like anything to worry about.

I never really pay attention to it's size because it sits on a set of drives
that after raid is 146 gigs.

There are ways to keeps is size down though.

~Charlie

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Bartosz Niemczewski
Sent: Wednesday, January 06, 2010 1:50 PM
To: Vantage Group
Subject: [Vantage] Bi File

Our bi file has around 300 MB. Is it normal size or prefer size is smaller?
How big is your bi file?

Thanks in advance for your response.

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

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



[Non-text portions of this message have been removed]
2
Our bi file has around 300 MB. Is it normal size or prefer size is smaller? How big is your bi file?

Thanks in advance for your response.




[Non-text portions of this message have been removed]
3
Our BI is 1.7 Gigs which is larger than the DB file itself. 300MB doesn't
sound like anything to worry about.



I never really pay attention to it's size because it sits on a set of drives
that after raid is 146 gigs.



There are ways to keeps is size down though.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Bartosz Niemczewski
Sent: Wednesday, January 06, 2010 1:50 PM
To: Vantage Group
Subject: [Vantage] Bi File





Our bi file has around 300 MB. Is it normal size or prefer size is smaller?
How big is your bi file?

Thanks in advance for your response.

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





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