They are the 3 types of locks 1.Mode:share,exclusive,update intent 2.Siz

What are the various locks available?

Question Posted / nag(igate)

Answer Posted / nag(igate)

They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Mention the various locks that are available in db2.

1051

What is the use of runstats in db2?

1121

What is the role of the data page in the db2 database?

1037

How to execute stored procedures?

1140

Is db2 a programming language?

1059

When do you specify the isolation level?

1043

List out the buffer pools in db2

1081

What is iseries database?

1060

List some fields from sqlca?

1066

How to create backup table in db2?

1098

What is the latest version of ibm db2?

1278

How can the duplicate values be eliminated from db2 select?

1112

What is scrollable cursor in db2?

1062

What are the prerogatives?

1091

What is the maximum length of sqlca?

1540