1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / shefali799

Answers were Sorted based on User's Feedback



In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

Answer / gopi

(1) Isolation specifies type of lock that should be used
(2) Acquire tells when the lock should be acquired
(3) Release tells when it should be unlocked

Is This Answer Correct ?    8 Yes 1 No

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

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

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

Answer / p praveen kumar

1) Isolation specifies types of locks to be used by
Repeatable Reads(Table space locks), Reads
Stability(page level locks), Cursor Stability(Row level Locks)
Uncommitted locks(no Locks)

2) Acquire tells when the lock should be acquired(USE,ALLOCATE)

3) Release tells when it should be unlocked(COMMIT, DEAL LOCATE)

Is This Answer Correct ?    4 Yes 1 No

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

Answer / guest

ACQUIRE, RELEASE determines when a partition, table or
tablespace lock will be acquired and released. ISOLATION
determines when a row, page lock will be acquired and
released. PAGE, ROW locks are released depending on the
ISOLATION level but almost always at commit or rollback.

Is This Answer Correct ?    3 Yes 1 No

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

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

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

Answer / rrgust

In ACQUIRE there are two options are available 1) Use
2)Allocate. When the bind card contains ACQUIRE(USE) when
there there is first hit to the table, lock willbe held. If
you use the second option, during the executin the lock
will be held.

Reg: RELEASE, it will take RELEASE(COMMIT). Once commit is
perfomed, the lock will be released..

Is This Answer Correct ?    3 Yes 3 No

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

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

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also d..

Answer / madhu

1) Acquire and Release are effective when lock rule of tablespace is either table lock or tablespace lock. In this case, bind level isolation has no effect.

2) Isolation Level is effective when lock rule of tablespace is either page lock or row lock. In this case, Acquire and Release has no effect.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

What is lock contention?

1 Answers  

What do you need to do before you do EXPLAIN ?

1 Answers  




which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

How many types of page locks can be held in db2?

0 Answers  

How do I add a column to a table in db2?

0 Answers  

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

What is a trigger in the db2 database?

0 Answers  

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

For more DB2 Interview Questions Click Here
Categories