+EDPROCSUP

The +EDPROCSUP parameter specifies whether to call Editprocs in supervisor state. Normally, this is not required and performance is enhanced if the value is NO. However, some Editprocs require running in Supervisor State, so you must set the parameter to YES. You can also use this parameter to skip all Editproc routine processing. You should do this only if the Editprocs do not change the Db2 data in any way, or data could be damaged.
EDPROCSUP.png

Related topic

Global-parameters-UTLPARMS

The values are defined as follows:

YES

Call Editprocs in supervisor state

NO

(default) Call Editprocs in program state. This uses significantly less CPU time.

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

  • 13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*