Owner manual

SDR Monitoring and Control
HP NonStop SQL DDL Replicator User’s Guide—545799-005
5-11
Updater-level Command
The operator purges the table on the backup system and issues a RETRY. The second
STATUS UPDATE shows that the table was created successfully:
SDRCOM 8?STATUS UPDATER
SDR monitor $ZSDR (3,978) is monitoring 1 RDF environment(s).
Current SDRUPDT processes: 1
Total SDRUPDT processes: 7
RDF Control Subvol ATOMJ
SDR Updater Process \SIERRA.$Z3JF (0,410)
RDF Primary Sys \ATOM
RDF Backup Sys \SIERRA
State Updater executing
SDR Operation Count Failed
SDRDEPOT fetch 1
DDL translation 1
SQL process start 1
DDL execution 1 1 ( 4 retries )
RDF update restart 0
DDL replication time 6/25/08 17:36:27
Stop RDF Update file $QA5.JASDR099.AA000006
Depot file $LEMON.JASDR099.SDRDEPOT
Depot record key: $QA5 00000006
SQL statement: CREATE TABLE \ATOM.$QA5.JCCSDSQL.MYTAB
*** SQL DDL execution error: -1221
---> At this point, the operator purges the table on \SIERRA
SDRCOM 17? RETRY ATOMJ
SDRCOM 3? status update
SDR monitor $ZSDR (3,978) is monitoring 1 RDF environment(s).
Current SDRUPDT processes: 1
Total SDRUPDT processes: 7
RDF Control Subvol ATOMJ
SDR Updater Process \SIERRA.$Z3JF (0,410)
RDF Primary Sys \ATOM
RDF Backup Sys \SIERRA
State Updater executing
SDR Operation Count Failed
SDRDEPOT fetch 1
DDL translation 1
SQL process start 1
DDL execution 1 1 ( 0 retries )
RDF update restart 1
DDL replication time 6/25/08 17:40:21
Stop RDF Update file $QA5.JASDR099.AA000006
Depot file $LEMON.JASDR099.SDRDEPOT
Depot record key: $QA5 00000006
SQL statement: CREATE TABLE \ATOM.$QA5.JCCSDSQL.MYTAB
*** SQL DDL execution error: 0