Solved

Backing up open Btrieve-Files

Posted on 1998-10-16
5
451 Views
Last Modified: 2008-03-04
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.
0
Comment
Question by:nmm
  • 2
  • 2
5 Comments
 

Expert Comment

by:drodey
ID: 1593760
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
 

Expert Comment

by:drodey
ID: 1593761
.
0
 
LVL 3

Expert Comment

by:brosenb0
ID: 1593762
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
 

Author Comment

by:nmm
ID: 1593763
because the answer from brosenb0 is much more usefull
0
 
LVL 3

Accepted Solution

by:
brosenb0 earned 100 total points
ID: 1593764
Nmm,

Is that what you where after?
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
A Short Story about the Best File Recovery Software – Acronis True Image 2017
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now