Hp Integrity NonStop J-Series Manuel d'utilisateur Page 58
- Page / 132
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
SDR Monitoring and Control
HP NonStop SQL DDL Replicator User’s Guide—545799-007
5-6
Updater-level Command
In the following example, STATUS UPDATE shows the SDR updater is in a HOLD
state, RESTART UPDATE is used to stop it and restart it and the subsequent STATUS
UPDATE shows the updater executing:
Updater-level Command
As mentioned in paragraph SDR Updater Processes on page 4-8, an SDR updater
manages one RDF configuration or RDF control subvolume. This is why SDR updater
commands operate on a single SDR updater process, identified by the RDF control
subvolume associated with this SDR updater.
HOLD RDF-control
RELEASE RDF-control
EXECUTE RDF-control
CANCEL RDF-control
SDRCOM 60? STATUS UPDATE
SDR monitor $ZSDR (5,627) is monitoring 1 RDF environment(s).
Current SDRUPDT processes: 1
Total SDRUPDT processes: 8
RDF Control Subvol ATOMJ
SDR Updater Process \SIERRA.$X8LB (3,410)
RDF Primary Sys \ATOM
RDF Backup Sys \SIERRA
State Updater executing (Update HOLD)
*** This updater is in HOLD state. ***
SDR Operation Count Failed
SDRDEPOT fetch 0
DDL translation 0
SQL process start 0
DDL execution 0
RDF update restart 0
No replications performed by this SDR updater.
SDRCOM 61? RESTART UPDATE
Restarting SDR updater ATOMJ with HOLD OFF.
SDRCOM 62? 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
SDR Operation Count Failed
SDRDEPOT fetch 0
DDL translation 0
SQL process start 0
DDL execution 0
RDF update restart 0
No replications performed by this SDR updater.
- HP NonStop SQL DDL 1
- Replicator User’s Guide 1
- Document History 2
- Legal Notices 3
- What’s New in This Manual 5
- General Syntax Notation 8
- About This Manual 10
- Change Bar Notation 10
- Configuring SDR 3-1 12
- SDR Operations 4-1 12
- SDR Commands 6-1 14
- SQL DDL Statements A-1 15
- SDR EMS Messages B-1 15
- Testing SDR C-1 16
- 1 Introducing SDR 17
- Product Overview 18
- SDR Components 18
- Introducing SDR 19
- Data Files 19
- Prerequisites 21
- Initial Installation 21
- Installing SDR 22
- Subvolume 22
- Install Product Files 23
- Start an EMS distributor 24
- Install the SDR License 26
- INSTALL SDR! 27
- Updating SDR Software 28
- System Software 29
- Disabling DDL Capture 30
- Removing SDR Software 30
- Changes to RDF Operations 30
- ZRDF-EVT-Msg-736 31
- ZRDF-EVT-Msg-908 31
- RDF Updaters 32
- 3 Configuring SDR 33
- INCLUDE and EXCLUDE 34
- Configuring SDR 35
- Retaining Captured DDL 36
- Transactions 36
- Configuring SDR Replication 37
- Automatic Catalog Creation 38
- Replicating Unaudited Tables 39
- Configuring the SDR Network 39
- 4 SDR Operations 41
- DDL Capture 42
- SDR Depot Files 43
- Stop RDF Update Audit Records 43
- Marker Files 43
- DDL Capture Operation 44
- Special cases 45
- Create Catalog 45
- CREATE Collation 45
- User Transactions 46
- DDL Replication 47
- SDR Updater Processes 48
- EMS Messages 48
- Replication Operations 48
- SDR Operations 49
- Translating DDL 50
- Executing DDL 50
- SDR and RDF Takeover 51
- Distributed Table Replication 51
- 5 SDR Monitoring and Control 53
- STATUS Commands 54
- STATUS MONITOR 54
- STATUS SDR 55
- STATUS RDF 55
- Controlling Replication 56
- Monitor-Level Commands 57
- START UPDATE 57
- STOP UPDATE 57
- RESTART UPDATE 57
- Updater-level Command 58
- HOLD RDF-control 59
- RELEASE RDF-control 59
- EXECUTE RDF-control 60
- CANCEL RDF-control 61
- RETRY RDF-control 62
- SDR Monitoring and Control 63
- Command Syntax 66
- Command Description Overview 66
- Table 6-3. Monitor commands 68
- Commands 69
- ALTER GLOBAL 70
- ALTER MONITOR 74
- CREATE SYSDB 75
- INFO GLOBALS 76
- INFO MONITOR 77
- INFO RUNTIME 77
- INSTALL RUNTIME 77
- INSTALL SDR 77
- START MONITOR 81
- STATUS RDF-control-subvol 83
- STATUS * 83
- STATUS UPDATER 84
- STOP MONITOR 84
- Utility Commands 85
- ALTER FILE 86
- FILEINFO 95
- SEMICOLON 99
- Monitor Commands 100
- SDR Commands 101
- BACKUPCPU 102
- A SQL DDL Statements 103
- DDL Statements 104
- SQL DDL Statements 104
- The RESTORE Utility 105
- SQL object in Statement 105
- WITH SHARED ACCESS Clauses 106
- B SDR EMS Messages 107
- SDR EMS Messages 108
- Informational Messages 108
- Critical Messages 114
- C Testing SDR 127
- Testing SDR 128
Produits connexes et manuels pour Matériel informatique Hp Integrity NonStop J-Series
(57 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.031 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels