Managing Database Connections
When the domains associated with shipping and receiving sites are in a single database, DRP processing is simplified. When they are in different databases, you must be aware of the impact of database connections.
In this case, to execute DRP at the shipping site, active database connections must be available. In the receiving site, it is possible to run DRP and transfer or import demand records later.
Receiving Database
When DRP is executed in the receiving database and determines that the shipping database is unavailable, it saves demand records in an equivalent table in the local database. Transfer these records to the shipping database in two ways:
• When the connection is restored, run Intersite Demand Transfer (12.15.9). This takes the records in the local table and moves them to the equivalent table (ds_det) in the other database.
If the intersite requests were modified in the shipping database while the connection was down, the transferred requests overwrite the new versions in the shipping database. It is assumed the intersite request records in the receiving database take precedence.