PROD_EDIT


1! PROD_EDIT=N
1 PROD_EDIT=Y
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.