Hitesh Shah
27th June 2003, 19:01
Many companies implement network license of Baan on more than 1 servers and replicate data and environment across 2 servers in order to insure against any disasters and maintain smooth flow of business operations in future by making system available all the time.
There could be many approaches to this. One apprach may be to update database online using database vendor's online replication capabilities .This approach take care off all database tables but not Baan file system objects (like program script, program object, report script , report object , forms,dlls , menus, includes , library files ($BSE/lib),table and domain dictionaries) which also are required to run the application successfully. One approach could be refresh the backup server at the day end with file system objects of primary server. However this approach has 2 problems.
1. File system objects could be restored only till the point of last backup and not till the point of failure.
2. Certain file system objects like table and domain dictionary may render table/domain unusable if it is different from actuals in the database (errors like 512 can come in backup server for tables which are reconfigured but their dictionaries not replicated across the backup server).
We have written a 3GL program which is attached to session without main table (so no form). This program reads the values of file system object from tools sessions which create/modify/delete this file system objects, compares these file system object across servers and refresh the same to baackup server if different.
Table and domain dictionaries have been replicated differently. 2 customized tables parallel to Baan table ttadv502 and ttadv501 are created. These are compared and updated for differences. Based on differences , file system objects are replicated (.new / .old / original)
This program checks file system object differences at regular frequence of 2 seconds .User can change this frequencey depending on his/her convenience.
Pre-requisite
000 company and live companies are replicated online through database.It work in Baan IV.It may be compiled and tested in BaanERP also.
Usage
This program can be run in 2 ways .
1. It can be used as a startup session in Baan in the startup group for people who do the customization and development. The program will close automatically when user closes Baan. For 1 user only 1 instance of this program will run. Subsequent runs will close automatically.
2.This session can be attached in a development menu (like tuddc00000000 ) at all development
sessions (nodes) of the menu and procesinfo be updated with the real development session code. This will make this program start in the background and this program in turn starting the real development session.
Caution
Users may need to change this program to suit their need in following aspects
1.Customized tables/hostnames / languges
2. File system objects to be replicated have to be decided (e.g. static library files may not be replicated).Further good testing before putting such code to use is mandatory.
3.We have used shell command at some place. User can replace the same with run.prog and OS
dependent commands.
There could be many approaches to this. One apprach may be to update database online using database vendor's online replication capabilities .This approach take care off all database tables but not Baan file system objects (like program script, program object, report script , report object , forms,dlls , menus, includes , library files ($BSE/lib),table and domain dictionaries) which also are required to run the application successfully. One approach could be refresh the backup server at the day end with file system objects of primary server. However this approach has 2 problems.
1. File system objects could be restored only till the point of last backup and not till the point of failure.
2. Certain file system objects like table and domain dictionary may render table/domain unusable if it is different from actuals in the database (errors like 512 can come in backup server for tables which are reconfigured but their dictionaries not replicated across the backup server).
We have written a 3GL program which is attached to session without main table (so no form). This program reads the values of file system object from tools sessions which create/modify/delete this file system objects, compares these file system object across servers and refresh the same to baackup server if different.
Table and domain dictionaries have been replicated differently. 2 customized tables parallel to Baan table ttadv502 and ttadv501 are created. These are compared and updated for differences. Based on differences , file system objects are replicated (.new / .old / original)
This program checks file system object differences at regular frequence of 2 seconds .User can change this frequencey depending on his/her convenience.
Pre-requisite
000 company and live companies are replicated online through database.It work in Baan IV.It may be compiled and tested in BaanERP also.
Usage
This program can be run in 2 ways .
1. It can be used as a startup session in Baan in the startup group for people who do the customization and development. The program will close automatically when user closes Baan. For 1 user only 1 instance of this program will run. Subsequent runs will close automatically.
2.This session can be attached in a development menu (like tuddc00000000 ) at all development
sessions (nodes) of the menu and procesinfo be updated with the real development session code. This will make this program start in the background and this program in turn starting the real development session.
Caution
Users may need to change this program to suit their need in following aspects
1.Customized tables/hostnames / languges
2. File system objects to be replicated have to be decided (e.g. static library files may not be replicated).Further good testing before putting such code to use is mandatory.
3.We have used shell command at some place. User can replace the same with run.prog and OS
dependent commands.