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 Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Release quantity that was allocated v... Auryn JCL & VSAM 5 Thu May 18, 2017 6:02 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm


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