C testing sdr, Overview, Setting up the test environment – HP Integrity NonStop H-Series User Manual
Page 127: Testing sdr c-1, Overview c-1, Setting up the test environment c-1, Appendix c, testing sdr, Before, Testing sdr
HP NonStop SQL DDL Replicator User’s Guide —545799-006
C-1
C
Testing SDR
Overview
Testing of SDR is dependent on the resources available. If you have a separate testing
environment with RDF configured between two development and or testing nodes,
then there is less concern that SDR testing might impact production activities. But,
many installations have only two systems: the production database and backup
database nodes, with the backup used for testing and development. For this reason,
SDR supports a special testing configuration, so that SDR can be tested on the
production node, without impacting the production work.
The SDR testing capability supports parallel (production and test) RDF configurations.
This capability allows the user to enable SQL for SDR but keeps DDL capture
disabled, except for the specific users and programs that perform test DDL operations.
This testing capability is used to avoid replicating operations stored in the TMF audit
trail that affect the production RDF. Such operations include updates to the
SDRDEPOT files and the insertion of STOP-RDF-UPDATE messages. The production
RDF can be isolated from DDL operations that are replicated by the test RDF.
This appendix describes how RDF and SDR can be configured for testing. It also
describes how the capture on DDL operations can be temporarily suspended when
testing DDL execution scripts on the primary.
Setting up the Test Environment
Testing automated operations on the primary
Setting up the Test Environment
1. It is simpler if the test RDF is configured to replicate separate volumes from the
production RDF. The testing facility does not isolate RDF configurations that share
volumes.
If, through the use of INCLUDE and EXCLUDE options, the test and production
RDF configurations share a volume, you will see specific messages in the EMS log
on the backup system that can be safely ignored. See the description of the
messages in paragraph
ZRDF-EVT-Msg-700, ZRDF-EVT-Msg-705
2. Install SDR on both primary and backup systems, as described in
Enable SQL for DDL Replication
3. In SDRCOM, set the global parameter DDLCAPTURE to TESTING, on the primary
and backup systems:
ALTER DDLCAPTURE TESTING
4. In SDRCOM, enable SQL for SDR:
INSTALL SDR