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