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 $data02.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).