Hp Integrity NonStop J-Series Manuel d'utilisateur Page 26
- Page / 132
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Installing SDR
HP NonStop SQL DDL Replicator User’s Guide—545799-007
2-6
Install the SDR License
1. Creates the REGISTRY table in subvolume $SYSTEM.SDRSYSDB. If creating
tables on $SYSTEM is difficult due to system security or if $SYSTEM is not
audited, specify an alternative volume using the ON volume option. SysDB may be
created on any audited volume.
The REGISTRY table is owned by the SUPER user that issues the CREATE
SYSDB command and has a default security of “NOOO”. The REGISTRY table
owner is the SDR owner who is authorized to manage SDR.
Use the SECURE option to secure REGISTRY differently. Setting the write security
to “G” will allow all SUPER users to manage SDR.
2. Creates an SQL catalog on the volume specified in the CREATE SYSDB
command, in a subvolume called SDRCATLG. Use the CATALOG option to specify
a different catalog.
3. Starts start the SDR monitor $ZSDR. This is the default name for the SDR monitor.
See CREATE SYSDB on page 6-11 for details on the command options.
Install the SDR License
Follow the licensing procedure described in the documentation that accompanies the
SDR software. The license is installed by entering the SDRCOM license command as
it is supplied by HP. If you move the SDR to a different system, you must request a
license for that system.
After you have successfully installed your SDR license, SDRCOM displays the state of
your license:
To display the status of your SDR software license subsequently, use the Monitor
STATUS LICENSE command.
Enable SQL for DDL Replication
If you are installing SDR on a system that hosts the production application or database
and intend to test SDR on the system, please consult Appendix C, Testing SDR
before
you enable SQL for DDL replication.
Note. If you are upgrading your SDR license from a limited license to a permanent
license, simply install the new license received from the License Manager. Installing a
valid license is not disruptive and does not require any interruption of SQL operations.
- 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.036 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels