Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sabahat khan
The ACQUIRE and RELEASE options of bind determine when DB2
locks an object (table, partition, or table space)which
your application uses and when it releases the lock.
The options apply to static SQL statements(like Embedded
SQL statement in application program), which are bound
before your program executes. If your program executes
dynamic SQL statements, the objects they lock are locked
when first accessed and released at the next commit point
though some locks acquired for dynamic SQL might be held
past commit points.
ACQUIRE(ALLOCATE)
Acquires the lock when the object is allocated. This option
is not allowed for BIND or REBIND PACKAGE.
ACQUIRE(USE)
Acquires the lock when the object is first accessed.
RELEASE(DEALLOCATE)
Releases the lock when the object is deallocated (the
application ends). The value has no effect on dynamic SQL
statements, which always use RELEASE(COMMIT)
RELEASE(COMMIT)
Releases the lock at the next commit point, unless cursors.
If the application accesses the object again, it must
acquire the lock again.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What are the prerogatives?
Are view updateable?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is a buffer in memory?
What is host variable in db2 cobol?
What is the use of predicate?
Which components manage deadlocks in db2?
What is dbrm library?
What is bind in db2?
What is the use of value function?
What is db2 plan table?
What is the advantage in De-normalizing tables in DB2?
How to check last update on table in db2?
What is deadlock in db2?
