Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 19008 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 are simple, segmented and partitioned table spaces ?
What is the purpose of rollback and commit?
What is drop table?
What is db2 stogroup?
What is a DB2 plan?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
what is consistency token
Is DECLARE TABLE in DCLGEN necessary? Why it used?
what are bind concepts in db2 cobol?
COBOL 
