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 db2 400?
Explain the function done by data manager?
What is sqlca’s maximum length?
How do you eliminate duplicate values in db2?
Are view updateable?
i want to maintain uniqueness on pdf without make lf??????????
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is query_cache_limit?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is rebind in db2?
How do I connect my db2 database to ibm?
What is db2 connect?
what is a corelated subquerry?
List out the data types available.