
DB2 & VB Row Level Locking
We are using DB2 Universal Database Ver 5 for NT and Visual Basic Ver 5 to
develop a client-server application. We use BeginTrans before Insert or
Update, and use CommitTrans to commit the database changes.
Between BeginTrans and CommitTrans, the data table is
locked. DB2 has row level locking. Other concurrent users or processes can
not access the same
table.
What are we doing wrong????
Any suggestion will be highly appreciated.