Hp Integrity NonStop J-Series Instrukcja Użytkownika Pobierz pdf (Strona 35)

Configuring SDR

HP NonStop SQL DDL Replicator User’s Guide—545799-007

3-3

Configuring SDR

The following paragraphs describe global settings that control the capture and

replication of DDL operations.

The global settings are changed using the ALTER GLOBAL command and reset to

their default with the RESET command.

To issue the ALTER and RESET commands you must be a SUPER user and have

update access to the REGISTRY table in the SDRSYSDB subvolume.

Configuring SDR Capture

Configuring SDR Replication

Configuring SDR Capture

The following paragraphs describe global settings that control DDL capture:

Enabling and Disabling SDR

Requiring DDL Capture

Retaining Captured DDL

Handling DDL Operations performed under a User Transactions

Enabling and Disabling SDR

It is highly recommend to leave the SDR monitor running at all times. If it becomes

necessary to disable DDL capture for any reason, it can be done by setting the

DDLCAPTURE global parameter to DISABLED.

Testing DDL Capture

When SDR is first installed, you may wish to test its functionality without enabling DDL

capture for all users. To do this you can set the global parameter DDLCAPTURE to

TESTING. This is similar to DISABLED but allows you to enable DDL capture on a

selective basis. See Appendix C, Testing SDR for more details.

Requiring DDL Capture

When a DDL operation is performed on a SQL table, operational problems could

prevent SDR from capturing and preserving the DDL statement for replication. For

example, if the SDR monitor is stopped, DDL capture is impossible, or if a security

error prevents SDR from accessing its own files, then the statement cannot be stored.

The capture problem on the primary table might cause the backup table to become

inconsistent or unusable.

ALTER [GLOBAL] parameter-and-value

1 2 ... 30 31 32 33 34 35 36 37 38 39 40 ... 131 132

Brak uwag

Hp Integrity NonStop J-Series Instrukcja Użytkownika Strona 35