HP NonStop G-Series - Manual (Page 60)

SDR Monitoring and Control
HP NonStop SQL DDL Replicator User’s Guide —545799-005
5-8
Updater-level Command
In the following example, the SDR updater is on hold and there is a pending DDL
statement as shown by STATUS SDR. The subsequent RELEASE causes the updater
to execute the pending statement:
EXECUTE RDF-control
If an updater has a pending DDL operation, EXECUTE causes the updater to execute
the pending DDL operation immediately. The operation may be pending because the
updater is in the hold state or because the operation requires manual intervention. An
example of the latter is a DROP operation when REPLICATEPURGE has not been
enabled.
SDRCOM 65? STATUS SDR
SDR monitor $ZSDR (5,627) is monitoring 1 RDF environment(s).
Current SDRUPDT processes: 1
Total SDRUPDT processes: 9
-----------
RDF ATOMJ (\ATOM -> \SIERRA) at 5/ 2/08 12:09:35
Current State: Update NSA Stopped
All 5 updaters are awaiting a SQL DDL operation.
File name is $QA3.ZASDR099.AA000010.
SDR Updater \SIERRA.$X8MZ
Last DDL replication 5/ 2/08 12:09:31
Stop RDF Update file $QA3.ZASDR099.AA000010
Depot file $PEACH.ZASDR099.SDRDEPOT
Depot record key: $QA3 00000010
SQL statement: CREATE TABLE \ATOM.$QA3.JCCSDSQL.JOJO3.
SDRCOM 66? RELEASE ATOMJ