Ddl capture operation, Marker files and recent rdf releases, Ddl capture operation 4-4 – HP Integrity NonStop H-Series User Manual
Page 44
SDR Operations
HP NonStop SQL DDL Replicator User’s Guide —545799-006
4-4
DDL Capture Operation
$DATA.ZASDR004.AA000123. Marker files are managed automatically by SDR. They
occupy no disk space. SDR purges marker files when they are no longer needed.
Marker Files and Recent RDF Releases
In recent releases of RDF, T0346H11, ACN, ACP or later, the RDF Extractor no longer
checks for the existence of files referenced in the SRU audit record. As a result,
Marker files are no longer needed. You can suppress the creation of Marker files by
setting the global parameter MARKERFILES to OFF. If SDR detects that a recent
version of RDF is present on the system and that Marker files creation is enabled,
displays the following recommendation:
Note that by default, the Marker files are still created as a preventive measure. If the
creation of Marker files is disabled and SDR finds older versions of RDF on the
system, the following EMS message is displayed periodically:
The same message is displayed by
DDL Capture Operation
You can perform DDL operations in an application program, in SQLCI, or in other
subsystems such as ODBC or DBA/m. In any of these cases, SDR is informed at
various points of the DDL processing and performs some additional operations as
described in this chapter.
DDL capture is completely independent of the RDF configuration. In the general case,
RDF need not be configured when the primary DDL operation occurs.
When a DDL operation occurs, SQL performs numerous catalog updates and file label
operations. It usually performs these as a single TMF transaction. During the DDL
processing, SDR captures the operation, including environmental information such as
DEFINEs and default subvolumes.
WARNING. Purging Marker files manually can cause RDF to abort with no possibility of
restart. You would need to re-initialize RDF to an audit location after the SRU record that
references the marker file, and likely lose database audit that keeps the backup database
synchronized.
---
--- In your SDR configuration the MARKERFILES global is ON, but
--- there are no RDF versions installed that require marker files.
--- Unless you might install an older version of RDF, you can set
--- the MARKERFILES global to OFF.
---
The RDF software module <ref-version> has version
procedure <vproc>. This version of RDF requires the
creation of SDR marker files. Issue the command
ALTER GLOBAL MARKERFILES ON
to enable creation of marker files.