The syntax for this command is as follows:

SETTRIGGER
SETTRIGGER -
SETTRIGGER N

Use this command to determine the ‘trigger’ for a staged database reorganization. The ‘trigger’ is the maximum number of changed structures that can be included in a single database reorganization. If the generate process determines that the number of changed structures for the next database reorganization exceeds the ‘trigger’, it prepares for a staged database reorganization.

A staged database reorganization is a database reorganization that is broken up into multiple database reorganizations. DMSII limits the number of changed structures to be included in a single database reorganization. AB Suite applications are such that it is possible for the number of changed structures in a single database reorganization to exceed the DMSII limit. When this occurs, it is necessary to be able to do the database reorganization in stages. The value specified by the SETTRIGGER command determines the maximum number changed structures for each stage as well as being the trigger for a staged database reorganization.

Use SETTRIGGER to see what the current setting is.

Use SETTRIGGER with the – argument to reset the ‘trigger’ value to the default. By default, the value is 290. This is the recommended setting for Production.

Use SETTRIGGER with the N argument to specify the value for the ‘trigger’. For example, the ‘trigger’ value might be decreased to 10 for testing purposes.

The generate process keeps associated structure changes in the same stage. If the changes to a dataset and its associated sets or subsets result in more changed structures than allowed by the SETTRIGGER value, the generate process increases the ‘trigger’ value to accommodate this. For example, the SETTRIGGER value might be 5, but there is a change to data set that affects its other 10 sets and subsets, the generate process increases the ‘trigger’ value to 11.

The generate process might also increase the ‘trigger’ value to prevent the number of stages in the database reorganization from exceeding 40.