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 / neeti
Isolation level parameters are used on page level while the
ACQUIRE and RELEASE parameters work on tablespace levels
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What does db2 plan contain?
What is a db2 table?
B37 abend during spufi?
What is a trigger in the db2 database?
Is the primary key a clustered index?
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?
Explain db2.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is nvl in db2?
What are packages in db2?
What are foreign keys in db2?
How do I start db2 in windows?
What is schema in db2?
What is netezza database?
How to access db2 tables in mainframe?