hi, we are using db2 udb v8.1 ESE with type 4 jcc driver. since DB2
can't support pessimistic locking , and our application required that,
which means when both users try to access the same record with intent
to update, the first one grab the record will create a row lock on the
current row reading, before it update, other user can't access the
same record with intent for update read, but can access with read only
type. so when the first user update the row, it will release the row
lock and let the other user with intent for update read to grab the
record. In order to do this, i think i can't use transaction and
isolation level control by the database, db2 support only optimistic
locking ,isn't it? so i think might need to use column locking (soft
lock), which means with extra column like timestamp, but the
disadvantage is when power off, some one who create the lock will
leave the flag there and when server start again, i have to clean up
all thousands tables timestamp column to start over, does anyone has
any idea how to do it efficiently? thanks