Is there a need for users to be out of Baan while doing sequential dump of tables (in a job)?
If answer is Yes - how can I temporary kick-out users (if there is any hanging by night...) in a job SCRIPT !?
Aix/BaanIVc4
If answer is No - is there a problem of locked tables for dump, or dump can be done on table which is accessed in moment of dump?

Thanks

The problem with dumping tables if users are online that you can't assure that the data is consistent.

Users can lock tables so you will not be sure that you can dump the table.

Scripts can be called from out of the job, however you should be root if you want to be able to kill other users processes or should use a script with a setuid bit on.

Regards,
Han

Thanks Han,

is there some script (or script repository on the web) which will help me to not forget something needed in script (like env. variables and so ...) for UNIX(AIX) / BAAN IVc.

I'm not so new in Unix; but I'm real newbie in Baan adm.

Thanks again

In our company we don't have the time to take dumps without user are online.
therefore I take the dumps at time with minimum users online.

if a user reach the table while dumping it. the user gets an error message and cannot working but the but the dump don't stop

hpux/baan4c3/informix

Caner

You can never be 100% sure of a consistent dump if any user or job processes are accessing the tables. Therefore you should stop all user and job processes, then run your bdbpre. The easiest to get rid of running bshells is to make a shell script.

Hi Patrick,

our factory works 7 * 24 and can not log off user to take dumps.

will there be problems if I need to use this dumps with bdbpost

there are not errors in the dump's error file.

Caner

Caner,

If you don't have any errors in your dump log file, then it should be OK. But check your log file after each backup to be safe.

But Caner.B is using informix and the informix tools support online backup, so that shouldn't be a problem.

However Karlovac is using bisam, that totally different.

Depending on how much the software is changing I would go for a weekly backup of the baan software and on a daily basis make a backup of the bisam files.

You can simple use the unix tools (cpio/tar/dump etc.) to backup the .bdt and .bid files. You don't need any baan env. settings for that.

To stop the bisam db you can simple use the rc.stop script which contains all the necessary env. variable already.

Han

Hi there,

even with no errors in the log of bdbpost, your dump is most likely inconsistent!

Depending of the size of your company, your dump might take several hours.

If at 22.00 you start dumping lets say the tc tables.
And at 23.00 somebody is changing tc and ti and at 24:00 you are dumping ti tables, then your dump is inconsistent.

This will not result in any errors in the logs.

If you are actually a 24x7 company, then you definetely should use a database like oracle or informix. If you use a database, then you can easily use the online backup feature and be on the safe side!

If you still use tbase, then you have to migrate. There is no way around.

Sorry

markus

Yep Markus is right. Especially when your backup takes a good while you while loose logical consistency within your data unless only read-only operations are performed. If you are already using Informix than I would definatively recommended taking a look at the Informix backup tools.

We are using Informix Dynamic Server Version 7.31.FD1

and every day I take backups from the informix side including logical logs.

I think that I can use the dumps by loosing just one or a few tables from baan instead of the informix backups.

And I know that the baan dump are can never %100 consistent for me , but I don't have any alternatives.

Thank you all very much

Caner

Thanks for replays
This thread od messages is like a good online backup cookbook.
Only one thing is missing (my opinion):
Does someone has a solution in form of script for all that was said for Bisam database (it should be helpful for other db too):

Story goes;
In a time of night (day) when smallest number of users are active in Baan - Baan Job takes control
Job should contain unix script which will:
1. Write to all users that should logout after 30 minutes
(wall for unix/ascii users and ? for bw users)
2. After 30 minutes kill users and make Baan unavailable for
all users ascii/bw/bx users
3. Do the bdbpre (command line) dump of tables
4. Make all steps to make Baan available to users.

Does anybody have good will to share her/hes script with all of us.

Thanks again
Dubravko - Karlovac