PH31461: DB2 ABENDS S0C4 RC38 IN DSNUGDAL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A distributed thread calling stored procedure was canceled,
  stored procedure did a mass delete and cancel happened in commit
  phase 1 when it was inserting a SYSCOPY record to remember mass
  delete.
  In this case we did not reset a pointer correctly, during
  deallocation db2 got abends S0C4 RC38 and abnormally shutdown.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 for z/OS and Db2 12 for z/OS                      *
  * users of SQL DELETE without a WHERE clause                   *
  * on a table in a segmented table space or                     *
  * UTS.                                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Soft cancel of a SQL DELETE without                          *
  * a WHERE clause                                               *
  * - on a table in a segmented table                            *
  *   space or UTS                                               *
  * - in commit phase 1 processing                               *
  * running under a stored procedure                             *
  * receives ABEND0C4 RC38 in DSNUGDAL                           *
  * OFFSET0250 causing Db2 to crash.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  A SQL DELETE without a WHERE clause (mass delete) on a table
  in a segmented table space or UTS was executing under a stored
  procedure. A soft cancel was done (ABEND04E RC00E50013) during
  commit phase 1 processing. An ABENDS0C4 RC38 in DSNUGDAL
  +x'0250' then occurred which caused Db2 to crash.
  The ABEND0C4 occurred after the soft cancel in commit phase 1
  processing because the recovery routine did not clear
  transient information for the thread.
  This problem could also occur if TRUNCATE TABLE, DROP TABLE,
  ALTER TABLE ROTATE PARTITION on a table in a segmented table
  space or UTS is soft cancelled in commit phase 1 processing.
  

Problem conclusion

• Db2 code has been modified to correctly handle soft cancels
  for the scenarios above.
  

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:

  UI73870 UI73871

Modules/Macros

• DSNUADP1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI73870

     UP21/02/17 P F102 ¢

• RC10 PSY UI73871

     UP21/02/17 P F102 ¢

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.