PH14791: ABEND04E RC00C90101 IN DSNKFTCH ERQUAL1006 FOR DELETE WITH ATTRIBUTE UR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• abend04e RC00c90101 in DSNKFTCH erqual1006 for DELETE with
  attribute UR. SQLCODE will be issued instead.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of PREPARE SQL                     *
  * request with the ATTRIBUTES option                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABENDS04E RC00C90101 in DSNKFTCH                             *
  * ERQUAL1006 occurred during a DELETE                          *
  * statement with attribute of WITH UR.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An application prepares a DELETE statement with the attribute
  of WITH UR. Later during execution, the DELETE statement failed
  with ABEND04E RC00C90101 in DSNKFTCH:1006.
  
  UPDATE, DELETE, and INSERT statements are not allowed to use
  WITH UR in the isolation-clause. Db2 code already disallowed
  the INSERT, UPDATE or DELETE statement when the
  isolation-clause WITH UR is specified as part of the statement.
  However, Db2 code inadvertently allows INSERT, UPDATE or DELETE
  statements to be prepared with the WITH UR attribute when there
  is no isolation-level specified in the sql statement directly.
  

Problem conclusion

• Db2 code is modified to disallow INSERT, UPDATE or DELETE
  statements to be prepared with the isolation-clause attribute
  WITH UR.
  Db2 will issue SQLCODE -199 if an UPDATE WHERE CURRENT OF
  cursor-name, DELETE WHERE CURRENT OF cursor-name or INSERT
  without SELECT is prepared with the attribute of WITH UR.
  
  Db2 will issue SQLCODE -104 if an UPDATE, DELETE or INSERT with
  SELECT is prepared with the attribute of WITH UR.
  The new DB2 subsystem parameter ALLOW_UPD_DEL_INS_WITH_UR is
  added that can be used to specify whether DB2 should allow
  INSERT, UPDATE or DELETE statements to be prepared with the
  isolation-clause attribute of WITH UR. Such usage is illegal
  SQL syntax. Valid settings for ALLOW_UPD_DEL_INS_WITH_UR are:
  - YES: Allows usage of this illegal SQL syntax. During full
         PREPARE of such statement, DB2 will write an
         incompatibility trace record, IFCID 376 with a new
         function code 0013 in QW0376FN. Note that the execution
         of such statement may incur an abend including the
         reported symptom.
  - NO:  Disallow usage of this illegal SQL syntax. Statements
         that include it will fail with SQLCODE -109 or -104.
         This is the default setting.
  For DSNWMSGS changes that are related to this APAR, see APAR
  PH26776.
  ADDITIONAL KEYWORDS: SQLCODE199 SQLCODE104
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI71596

Modules/Macros

• DSNTINMF DSNDQW05 DSNDQWPZ DSNWZIFC DSNTIDXA DSNTIVMD DSNTIJUZ
  DSNTINST DSNTIDXC DSNTIWIA DSNTIDXB DSNTIVIA DSNTIWMD DSNTIWIE
  DSNTIVIE DSNTIPM4 DSN@XAZP DSN6SPRM DSNTXAZP DSNXEDP  DSNTIWPC
  DSNDSPRM DSNXEDS1 DSNTIVMN DSNTIWMN DSNTIVAF DSNTIVIN DSNTIWMS
  DSNTIVMS DSNTIWAF DSNTIWIN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI71596

     UP20/09/23 P F009

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.