Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Is commit release the resources(tables) in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
dsbhati

New User


Joined: 13 Jun 2005
Posts: 10
Location: india
PostPosted: Mon Jun 27, 2005 12:00 pm    Post subject: Is commit release the resources(tables) in DB2
 Reply with quote
Hi all,

Is commit release the resources(tables) in DB2.

Thanks & Regards,
Darshan.
Back to top
View user's profile Send private message
References
Smitha

New User


Joined: 20 Jun 2005
Posts: 5
PostPosted: Mon Jun 27, 2005 1:47 pm    Post subject: Re: REGARDING COMMIT
 Reply with quote
Yes, it releases the locks on the database till the next SQL call of the tables.
Back to top
View user's profile Send private message
brganeshbabu

New User


Joined: 23 Jun 2005
Posts: 18
Location: Chennai
PostPosted: Tue Jun 28, 2005 12:27 pm    Post subject: DB2 COMMIT
 Reply with quote
When you execute a COMMIT statement, it will close the cursor, free up all the resources that query has held up.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1