How to check the Lock level in database ?

[lcklee]

Can someone tell me how to check the DB2 lock level or isolation level ??

Now, my application on DB2 encounter lock time out error. The application developer said the DB2's isolation level is "Cursor Stability", how can I check that setting in database, moreover, how can I know the locking is on row or table ??

Pls help.

 

[MarcLodge]

The error message returned at the time of the lock should tell you what table is being locked. If you look in the DB2 log, you should be able to see messages telling you who was holding the lock.
hth
Marc

 

[lcklee]

Thx for your reply.

I m beginner on the DB2, can you tell me where is the DB2 log ? I m using AIX with DB2.

Moreover, my database only have one user since my application is java base and it connect to database by that user account. So who lock the account is not important.

However, what I put the eyes on is how the lock time out occur, since the application developer claim that the DB2 lock level is on row. To me, if the lock is base on row and the application just insert new record into the table, how come the table is lock, my new record is a new row, why it have lock time out ? Is there anything I can check the lock level is row or table ??

Moveover, can someone tell me what is the use of BIND command ??

Thx a lot.

 

[gregsimpson]

The following may point in you the right direction as regards some of your questions.

http://www.cs.yorku.ca/~jarek/courses/3421/db2notes/embed-c.html

http://members.aol.com/cronid/db2.htm

http://216.239.51.100/search?q=cach...5nt/SQLJ6E03.PS+db2+db2log+aix&hl=en&ie=UTF-8

Cheers
Greg