PH62292: ABEND04E RC00C90101 AT DSNIREPR ERQUAL507E DURING SQL UPDATE 24/07/15 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The ABEND 04E 00C90101 at DSNIREPR 507E happened when an SQL
  UPDATE was done on a table with row level locking. The ABEND is
  accompanied by message MSGDSNI014I for a DATA PAGE:
  
  DSNI014I -DB2A DSNIREPR DATA IN USE DURING ABEND
           REASON 00C90101
           ERQUAL 507E
           TYPE 00000302
           NAME TESTDB.TESTTS.X'01407323'
           CONNECTION-ID=DB2A
           CORRELATION-ID=db2jcc_appli
           LUW-ID=GAE148C9.O350.DF3CED8A09DB=43296
  
  The ABEND is related to changes introduced by PH58258 - which
  affected any Global Transaction's update process operating on
  objects defined with row level locking.
  
  Additional symptoms : ABEND04E 00C90101 DSNIBHUN 5016
                        ABEND04E 00C90101 DSNIBHRE 500A
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 12 & 13 for z/OS Users of            *
  *                 global transactions and objects defined      *
  *                 with LOCKSIZE ROW, who have                  *
  *                 applied PH58258 (UI96554 or UI96555).        *
  ****************************************************************
  * PROBLEM DESCRIPTION: After PH58258 (UI96554 or UI96555)      *
  *                      is applied, the following abends        *
  *                      are issued during Db2's update          *
  *                      process that belonged to the            *
  *                      global transaction group, and the       *
  *                      updated table belonged to the table     *
  *                      space defined with LOCKSIZE ROW:        *
  *                      1. ABEND04E RC00C90101 AT DSNIREPR      *
  *                      ERQUAL507E                              *
  *                      2. ABEND04E RC00C90101 AT DSNIBHUN      *
  *                      ERQUAL5016                              *
  *                      3. ABEND04E RC00C90101 AT DSNIBHRE      *
  *                      ERQUAL500A                              *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  Following the application of PH58258 (either UI96554 or
  UI96555), an update attempted to expand the record from
  the tablespace defined with LOCKSIZE ROW. Due to a
  miscommunication between the update process and the space
  allocation component, the existing page couldn't accommodate
  the updated record. Db2 subsequently terminated the process
  with ABEND04E RC00C90101 at DSNIREPR ERQUAL507E, then DSNIBHUN
  ERQUAL5016 and DSNIBHRE ERQUAL500A during subsequent recovery
  efforts, indicating persistent page-level issues.
  

Problem conclusion

• Db2 code has been adjusted to resolve the communication issue
  between the update process and the space allocation function
  for tablespaces using LOCKSIZE ROW. This is to ensure the
  page's free space can be re-used for the update operation,
  on behalf of the Global Transaction group, changing data
  from the tablespace defined with LOCKSIZE ROW.
  

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:

  UI97955 UI97956

Modules/Macros

• DSNIREPR DSNISGRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI97955

     UP24/08/13 P F408 ­

• RD10 PSY UI97956

     UP24/08/13 P F408 ­

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.