
HP NonStop Shadowbase Command Definitions
Database Specification Command Descriptions
HP NonStop Shadowbase Command Reference Manual—785421-002
218
need to be configured on the other node to pick up and replicate the
distributed partitions.
Note: If you plan to utilize the SOLV loader for a related DBS object that
has ALLPARTITIONS set ON, you should set the SOLV
TARGETFNAME parameter to the subvol of the primary partition of
the DBS SOURCEFILE value. Additionally, if your DBS object has
MAPTOFILE set, then you should set the SOLV TARGETFNAME
parameter to the subvol of the DBS MAPTOFILE value.
ALLUPDATES { ON }
{ OFF }
Initial Changed
Version Version Values Default Minimum Maximum Alter
2.000 ON OFF ON No
When set to ON, indicates that all updates should be applied, even if the
before and after image are the same. The default is ON; updates will be
applied even if the before and after image are the same.
Note: Turning it OFF may cause additional overhead in the Consumer
when replicating to SQL target tables.
ALTEROPTIONS { alter-processing-option }
{ ( alter-processing-option [, alter-processing-option] ...)}
Initial Changed
Version Version Values Default Value Specificatons Alter
5.002 <See Below> Valid Alter processing options
No
This parameter provides additional processing options when the
Consumer receives an ALTER event.
Valid ALTEROPTOINS are as follows:
CLOSETABLES – By default for SQL/MP alter events, the
Consumer will not close its target tables before processing the
ALTER event. By specifying CLOSETABLES, the Consumer will
close its target tables prior to replicating the alter against the
related target table.
NODDLCOORDINATION – By default, all Consumers will complete
processing of all in-progress and queued messages (“drained”)
before an ALTER event is processed. This is necessary for
coordinating the order of the events being processed. By
Comentários a estes Manuais