Owner manual

SDR Monitoring and Control
HP NonStop SQL DDL Replicator User’s Guide—545799-005
5-4
Controlling Replication
STATUS UPDATE
The STATUS UPDATE command shows the state of SDR updaters that are controlled
from a selected system. The DETAIL option adds the DEFINES and the text of the last
replicated DDL statement to the display. In the example below, the last statement was
a CREATE TABLE LIKE.
STATUS *
The STATUS * command, with a DETAIL option, is a combined form of STATUS RDF,
STATUS SDR
and STATUS UPDATE.
When submitting a problem report, you should always submit the output of STATUS
*,DETAIL with the problem description.
Controlling Replication
The SDR monitor process running on the primary system and the updaters running on
the backup system are controlled from the primary system using two types of
commands:
Monitor-Level Commands
Updater-level Command
SDRCOM 35? STATUS UPDATE ,DETAIL
SDR monitor $ZSDR (5,627) is monitoring 1 RDF environment(s).
Current SDRUPDT processes: 1
Total SDRUPDT processes: 3
RDF Control Subvol ATOMJ
SDR Updater Process \SIERRA.$X7DC (8,375)
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
RDF update restart 1
Total processing time 3.068 seconds
Average processing time 3.068 seconds
Last DDL replication 5/ 2/08 10:38:35
Stop RDF Update file $QA3.ZASDR099.AA000008
Depot file $PEACH.ZASDR099.SDRDEPOT
Depot record key: $QA3 00000008
SQL statement: CREATE TABLE \ATOM.$QA3.JCCSDSQL.JOJO
ADD DEFINE =DEPT, CLASS MAP, FILE $PEACH.JCCSDSQL.DEPT
CREATE TABLE \SIERRA.$PEACH.JCCSDSQL.JOJO LIKE =DEPT CATALOG
\SIERRA.$ORANGE.JCCSDCAT;
--- SQL operation complete.