Standardized backup procedures allow for easier environment restoration in the event of system failures. Backing up the Business Integration Express for Item Sync system is also important because hardware or software failures may leave data in an inconsistent state between Business Integration Express for Item Sync and the integrated applications.
This section covers the following topics:
Plan and carry out procedures for regularly scheduled backups of the Business Integration Express for Item Sync system. The more frequently you perform backups, the less data you need to recover in the event of data loss. When planning a backup schedule, keep in mind the information in this section.
Within the Business Integration Express for Item Sync system, two types of data should be backed up: static data and dynamic data.
The relationship tables are stored by default in the repository database. If you store them in another database, you need to back up that database.
Following is a partial list of dynamic data in the Business Integration Express for Item Sync system:
Plan your backup schedule at times when your systems environment is in a quiescent state or in a state with a minimal amount of event processing. Business Integration Express for Item Sync is in a quiescent state when all of the following conditions exist:
Different components of the Business Integration Express for Item Sync environment require different backup procedures. The following topics are described in this section:
"Backing Up Relationship Tables"
"Backing Up and Loading the Repository"
"Backing up System Installation Files"
"Backing Up Collaboration Class Files"
Relationship tables are backed up using the standard backup utility for the database where these tables reside. Schedule this backup to coincide with the corresponding application backups. If you back up applications at different times, back up the relationship tables each time you back up an application. There are often static relationship tables within the relationship database. Although this data is static, it is recommended that you back up all relationship tables together. Make sure the Business Integration Express for Item Sync system is in a quiescent state when backing up the relationship tables. For more information on bringing the system to a quiescent state, see "Shutting down InterChange Server Express".
It is recommended that the relationship database log be mirrored to assist in recovery. If hardware/software cost is not a consideration, the relationship runtime data can also be mirrored.
The set of relationship tables for one relationship are closely associated, so you should back up all of these at the same time.
Back up relationship information using the standard backup utility from the DBMS (Database Management System) where these tables reside.
Repository tables are backed up using the repos_copy command. For more information on this command, see "Using Repos_Copy". Back up the repository whenever it is modified and before and after performing a reinstallation or a Business Integration Express for Item Sync software upgrade. The Business Integration Express for Item Sync system does not need to be in a quiescent state when backing up the repository.
The method to use for backing up the repository depends on whether your database is partitioned or unpartitioned.
If your databases are partitioned, you can use the standard database backup utility from the DBMS to back up the Repository, Event Management, and Transaction databases.
If your Business Integration Express for Item Sync databases are not partitioned, meaning they are contained in a single database, they should not be part of your normal database backup routine. The Business Integration Express for Item Sync databases contain transient data whose recovery can cause inconsistencies in the system. Instead, back up the objects in the Business Integration Express for Item Sync repository by using the repos_copy utility.
The system installation files should be backed up at the following stages:
Back up collaboration class files with your other non-Business Integration Express for Item Sync system files. Coordinate the repository backup with the collaboration class file backups.
Some applications have archive tables. Back up archive tables using the standard database utility for the database in which they reside. The archive tables are part of the Business Integration Express for Item Sync system, but typically reside in the application's database. Back up the archive tables on a regular basis. Data in the archive table represents all of the events that have passed from the application to the Business Integration Express for Item Sync system. These events can be used to "resynchronize" the application and the Business Integration Express for Item Sync cross-reference tables.