Testing, Moving to production, Testing automated operations on the primary – HP Integrity NonStop H-Series User Manual
Page 128: Testing c-2, Moving to production c-2, Testing automated operations on the primary c-2
Testing SDR
HP NonStop SQL DDL Replicator User’s Guide —545799-006
C-2
Testing
5. To prevent accidental updates, turn off replication by setting the RDFCONFIG
global to NOREPLICATE for all RDF configurations on the primary and backup
systems. In SDRCOM
ALTER RDFCONFIG DEFAULT NOREPLICATE
Testing
To execute testing scenarios:
1. DDLCAPTURE TESTING disables the capture SQL DDL operations, unless one of
2 specific enablers is present:
the CLASS MAP DEFINE =_SDR_TEST DEFINE is set prior to executing
SQLCI or any program performing SQL DDL or,
an empty file named ENABLSDR is present in the default subvolume. In this
case, the default subvolume refers to the default subvolume for the process
creator user id, not the current subvolume set by the VOLUME command.
To activate one of the enabling methods:
Add a DEFINE for =_SDR_TEST when executing DDL operations in SQLCI or
running any program performing SQL DDL:
ADD DEFINE =_SDR_TEST, CLASS MAP, file $DUMMY
or
Create an empty file named ENABLSDR in your default subvolume.
2. Enable DDL replication for the test RDF configuration. In SDRCOM:
ALTER RDFCONFIG test-RDF-control-subvolume AUTOMATIC
You are now ready to execute SQLCI or any application performing SQL DDL
operations.
Moving to production
Once the testing of SDR has completed, the following configuration changes will
activate DDL replication for all RDF configurations. In SDRCOM:
1. ALTER DDLCAPTURE ENABLED (or the higher level REQUIRED)
2. RESET GLOBAL RDFCONFIG
Testing automated operations on the primary
If in the course of testing DDL operations on the primary, for example to test obey files
or TACL macros, it may be desirable to prevent the capture of the DDL operations for
the duration of the test.