Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 18994 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / guest
ACQUIRE, RELEASE determines when a partition, table or
tablespace lock will be acquired and released. ISOLATION
determines when a row, page lock will be acquired and
released. PAGE, ROW locks are released depending on the
ISOLATION level but almost always at commit or rollback.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is cursor in dbms?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the syntax for creating a table in the db2 database?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How would the varchar column remarks defined?
How can you do the explain of a dynamic sql statement?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to restart a DB2 program?
How does coalesce work?
What is the advantage in De-normalizing tables in DB2?
What is coalesce in db2?
Explain in brief how does db2 determine what lock-size to use?
How to find the maximum value in a column in the db2 database?
Explain dclgen.
