We have a table PLPF.ARCLOBTB that we are considering changing from page
level locking to row level locking to minimize the number of abends on batch
jobs because of timeouts. There is a column on this table with a type of CLOB.
The manual indicates that you can't have row level locking on a CLOB tablespace but it does not mention anything about a CLOB column.
Is is possible to have row level locking on this table and is there anything that should be considered before changing to row level locking? This table is currently updated by the DEBS stored procs and a batch job.
thanks
level locking to row level locking to minimize the number of abends on batch
jobs because of timeouts. There is a column on this table with a type of CLOB.
The manual indicates that you can't have row level locking on a CLOB tablespace but it does not mention anything about a CLOB column.
Is is possible to have row level locking on this table and is there anything that should be considered before changing to row level locking? This table is currently updated by the DEBS stored procs and a batch job.
thanks