+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.
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. |
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*