Extension Files
Extension Files
(OP)
Howdy Folks,
I have a very large table currently in 8.x format. When I run butil -stat I get the following output:
When I use Pervasive utilities and rebuild the file to format 9.5 to a separate directory and run the command on the rebuilt file I get:
in \history
ITMAUDIT.btr is 2,147,483,648 bytes
ITMAUDIT.^01 is 447,913,687 bytes
the rebuilt file is 2,113,970,176 bytes
So my question is
When I do the rebuild and go to file version 9.5, does the rebuilt file have the extension file "rolled into" it? Since I hope to use Pervasive Backup Agent - when a 64bit one is available, and its setup instructions that I received say to excelude *.^* from backupu since these are files created when the agent is running, I need to eliminate the extension file.
Opinions?
TNGPicard
I have a very large table currently in 8.x format. When I run butil -stat I get the following output:
CODE
E:\lmfjcomp\HISTORY>"c:\Program Files (x86)\Pervasive Software\PSQL\bin\butil.exe" -stat ITMAUDIT.BTR
Btrieve Maintenance Utility 10.10.125.000
Copyright (C) Pervasive Software Inc. 2008
All Rights Reserved.
File Statistics for ITMAUDIT.BTR
File Version = 8.00
Page Size = 4096
Page Preallocation = No
Key Only = No
Extended = Yes
Extension Filename List:
E:\LMFJCOMP\HISTORY\ITMAUDIT.^01
Total Number of Records = 3209242
Record Length = 1744
Record Compression = Yes
Page Compression = No
Variable Records = No
Free Space Threshold = 5%
Available Linked Duplicate Keys = 0
Balanced Key = No
Log Key = SYSKEY
System Data = Yes
SYSKEY Status = Present
Total Number of Keys = 6
Total Number of Segments = 18
Key Position Type Null Values* ACS
Segment Length Flags Unique Values
0 1 3 10 String -- 3209242 --
....truncated for posting
6 1 3 10 String RMD -- 142899 --
Legend:
......
?? = Unknown
-- = Not Specified
The command completed successfully.
Btrieve Maintenance Utility 10.10.125.000
Copyright (C) Pervasive Software Inc. 2008
All Rights Reserved.
File Statistics for ITMAUDIT.BTR
File Version = 8.00
Page Size = 4096
Page Preallocation = No
Key Only = No
Extended = Yes
Extension Filename List:
E:\LMFJCOMP\HISTORY\ITMAUDIT.^01
Total Number of Records = 3209242
Record Length = 1744
Record Compression = Yes
Page Compression = No
Variable Records = No
Free Space Threshold = 5%
Available Linked Duplicate Keys = 0
Balanced Key = No
Log Key = SYSKEY
System Data = Yes
SYSKEY Status = Present
Total Number of Keys = 6
Total Number of Segments = 18
Key Position Type Null Values* ACS
Segment Length Flags Unique Values
0 1 3 10 String -- 3209242 --
....truncated for posting
6 1 3 10 String RMD -- 142899 --
Legend:
......
?? = Unknown
-- = Not Specified
The command completed successfully.
When I use Pervasive utilities and rebuild the file to format 9.5 to a separate directory and run the command on the rebuilt file I get:
CODE
File Statistics for e:\ITMAUDIT.BTR
File Version = 9.50
Page Size = 4096
Page Preallocation = No
Key Only = No
Extended = No
Total Number of Records = 3209242
Record Length = 1744
Record Compression = Yes
Page Compression = No
Variable Records = No
Free Space Threshold = 5%
Available Linked Duplicate Keys = 0
Balanced Key = No
Log Key = SYSKEY
System Data = Yes
SYSKEY Status = Present
Total Number of Keys = 6
Total Number of Segments = 18
Key Position Type Null Values* ACS
Segment Length Flags Unique Values
0 1 3 10 String -- 3209242 --
......
6 1 3 10 String RMD -- 142899 --
Legend:
........
-- = Not Specified
The command completed successfully.
File Version = 9.50
Page Size = 4096
Page Preallocation = No
Key Only = No
Extended = No
Total Number of Records = 3209242
Record Length = 1744
Record Compression = Yes
Page Compression = No
Variable Records = No
Free Space Threshold = 5%
Available Linked Duplicate Keys = 0
Balanced Key = No
Log Key = SYSKEY
System Data = Yes
SYSKEY Status = Present
Total Number of Keys = 6
Total Number of Segments = 18
Key Position Type Null Values* ACS
Segment Length Flags Unique Values
0 1 3 10 String -- 3209242 --
......
6 1 3 10 String RMD -- 142899 --
Legend:
........
-- = Not Specified
The command completed successfully.
in \history
ITMAUDIT.btr is 2,147,483,648 bytes
ITMAUDIT.^01 is 447,913,687 bytes
the rebuilt file is 2,113,970,176 bytes
So my question is
When I do the rebuild and go to file version 9.5, does the rebuilt file have the extension file "rolled into" it? Since I hope to use Pervasive Backup Agent - when a 64bit one is available, and its setup instructions that I received say to excelude *.^* from backupu since these are files created when the agent is running, I need to eliminate the extension file.
Opinions?
TNGPicard
Talk To Other Members
RE: Extension Files
In v9.5, you can set an option to have a monolithic file (no extensions) but you'd need to rebuild the file if it's over 2GB already.
Can you point me to the docs that say to exclude extension files? I would think that would be very bad because without the extension file, the file itself is incomplete.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com