Extension Files

[TNGPicard]

Howdy Folks,

I have a very large table currently in 8.x format. When I run butil -stat I get the following output:

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.

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:

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.

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

 

[mirtheil]

When you rebuilt the file, it removed all of the extra space. It seems to have rolled the extension files into the main file but as soon as you add enough data to get above the 2GB mark, it'll be back.

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