PROD_EDIT

Read syntax diagramSkip visual syntax diagram
   .-PROD_EDIT=N-.   
>>-+-PROD_EDIT=Y-+---------------------------------------------><

PROD_EDIT
Specifies whether various restrictions should apply to any ZDT/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 ZDT/Db2 editor session. If EDITOR_TIMEOUT=0 is also specified in the same HFM2SSDM 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 HFM2SSDM 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 HFM2SSDM macro invocation it is replaced with TABLE_LOCKING=NO.
  • The editor option "Commit after data fetch" is fixed and is selected for all ZDT/Db2 users.
  • The editor option "Commit when save issued" is fixed and is selected for all ZDT/Db2 users.
  • The editor option "Commit when no save errors" option is fixed and is not selected for all ZDT/Db2 users.

The PROD_EDIT behavior applies to the locally connected Db2 system.

For example, Suppose the HFM2POPT has these entries:

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

An ZDT/Db2 user connected locally to DSNA is not subject to the PROD_EDIT behavior. If the ZDT/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 ZDT/Db2 user connected locally to DSNB is subject to the PROD_EDIT behavior. If the ZDT/Db2 user specifies a location value to access a Db2 object at DSNA, the resulting editor session IS subject to the PROD_EDIT behavior.