Solved

Backing up open Btrieve-Files

Posted on 1998-10-16
5
466 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

947 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

22 Experts available now in Live!

Get 1:1 Help Now