NonStop SQL DDL Replicator User's Guide (Update 6)

SDR Commands

HP NonStop SQL DDL Replicator User’s Guide—545799-006

6-13

INFO RUNTIME

Lists the SQL/MP components currently executing that are using the SDR runtime.

INSTALL RUNTIME

Performs the file duplications and renames required to install the new SDRRUNTM

while SQL utilities are still executing with the old SDRRUNTM:



Renames existing SDRRUNTM to OLDRUNTM



Renames and NEWRUNTM to SDRRUNTM



Duplicates and renames SQL utilities so that new instances of SQL processes will

use the new SDRRUNTM

INSTALL RUNTIME is executed by the INSTALL macro when a new version of SDR is

installed on the system.

new-runtime

the new SDR runtime that replaces the current SDRRUNTM.

Note that



Unlike INSTALL SDR, the INSTALL RUNTIME command does not need the SDR

monitor to be executing nor does it require the product to be licensed. This allows

the INSTALL RUNTIME to be executed by the INSTALL macro.



INSTALL RUNTIME does not perform the functions of INSTALL SDR: It does not

prepare the SQL utilities, nor does it check that they are prepared. It merely

duplicates executing utilities and renames them so that newly launched SQL

processes will use the new SDRRUNTM.

INSTALL SDR

Enables the replication of DDL statements by preparing a number of NonStop SQL

components residing in $SYSTEM.SYSTEM.

You must be a SUPER user with update access to the REGISTRY table to perform this

command.

INSTALL SDR must be repeated when a new version of SQL is installed on your

system. You can safely re-execute INSTALL SDR.

INFO RUNTIME

INSTALL RUNTIME new-runtime