Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
View previous topic :: :: View next topic  
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

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: 34
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts ISPF Tables Creation newsysprg TSO/ISPF 6 Wed Jul 13, 2016 2:21 pm
No new posts ADS 3270 Batch simulator for IDMS rel... gpowell382 IDMS/ADSO 1 Thu May 05, 2016 8:02 pm
No new posts New DB2 tables creation kishpra DB2 3 Tue Feb 02, 2016 7:00 pm
No new posts Commit limit for Delete query through... mf_karthik DB2 10 Thu Dec 17, 2015 12:56 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us