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
- 19020 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
Explain correlated sub-queries.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the difference between plan and package in db2?
What does reorg do in db2?
What db2 400?
What are the two types of logging in the db2 database? Explain them.
What is sqlca?
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?
Is it possible using max on a char column?
What's The Percentage Free Space ?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What does db2 blu stand for?
What is db2 bind process?
How is a typical db2 batch pgm executed?
What is ibm db2 client?
