What are the three types of page locks that can be held?

Answer Posted / s

I think you mean the three types of LOCK MODES.
S Share
U Update
E Exclusive

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1651


Is it possible using max on a char column?

609


Define db2 and its databases?

620


How can you classify the locks in db2?

636


can all users have the privilage to use the sql statement select * (dml)?

642






Which command is used to remove all rows from a table?

553


what are bind concepts in db2 cobol?

651


Can we delete records from view?

566


List down the data types in the db2 database.

633


what is db2 restart?

1693


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10774


How do you find the maximum value in a column in db2?

650


What is page size in db2?

563


What kind of database is db2?

572


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

714