I have a COBOL program that inserts rows to a table. My program does not have a COMMIT statement in it. The program is restartable using QUICKSTART. I noticed that when the program abends, it does not rollback all the way to the beginning of the program. I can see the records in the table that it was inserting in to. Does it have to do anything with QUICKSTART?
One more question. Do I need to take a checkpoint after each INSERT to the table?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
I'm not familiar with Quickstart but it may have an option that causes a checkpoint after each iteration. Check your settings and defaults for parameters not set.
The only time you want to checkpoint after each insert is when you want NO data to be backed out. This is usually not desired. Checkpoints are best used at the end of a logical-unit-of-work(LUW) or when the program ends. Part of the decision of when to checkpoint is how you want any restart capability to work.