Hp Integrity NonStop J-Series Manuale Utente Scaricare il pdf (Pagina 102)

SDR Commands

HP NonStop SQL DDL Replicator User’s Guide—545799-007

6-38

BACKUPCPU

The BACKUPCPU command specifies the cpu for the monitor backup process.

cpu

specifies the cpu number where the monitor backup process should be started. If

omitted, the backup process is terminated.

SWITCH

The SWITCH command causes the monitor primary and backup processes to

exchange roles.

MONITOR BACKUPCPU [ cpu ]

MONITOR SWITCH

1 2 ... 97 98 99 100 101 102 103 104 105 106 107 ... 131 132

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

Commenti su questo manuale

Nessun commento

Hp Integrity NonStop J-Series Manuale Utente Pagina 102

Commenti su questo manuale

Prodotti e manuali riguardandi Hardware del computer Hp Integrity NonStop J-Series