HP NonStop G-Series - Manual (Page 27)

Installing SDR
HP NonStop SQL DDL Replicator User’s Guide —545799-005
2-7
Enable SQL for DDL Replication
After you have successfully installed your SDR license, SDRCOM notifies you that
SQL is not yet configured to perform DDL capture and replication:
To enable DDL replication, enter the INSTALL SDR command.
Because the SQL utilities might be in use at the time the INSTALL SDR command is
executed, SDRCOM performs the following operations to insure that SQL is correctly
enabled for SDR, without impacting the current users (here we assume SDR is
installed in $SYSTEM.SDR):
•
Notifies you that the SQL utilities will be unavailable for a brief moment, and
prompts for permission to proceed. If you are ready, enter Y.
•
Duplicates the utilities to $SYSTEM.ZASDR.SQLutilZ.
•
Prepares the duplicated copy SQLutilZ.
•
Renames $SYSTEM.SYSTEM.SQLutil to $SYSTEM.ZASDR.SQLutil,where it
continues to execute, if it is in use.
•
Renames the prepared $SYSTEM.ZASDR.SQLutilZ to
$SYSTEM.SYSTEM.SQLutil, enabled for SDR when the next user executes the
SQL utilities.
You are now able to replicate DDL operations for your RDF protected audited SQL
tables.
*Warning* $SYSTEM.SYSTEM.SQLCAT is not properly configured for use with
SDR.
* 1669 * This file must be the NonStop SQL/MP product program and it
* * must be activated for use with SDR with the following command:
* *
* * INSTALL SDR
* *
Note. The INSTALL SDR command makes an explicit check of the Read and Execute
security of sql components to insure that the objects can be read as well as executed. If the
objects can be executed but not read, INSTALL SDR issues the following error message to
notify the user of the available options to correct the security settings:
<object-file> has "<rwep>" security.
SDR-enabled processes must be able to read the object file.
Either adjust the security on this file or use the command
INSTALL SDR!
to allow SDR to make the required adjustment.
Note. . The next time INSTALL SDR is executed, SDRCOM will check that the
renamed files in ZASDR are now closed. If they are still running, INSTALL SDR will
terminate with an error message instructing you to stop them.