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 / g
ACQUIRE, RELEASE parameters refer to when the resources for
the application program will be acquired and released. This
includes when datasets will be allocated/deallocated, when
storage will be allocated/deallocated for DBDs,
plans/packages in EDM pool.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are db2 objects?
How to find primary key of a table in db2?
What is db2 command?
Why do chiropractors use drop table?
What is the use of value function?
What is the use of db2 optimizer?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the usage of open cursor command?
Why select is not preferred in embedded sql programs?
What is null value in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Define buffer pool.
How to get the ddl of a table in db2?
Is db2 a mainframe?
Are view updateable?