Backing up open Btrieve-Files

Any Idea how to update several open btrieve-files?
Version-Info: Btrieve 6.15
Backup: Backupexec
or        Arcsolo

The problem is, that the files in question are large (80 ... 150 MB) and that the update takes to long time.
Further: there are several Files with corresponding
content, so that it may produce troubble, if one
update file 1 at time x and file 2 at time x+y, y>0; because
file 2 may be changed between x and x+y, so that the
files on the update-tape may be not consistent.

Up to now we claim a break for updating for about 90 Min.,
but this is too long.
nmmAsked:
Who is Participating?
 
brosenb0Connect With a Mentor Commented:
Nmm,

Is that what you where after?
0
 
drodeyCommented:
St. Bernard's Open File Manager for Novell allows you to access open files, from almost any backup software as well as from regular copy/del commands.
Maybe you test with an eval copy..
0
 
drodeyCommented:
.
0
 
brosenb0Commented:
Hi Nmm, Here's the answer as promised.

Btrieve 6.10 and greater supports what is known as continuous operations mode.  When a Btrieve file is placed into this mode, a delta file is created with the same file name as the original, however, the extension is .^^^ .  All writes to the file are now written to the delta file, with the original file frozen for the duration of the backup.  When the backup is complete and continuous operations mode has completed, all changes within the delta files are merged into the originals and the delta files are deleted.  By placing all related files within a database into a backup group, they can all be placed into continuous operations mode at the same time, effectively freezing the database for a backup snapshot that ensures referential integrity, whilst not restricting your users.

Ways to place files into continuous operations mode: -

1) The Btrieve supplied file manager, BUtil.Nlm can place files into continuous operations mode with the -STARTBU command.  You can pass a command line parameter to BUtil that specifies a text file containing a list of all Btrieve files within the backup group.  To end continuous operations mode, use the -ENDBU command.  These can be run by ARCserve pre & post job scripts or they could be run at a set time by Chron.Nlm from Novell.  Check out the BUtil section in your Btrieve 6.15 user's manual.  Online info can be found at www.pervasive-sw.com.

2) Cheyenne (CA) have a DBAgent for Btrieve on a NetWare server, that works with ARCserve 4 or greater.  Not sure if it works with ARCsolo, you will have to check with Cheyenne.  Using a Cheyenne supplied configuration utility, you create a configuration file containing the name of a file group and the list of files belonging to the group.  ARCserve contacts the agent prior to the backup and the agent instructs Btrieve to start continous operations mode.  A similar process occurs after all files in the group have been backed up to end continuous operations mode.  More info at www.cheyenne.com.


Caveat empor: -

1) You cannot have multiple files that have the same name and different extensions, eg. user.dat and user.hst.  This will cause a problem as Btrieve will place user.dat into continuous ops mode and then fail when it trys to do user.hst as user.^^^ already exists.

2) Btrieve must be manually told which files to place into continuous operations mode, you cannot specify wild cards.  If your application dynamically creates new Btrieve files then the above methods may not be suitable for you.  I have seen accounting applications that create a new file every time a new fund is created.  If this is the case with your app then I would suggest using the Cheyenne backup agent for open files or OFA.  This uses different methods to achieve a similar result and is not quite as clean as the native Btrieve agent.

3) Don't try to place more than around 1000 files into a group or your server will Abend.



Have fun.
0
 
nmmAuthor Commented:
because the answer from brosenb0 is much more usefull
0
All Courses

From novice to tech pro — start learning today.