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
 

 

Continue my updatings after using COMMIT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
indira

New User


Joined: 26 Jul 2005
Posts: 3

PostPosted: Thu Jul 28, 2005 7:21 pm    Post subject: Continue my updatings after using COMMIT
Reply with quote

Hi everyone,

By batch i will update hundreds of thousands records.

At the beginnig, i BIND to all REFCORD i need and do READY on all corresponding AREA .

After several updatings, i do a COMMIT statement.

Can I
1/ Continue my updatings
or
2/ redo all BIND and READY before my updatings

Thank you for your help
Back to top
View user's profile Send private message

shivashunmugam Muthu

Active User


Joined: 22 Jul 2005
Posts: 114
Location: Chennai

PostPosted: Fri Jul 29, 2005 11:20 am    Post subject: Re: use COMMIT
Reply with quote

You can continue.

You have to do COMMIT for every 50 records. This is the standard practise while writing update logic.

If there is any abend, atleast u can save the time of starting from scratch. Also pls incorporate Restart Logic too.
Back to top
View user's profile Send private message
Pjoe

New User


Joined: 22 Jul 2005
Posts: 17

PostPosted: Wed Aug 03, 2005 11:59 am    Post subject: Re: use COMMIT
Reply with quote

Hi,
Can I
1/ Continue my updatings

Ans:-
Yes you can countinue updating
or
2/ redo all BIND and READY before my updatings
Ans:-No need to re bind,
The COMMIT statement writes a checkpoint to the journal file . COMMIT simulates a FINISH-BIND-READY sequence without relinquishing control of database resources.

-PJ
Back to top
View user's profile Send private message
saeed435

New User


Joined: 26 Sep 2007
Posts: 4
Location: hyderabad

PostPosted: Wed Sep 26, 2007 1:19 pm    Post subject: reduce the run time of idms batch programme
Reply with quote

hi every body ,
one application idms program currently is taking a long time to run and the frequency of this being run is very high. i want to reduce the run time of programme . so i want some suggestions regarding this matter or problem .

thanks
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Wed Sep 26, 2007 1:31 pm    Post subject: Reply to: Continue my updatings after using COMMIT
Reply with quote

Quote:
one application idms program currently is taking a long time to run and the frequency of this being run is very high. i want to reduce the run time of programme . so i want some suggestions regarding this matter or problem .


What makes You think that there is a performance issue ???
a heavy usage of resources might simply mean that there is a lot of work to do

regards

e.s
Back to top
View user's profile Send private message
saeed435

New User


Joined: 26 Sep 2007
Posts: 4
Location: hyderabad

PostPosted: Wed Sep 26, 2007 2:51 pm    Post subject: reduce the run time of idms batch programme
Reply with quote

thank u for ur sugesstion. i will check the resouces part
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 -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Job to wait and continue based on reply yugendran COBOL Programming 5 Wed Oct 05, 2016 1:46 pm
No new posts Not enough virtual memory is availabl... Vinay Pushpala IBM Tools 16 Tue Sep 13, 2016 4:37 pm
No new posts Commit limit for Delete query through... mf_karthik DB2 10 Thu Dec 17, 2015 12:56 am
No new posts Commit a DB2 Table on Unix Server and... Vinodh S DB2 3 Sun Apr 12, 2015 5:05 am
No new posts Need information on DB2 COMMIT sivasaras COBOL Programming 9 Wed Jun 11, 2014 7:34 pm


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