Owner manual

SDR Monitoring and Control
HP NonStop SQL DDL Replicator User’s Guide—545799-005
5-9
Updater-level Command
In the example below, the updater is in a hold state and holding a DROP TABLE
statement as shown by STATUS UPDATE. The subsequent EXECUTE causes the
updater to execute the DROP statement
CANCEL RDF-control
If an updater has a pending DDL operation, either because the updater is in hold or
because the updater is unable to execute the operation, CANCEL discards the pending
DDL and the RDF updaters are restarted.
SDRCOM 6? STATUS UPDATE
SDR monitor $ZSDR (5,627) is monitoring 1 RDF environment(s).
Current SDRUPDT processes: 1
Total SDRUPDT processes: 9
RDF Control Subvol ATOMJ
SDR Updater Process \SIERRA.$X8MZ (4,379)
RDF Primary Sys \ATOM
RDF Backup Sys \SIERRA
State Updater executing
*** This updater is in HOLD state. ***
SDR Operation Count Failed
SDRDEPOT fetch 20
DDL translation 20
SQL process start 2
DDL execution 2
RDF update restart 2
Total processing time 5.432 seconds
Average processing time 2.716 seconds
Last DDL replication 5/ 2/08 12:49:56
Stop RDF Update file $QA3.ZASDR099.AA000012
Depot file $PEACH.ZASDR099.SDRDEPOT
Depot record key: $QA3 00000012
SQL statement: DROP TABLE \ATOM.$QA3.JCCSDSQL.JOJO4
SDRCOM 7? EXECUTE ATOMJ
SDRCOM 8?