PROD_EDIT

PROD_EDIT

Specifies whether various restrictions should apply to any FM/Db2 editor sessions. These restrictions are intended to reduce the potential for locking and resource contention when accessing Db2® data. Collectively these restrictions are referred to as the PROD_EDIT (Production Edit) behavior.

Specify PROD_EDIT=N to disable the PROD_EDIT restrictions. This is the default.

Specify PROD_EDIT=Y to enable the PROD_EDIT restrictions. Specifying PROD_EDIT=Y has multiple effects, as described below:

An inactivity time-out applies to every FM/Db2 editor session. If EDITOR_TIMEOUT=0 is also specified in the same FMN2SSDM macro invocation it is replaced with EDITOR_TIMEOUT=60. You can specify any value for EDIT_TIMEOUT except 0, and that value will not be over-ridden.
Large editor mode is disabled for all users. If EDIT_MAX_ROWS=0 is also specified in the same FMN2SSDM macro invocation it is replaced with EDIT_MAX_ROWS=1000. You can specify any value for EDIT_MAX_ROWS except 0, and that value will not be over-ridden.
Table locking is disabled for all users. If TABLE_LOCKING=YES is also specified in the same FMN2SSDM macro invocation it is replaced with TABLE_LOCKING=NO.
The editor option Commit after data fetch is fixed and is selected for all FM/Db2 users.
The editor option Commit when save issued is fixed and is selected for all FM/Db2 users.
The editor option Commit when no save errors option is fixed and is not selected for all FM/Db2 users.

The PROD_EDIT behavior applies to the locally connected Db2® system.

For example, Suppose the FMN2POPT has these entries:


FMN2SSDM    SSID=DSNA,
            PROD_EDIT=N
FMN2SSDM    SSID=DSNB,
            PROD_EDIT=Y

An FM/Db2 user connected locally to DSNA is not subject to the PROD_EDIT behavior. If the FM/Db2 user specifies a location value to access a Db2® object at DSNB, the resulting editor session is not subject to the PROD_EDIT behavior.

An FM/Db2 user connected locally to DSNB is subject to the PROD_EDIT behavior. If the FM/Db2 user specifies a location value to access a Db2® object at DSNA, the resulting editor session IS subject to the PROD_EDIT behavior.

Note:

When enabled, this option minimizes conflicts with concurrent tasks by limiting the number and duration of locks held on resources. The option does not affect the connection or its associated Db2 thread. The connection and Db2 thread remain active until the session terminates, either by exiting FM/Db2 or by switching to another Db2 subsystem.