My Oracle Support Banner

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

Last updated on APRIL 14, 2022

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

To view full details, 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 a vibrant support community of peers and Oracle experts.