Owner manual

SDR Monitoring and Control
HP NonStop SQL DDL Replicator User’s Guide—545799-005
5-10
Updater-level Command
RETRY RDF-control
If an updater has a pending DDL operation that it is unable to execute, then RETRY
causes the updater to make a new attempt to execute the DDL operation. Note that an
updater will retry a failed DDL operation every minute. Issuing the RETRY explicitly
eliminates the delay and causes the updater to retry immediately.
In the example below a table cannot be created on the backup because there is
already a table of that name. In such cases, SDR displays errors in the EMS log to
notify the operator that the CREATE TABLE operation could not be performed. The
error is also reported by STATUS SDR or STATUS UPDATER, as shown below in first
STATUS UPDATER.
SDRCOM 10? 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 30
DDL translation 30
SQL process start 3
DDL execution 3
RDF update restart 3
Total processing time 8.029 seconds
Average processing time 2.676 seconds
Last DDL replication 5/ 2/08 13:09:59
Stop RDF Update file $QA3.ZASDR099.AA000013
Depot file $PEACH.ZASDR099.SDRDEPOT
Depot record key: $QA3 00000013
SQL statement: DROP TABLE \ATOM.$QA3.JCCSDSQL.JOJO3
SDRCOM 11? CANCEL ATOMJ
SDRCOM 8?