In BIND, isolation level parameter specifies the duration
of page lock and ACQUIRE, RELEASE also do almost the same
thing. What is the exact difference between the two? Do
they work in conjunction while executing SQL queries and
obtaining locks?
Answer Posted / priya
When a tablespace is locked, another task cannot have
access to the entire table itself. So here, does page level
locking matter and what difference remains between
ISOLATION and ACQUIRE/RELEASE?
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the use of db2?
What language is db2 written in?
How to take backup of table in db2?
List out the buffer pools in db2
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Is ibm db2 free?
What are concurrency issues?
What is ibm db2 connect?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I connect my db2 database to ibm?
What is null value in db2?
Define predicate?
How to execute stored procedures?
List out the three types of page locks that can be held.
What is rebind in db2?