What is an intent lock?

Answer Posted / s

Intent lock is a lock taken at the tablespace or table
level and indicates the type of locks are held at the lower
levels, page or row.

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2757


Define buffer pool.

628


Who uses db2?

576


How many databases are there?

592


what is utility for parm lib

1882






Is ibm db2 open source?

586


Outputs of explain are with matchcols = 0. What does this signify?

619


What is the max length of sqlca?

767


What is the maximum size of a char data type in db2?

588


What is dbrm?

645


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

650


What is cobol db2?

570


What is sqlca?

624


What is load replace in db2?

560


What is a trigger in the db2 database?

596