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
- 19256 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 db2? Explain.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How to view db2 table structure?
Explain packages.
What is db2 look?
Can one database have multiple instances?
How do you pull up a query which was previously saved in qmf?
Explain about open switch business continuity software?
What is the maximum size of a char data type in db2?
When reorg is used?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is db2 command?
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?
Can there be more than one cursor open for any program?
What are the benefits of using the db2 database?
