HP Integrity NonStop H-Series Uživatelská příručka stáhnout pdf (Strana 237)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

228

ALTFILEMAPPING – The target alternate key files or indexes are

created using the mapping algorithm described above. This is the

default if no altkey file/index mapping options are specified.

NOALTFILEMAPPING – The target alternate key files or indexes

are created with the exact same name as the source alternate key

files or indexes on the target node.

CLOSETABLES – By default for SQL/MP alter events, the

Consumer will not close its target tables before processing the

CLOSE event. By specifying CLOSETABLES, the Consumer will

close its target tables prior to replicating the create for the related

target table.

NODDLCOORDINATION – By default, all Consumers will complete

processing of all in-progress and queued messages (“drained”)

before an CREATE event is processed. This is necessary for

coordinating the order of the events being processed. By

specifying NODDLCOORDINATION, the Consumers will not be

“drained”. The CREAETE event will be sent to the related

Consumer in the same manner as insert, update, and delete

events. Note that the coordination is controlled by the related

Collector process. It “drains” all of its Consumers before sending a

DDL event.

CREATES { ON }

{ OFF }

Initial Changed

Version Version Values Default Minimum Maximum Alter

3.943 5.002 OFF OFF ON No

This is used to define if Enscribe file or SQL/MP create events are to be

replicated to the target. By default, this parameter is set to OFF. Set it to

ON to enable the feature. If NOALTFILEMAPPING is enabled and if the

file/table contains alternate key files/indexes and/or partitions, the target

must exist on a different node from the source file/table. Otherwise the file

create is ignored to avoid corrupting the source file’s alternate-key files

and/or partitions.

Notes: In version 3.943, DBS parameters were added to filter file

purge and create events to the Consumer’s user exits. However it

was up to the user to add the file create and purge logic to HP

Shadowbase via user exit routines. In v4.060B this functionality

was added to the standard HP Shadowbase product.

1 2 ... 232 233 234 235 236 237 238 239 240 241 242 ... 345 346

Žádné komentáře

HP Integrity NonStop H-Series Uživatelská příručka Strana 237