View previous topic :: View next topic
|
Author |
Message |
tarunflash
New User
Joined: 15 Oct 2005 Posts: 25
|
|
|
|
can u explain about acquire and release parameters in binding?
Title changed from "db2" to "explain about acquire and release parameters in binding" : Priyesh. |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
hey tarun,
Acquire and release parameters will tell you when the locks needs to be taken and release.
If you mention ACQUIRE(ALLOCATE) and RELEASE(DEALLOCATE) in bind step, that means locks will be taken on the tables (used in the program) when the thread started and locks will be released when the thread ended.
ACQUIRE has another value USE. It will allow to take locks when actually needed.
RELEASE has another option COMMIT. It will ensure to release locks when a commit occured even though thread is active.
Hope you got me,
Thanks
Rags |
|
Back to top |
|
|
pnambiar
New User
Joined: 24 Feb 2006 Posts: 3
|
|
|
|
ACQUIRE and RELEASE are tablespace locking stratgey at the PLAN level. |
|
Back to top |
|
|
|