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
- 18988 Views
- Syntel, I also Faced
- E-Mail Answers
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 happens in bind step in a db2 program?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the maximum number of columns in a db2 table?
Can we delete records from view?
How to test SQL -911 error while developing COB-DB2 program
What is dclgen (declaration generator)?
What is check constraint in db2?
How many databases can be created inside an instance in db2 ?
What is db2 and what is the use of db2 optimizer?
How to execute stored procedures?
Explain in brief how does db2 determine what lock-size to use?
Mention the downsides of page level lock.
What is db2 purescale?
What is a db2 table?
