CONTROLTABLELOCKOFF

Valid for

Replicat

Description

CONTROLTABLELOCKOFF can be entered as a global level toggle before and after map statements as well as an option of a map.

Default

NOCONTROLTABLELOCKOFF

Syntax

NOCONTROLTABLELOCKOFF|CONTROLTABLELOCKOFF

replicat repxyz

CONTROLTABLELOCKOFF
map $data
02.tssout.tableA, target $data03.tssout.tableA;
map $data02.tssout.tableB, target $data03.tssout.tableB;

or

replicat repxyz

map $data02.tssout.tableA, target $data03.tssout.tableA, controltablelockoff;

NOCONTROLTABLELOCKOFF
map $data02.tssout.tableB, target $data03.tssout.tableB;

CONTROLTABLELOCKOFF
map $data02.tssout.tableC, target $data03.tssout.tableC;

This parameter is to be used in the case where Replicat has a table lock granted preventing other applications from updating it and receiving error 73.

Note: Depending on the number of records updated in a single transaction, the use of MAXTRANSOPS might be also required to avoid receiving error -8300, 35 (Open lock unit limit has been reached).