COMMIT INTERVAL for Execution and Analysis Processing

Document ID : KB000011008
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Updating an application domain to add 10000 tables. The user domain has only one user.

When the job is executed to grant the user access to each table, will there be a commit after each grant or is the commit at the end of the job?

Answer:

In the product Profile there is a parameter that can be set to control this:

Field: SRS A/E COMMIT INTERVAL 

Description: Specify how many SQL statements will be executed in the Analysis/Exec program before issuing a COMMIT - 

XXXXX The commit interval can be any number of characters up to five places. 

NONE (Default) No commit interval established.

Additional Information:

RC/Secure User Guide - Set Profile Variables

r18

 

r19