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

Testing SDR

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

C-3

Testing Automated Operations on the Primary

To prevent the capture of DDL operations, you can set the

=_SDR_CAPTURE_DISABLE define as follows:

ADD DEFINE =_SDR_CAPTURE_DISABLE, CLASS MAP, FILE DUMMY

As long as that define is present in the TACL session, SDR will not capture the SQL

DDL in the audit file.

The define can be used until the scripts are fully debugged. Once they are debugged,

you can DELETE the define to test out the SDR replication of the DDL operations.

1 2 ... 124 125 126 127 128 129 130 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 129

Commenti su questo manuale

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