-----Original Message-----
From: Luanne Peterson [mailto:lmpeterson@...]
Sent: Monday, September 27, 2004 4:43 PM
To: Reno Manno
Subject: Enable large files
SUMMARY:
XA510 2 GB
A new feature was implemented in the Version 9.1C Enterprise Database
product to enable database extents to be larger than 2GB.
EXPLANATION:
When large file processing is enabled for a database, a flag is set in
the master block to permanently mark the database. By default, large
file processing is NOT enabled. The reason for this is that once large
files are enabled, releases prior to 9.1C will be unable to use or open
these databases -- earlier releases don't have the code necessary to use
large files.
When large file processing is enabled for a database, fixed and variable
length extents with specified maximum sizes beyond 2GB are allowed.
If a variable length extent with no specified maximum size is created
for a database with large file processing enabled, the extent will be
allowed to expand to a maximum of 1 TB depending on the database
blocksize and records per block( with our block sizes this is likely to
be 256 GB max size). (See the chapter, "Progress Database Limits" in
the "Database Administration Guide and Reference" for details.)
For databases that do not have large file processing enabled, extents
will be restricted to a maximum of 2GB, or the size specified for it in
a .st file, whichever is less.
The following files will be allowed to exceed 2GB in size when large
file processing is enabled:
After Image Extents (.an)
Before Image Extents (.bn)
Control Area Extent (.db)
Data Extents (.dn)
Transaction Log File (.tn)
ADDITIONAL INFORMATION REGARDING 2GB FILE SIZE LIMITATIONS:
NOTE 1: Other files, in particular those that are directly accessed by
4GL client code (such as Data Dictionary .D files), still have a 2GB
size restriction.
NOTE 2: In addition, the Progress backup(PROBKUP), restore(PROREST),
binary dump, and binary load were enhanced to support large files in
version 9.1C.
PROBLEM RESOLUTION:
PROUTIL -- You can enable large file processing for a database by
running a new PROUTIL option. The syntax of the
command is as follows:
PROUTIL dbname -C EnableLargeFiles
where "dbname" is the name of the database. The database must be
offline when enabling large file processing. There is
no corresponding command to disable large file processing for a
database. Once large file processing is enabled for a
database, the database can not be accessed by Progress versions prior
to 9.1C.
Examples:
1) At the server, stop the 5.1 database in Progress Explorer.
2) Go to [START] --> Progress 9.1C --> Proenv.
3) At the prompt, type: prompt
4) Change directory into the C:\Epic51\Vantage\Db> folder.
4) At the C:\Epic51\Vantage\Db> prompt, type:
proutil vantage -C EnableLargeFiles
Vista/Vantage 6.x with Progress 9.1D:
1) At the server, stop the database in Progress Explorer.
2) Next go to [START] --> Progress 9.1D--> Proenv.
3) At the prompt, type: prompt
4) Change directory into the C:\epicor\mfgsys61\Db> folder.
4) At the C:\epicor\mfgsys61\Db> prompt, type:
proutil mfgsys -C EnableLargeFiles
Important Note: This option is ONLY SUPPORTED on Windows and Non-Intel
Unix boxes. It is NOT SUPPORTED on Intel UNIX and Linux. It was also
STRONGLY RECOMMENDED that the file system on Windows systems be NTFS and
NOT FAT32.
Luanne Peterson
Technical Support
www.epicor.com <http://epicor.com/>
Tel.: (800) 269-3044
Fax: (952) 582-5567
E-Mail: lmpeterson@... <outbind://39/(EmptyReference!)>
<http://support.epicor.com/epicmarcom/sigs/Epicoremail.gif>
195 Technology Drive, Irvine CA 92618 USA
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses.
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
[Non-text portions of this message have been removed]
From: Luanne Peterson [mailto:lmpeterson@...]
Sent: Monday, September 27, 2004 4:43 PM
To: Reno Manno
Subject: Enable large files
SUMMARY:
XA510 2 GB
A new feature was implemented in the Version 9.1C Enterprise Database
product to enable database extents to be larger than 2GB.
EXPLANATION:
When large file processing is enabled for a database, a flag is set in
the master block to permanently mark the database. By default, large
file processing is NOT enabled. The reason for this is that once large
files are enabled, releases prior to 9.1C will be unable to use or open
these databases -- earlier releases don't have the code necessary to use
large files.
When large file processing is enabled for a database, fixed and variable
length extents with specified maximum sizes beyond 2GB are allowed.
If a variable length extent with no specified maximum size is created
for a database with large file processing enabled, the extent will be
allowed to expand to a maximum of 1 TB depending on the database
blocksize and records per block( with our block sizes this is likely to
be 256 GB max size). (See the chapter, "Progress Database Limits" in
the "Database Administration Guide and Reference" for details.)
For databases that do not have large file processing enabled, extents
will be restricted to a maximum of 2GB, or the size specified for it in
a .st file, whichever is less.
The following files will be allowed to exceed 2GB in size when large
file processing is enabled:
After Image Extents (.an)
Before Image Extents (.bn)
Control Area Extent (.db)
Data Extents (.dn)
Transaction Log File (.tn)
ADDITIONAL INFORMATION REGARDING 2GB FILE SIZE LIMITATIONS:
NOTE 1: Other files, in particular those that are directly accessed by
4GL client code (such as Data Dictionary .D files), still have a 2GB
size restriction.
NOTE 2: In addition, the Progress backup(PROBKUP), restore(PROREST),
binary dump, and binary load were enhanced to support large files in
version 9.1C.
PROBLEM RESOLUTION:
PROUTIL -- You can enable large file processing for a database by
running a new PROUTIL option. The syntax of the
command is as follows:
PROUTIL dbname -C EnableLargeFiles
where "dbname" is the name of the database. The database must be
offline when enabling large file processing. There is
no corresponding command to disable large file processing for a
database. Once large file processing is enabled for a
database, the database can not be accessed by Progress versions prior
to 9.1C.
Examples:
1) At the server, stop the 5.1 database in Progress Explorer.
2) Go to [START] --> Progress 9.1C --> Proenv.
3) At the prompt, type: prompt
4) Change directory into the C:\Epic51\Vantage\Db> folder.
4) At the C:\Epic51\Vantage\Db> prompt, type:
proutil vantage -C EnableLargeFiles
Vista/Vantage 6.x with Progress 9.1D:
1) At the server, stop the database in Progress Explorer.
2) Next go to [START] --> Progress 9.1D--> Proenv.
3) At the prompt, type: prompt
4) Change directory into the C:\epicor\mfgsys61\Db> folder.
4) At the C:\epicor\mfgsys61\Db> prompt, type:
proutil mfgsys -C EnableLargeFiles
Important Note: This option is ONLY SUPPORTED on Windows and Non-Intel
Unix boxes. It is NOT SUPPORTED on Intel UNIX and Linux. It was also
STRONGLY RECOMMENDED that the file system on Windows systems be NTFS and
NOT FAT32.
Luanne Peterson
Technical Support
www.epicor.com <http://epicor.com/>
Tel.: (800) 269-3044
Fax: (952) 582-5567
E-Mail: lmpeterson@... <outbind://39/(EmptyReference!)>
<http://support.epicor.com/epicmarcom/sigs/Epicoremail.gif>
195 Technology Drive, Irvine CA 92618 USA
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses.
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
[Non-text portions of this message have been removed]