PROGRAM Level:

• State Record: One of the state record needs to SQL Table, Since All Derived work record will be re-initializing on commit.
• Program Properties: On the ADVANCED tab in the program properties dialog box, make sure that disable restart is not checked
• Configuration manager: In the configuration manager, sure that Disable restart is not selected on the process scheduler tab.

Section Level Section type:

• The option for section type are prepare only and critical updates
• If the section is preparing data i, e select data, POPULATING temporary TABLES, or updating temporary tables then the section should be prepare only
• If the section is updating the permanent APPLICATION tables in the database, you should select critical update.

Step Level Add an order by clauseThe only restriction for batch runs occurs when you have restart enabled, and you are inside a Do Select that is of the Select/Fetch type (instead of “Re-select” or “Restartable”). with select/Fetch, all commits inside the loop are ignored, including the commit frequency if it’s set.

Program Level:

Section Level Section type:

Step Level Add an order by clauseThe only restriction for batch runs occurs when you have restart enabled, and you are inside a Do Select that is of the Select/Fetch type (instead of “Re-select” or “Restartable”). with select/Fetch, all commits inside the loop are ignored, including the commit frequency if it’s set.