RDBPROD: Using an OpenVMS Mailbox to Pipe between RMU/UNLOAD and RMU/LOAD (Doc ID 206325.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

Goal

When moving large amounts of data between two Oracle Rdb databases, often the RMU /UNLOAD and RMU /LOAD utilities are used to extract the data from one database and to load the data into another. Using a disk file as the destination for the unload and the source for the load would mean that these two operations must be done sequentially. However, by using an OpenVMS mailbox, it is possible to perform the unload and the load in parallel. Parallel processing can help keep multiple CPUs and disk drives/controllers busy and avoids the need for a disk file for sequential staging. 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms