Continue my updatings after using COMMIT

indira · New User Joined: 26 Jul 2005 Posts: 3

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

shivashunmugam Muthu · Posted: Fri Jul 29, 2005 11:20 am

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.

Pjoe · New User Joined: 22 Jul 2005 Posts: 17

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

saeed435 · New User Joined: 26 Sep 2007 Posts: 4 Location: hyderabad

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

enrico-sorichetti · Posted: Wed Sep 26, 2007 1:31 pm

saeed435 · New User Joined: 26 Sep 2007 Posts: 4 Location: hyderabad

thank u for ur sugesstion. i will check the resouces part