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 / 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


Please Help Members By Posting Answers For Below Questions

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2093


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

916


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1857


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?

2293


What is dbrm in db2 database?

790


What is a page in db2?

800


What is universal database?

838


What is the syntax for seeing the columns and data types of a table in the db2 database?

818


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

846


What is the max length of sqlca?

967


How to view db2 table structure?

800


Discuss about db2 bind?

871


What is the use of db2?

801


Can you tell me how can you find out the # of rows updated after an update statement?

870


What does db2 stand for?

774