On onconfig file have parameter for USELASTCOMMITTED
USELASTCOMMITTED - Controls the committed read isolation level.
# Acceptable values are:
# - "NONE" Waits on a lock
# - "DIRTY READ" Uses the last committed value in
# place of a dirty read
# - "COMMITTED READ" Uses the last committed value
# in place of a committed read
# - "ALL" Uses the last committed value in place
# of all isolation levels that support the last
# committed option
Currently we used default value "NONE" , If we change it to "ALL", it will help to solve this problem? OR which option best to used. Our database is in Buffer mode, our java code has set begin work and commit for all process.
Thank You
------------------------------
MOHD FADZIL JUSOH
------------------------------
Original Message:
Sent: Tue March 07, 2023 02:06 AM
From: Henri Cujass
Subject: Table Lock
High Mohd,
I would also try it with "dirty read" and then measure the runtime of the individual calls. Maybe it is because of access from another process and the "lock mode wait 10" is not enough. in case of need, you could switch on the "trace on" for the procedure. So a little research work - but it should work in any case finally as you describe it.
Good Luck,
Henri
------------------------------
Henri Cujass
leolo IT, CTO
Germany
IBM Champion 2021 2022 2023
IIUG Board Member
Original Message:
Sent: Mon March 06, 2023 09:15 AM
From: MOHD FADZIL JUSOH
Subject: Table Lock
Hi,
We have 4 servers that run the same services to call stored procedures to validate and insert data to tables, these services run every 10 second by cron. Sometimes we get this error "Could not position within a file via an index", believe it happen because table lock, same process tries to update same table. Our table mode already set row locks and our store procedures for updating table have set lock wait 10, what else we can do to fix this issue. The current version IDS 14.10FC8 runs on VMware Server Red hat Linux 8.
Please advice
Thank You
------------------------------
MOHD FADZIL JUSOH
------------------------------