View previous topic :: View next topic
|
Author |
Message |
dsbhati
New User
Joined: 13 Jun 2005 Posts: 10 Location: india
|
|
|
|
Hi all,
Is commit release the resources(tables) in DB2.
Thanks & Regards,
Darshan. |
|
Back to top |
|
|
Smitha
New User
Joined: 20 Jun 2005 Posts: 5
|
|
|
|
Yes, it releases the locks on the database till the next SQL call of the tables. |
|
Back to top |
|
|
brganeshbabu
New User
Joined: 23 Jun 2005 Posts: 34 Location: Chennai
|
|
|
|
When you execute a COMMIT statement, it will close the cursor, free up all the resources that query has held up. |
|
Back to top |
|
|
|