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
Explain about rct in db2?
What is difference between isnull and coalesce?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Define db2 and its databases?
Can you tell me how can you find out the # of rows updated after an update statement?
Define db2.
What is copy pending status in db2?
What are the 2 sqlcodes that are returned?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Which command is used to remove all rows from a table?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is plan in cobol db2?
Mention the location where the output received from explain statement is stored.
What is the meaning concurrency in the db2 database?
What is the maximum length of sqlca?