×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Extension Files

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:

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.



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.

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
 

RE: Extension Files

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close