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
- 19261 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 |
What is the use of with ur in db2?
Name the various locking levels available?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
Where is the access path logic created by the DB2 Optimizer stored?
What is EXPLAIN?
what is difference between random and sequence file access
How many buffer pools are there in DB2?
Mention some fields that are a part of sqlca.
How do you run JCL in cobol program
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
COBOL 
