Setting Up RDBMS

To set up the RDBMS database

• Select the Setup RDBMS command from the RPS menu on an RPS secondary system.

The following actions then take place.

1. Table creation scripts are generated and executed.

2. The data is extracted and loaded into the relational database.

The Jade RPS Manager window on the RPS node displays the progress of each process and its completion (that is, whether the script executed without error) or failure (for example, the target relational database failed to open).

When you use the Setup RDBMS command from the RPS menu, you cannot tailor values relating to each action as is the case when you select the corresponding commands from the File menu or the Extracts menu in the displayed dialog in which you specify your preferences. (For details, see "Generating Table Creation SQL Scripts", "Executing an SQL Script", and "Extracting Data and Loading it into the Relational Database", elsewhere in this chapter.)