Automatically Initiating Drop/Reload Scripts

Product Information > JADE Synchronized Database Service (SDS) Administration Guide > Chapter 2 - Relational Population Service (RPS) Support > Automatically Initiating Drop-Reload Scripts

To enable the automation of reorganizations with Drop/Reload scripts, check the Auto Execute Drop/Reload check box on the Configure RPS Node dialog on the RPS node. (For details, see "Configuring your RPS Node", later in this chapter.). By default, the dropping and reloading of scripts is not automatically executed.

By default, data for historical tables is not loaded when the table is recreated. To enable the automatic loading of data for historical tables, check the Bulk Load Historical Tables check box on the Configure RPS Node dialog. (For details, see "Configuring your RPS Node", later in this chapter.)

Extracting and loading the tables may take significant time, depending on the size of the data to be extracted and loaded.

The ExtractBufferSize parameter in the [JadeRps] section of the JADE initialization file on the RPS node specifies the buffer size that is allocated for each concurrent file being written when extracting RPS files. This parameter defaults to 1M.

If you automate the extraction of table data for the Working Set mode, the data must be extracted on the primary SDS node during the transition phase of the reorganization. As the data is then loaded from the extracted files on the RPS node, a mapped disk share must therefore be available between the primary SDS node, the JADE RPS node, and the RDBMS database.

The [JadeRps] section of the JADE initialization file on the primary can contain the AutoExtractOnPrimary<n> parameter, which determines the automation of data extraction for the Working Set mode by specifying that RPS mapping changes and data are to be extracted when a reorganization takes place on an SDS primary node that is supporting an RPS database operating in Working Set database replication mode. For details, see the JADE Initialization File Reference.

The following is an example of the [JadeRps] section of the JADE initialization file on the primary node to extract data for an RPS node that has a Working Set database replication mode.