Hp Integrity NonStop J-Series Manuel d'utilisateur Page 37
- Page / 132
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Configuring SDR
HP NonStop SQL DDL Replicator User’s Guide—545799-007
3-5
Configuring SDR Replication
You can configure how you want SDR to handle DDL operations that are executed in a
user transaction, by setting the global parameter USERTRANSACTION to one of the
following options:
ABORT: disallow DDL inside a user transaction. If a user attempts such an
operation, the transaction is aborted, the DDL operation fails, and the database is
rolled back to the state it was when the transaction began. SDR writes a message
to the home terminal and to EMS whenever it aborts a transaction.
ASSUMECOMMIT: assume that user transactions containing DDL always commits.
SDR ignores the fact that the DDL is part of a user transaction and always
replicates it.
HOLD: allow the operator to manually review each DDL operation executed under
a user transaction, and decide if it should be executed or canceled. SDR and RDF
updating is suspended until the operation is either executed or canceled.
HOLD is the default.
Configuring SDR Replication
The following paragraphs describe global settings that control the replication of DDL
operations:
Setting CREATE Ownership and Security
Setting the User ID for Replicated DDL Operations
Automatic Catalog Creation
Replicating Unaudited Tables
Configuring the SDR Network
Be sure to set the global parameters on the primary and backup systems. Unlike RDF,
SDR does not copy its configuration files to the backup system, because a single
instance of SDR can service many RDF configurations, both primary and backup. Use
INFO GLOBALS
with the OBEYFORM option to capture and reenter the SDR global
settings from one system to another.
If SDR global settings are not the same on both the primary and backup systems, SDR
may not operate properly.
Setting CREATE Ownership and Security
You can configure the user ID that will own the tables, indexes and views resulting
from the replication of CREATE operations, by setting the global parameter CREATEID
to the desired value. By default, the owner of the new SQL objects is the owner of the
primary SQL object.
- 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.043 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels