PI64347: RC00E4000E in DSNUGACC OFFSET1450 followed by DB2 CRASH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CHECK DATA utility was executed on a compressed table space,
  The exception table was missing an index for the primary key.
  Once the necessary number of inserts were made to the exception
  table to cause a compression dictionary to be built, the
  following abends occurred:
  
  ssid,ABND=04E-00E4000E,U=xxxxxxx ,M=C
  ,C=111.ASMC-DSNVEUS3,M=DSNVEUS3,LOC=DSNUTILA.DSNUGACC+1450
  
  
  ssid,ABND=0C4-00000038,U=xxxxxxx ,M=C
  ,C=111.UTIL-DSNUZLCR,M=DSNTFRCV,LOC=DSNUTILA.DSNUZLCR+1C68"
  
  followed by DB2 termination with RC00F30420
  
  RC00E4000E DSNUGACC OFFSET1450
  ABEND0C4 RC00000038 DSNUZLCR OFFSET1C68
  
  Additional symptoms: This is a forward fit of PI15560
                       ABEND04E 00C9021C RC00C9021C DSNIRFNX
                       00E20028 00E50013 00E20005 00E50702
                       RC00E20028 RC00E50013 RC00E20005 RC00E50702
  

Local fix

• Properly define the exception table with necessary indexes
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS utility users of CHECK   *
  *                 DATA using an EXCEPTION TABLE defined with   *
  *                 COMPRESS YES                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: CHECK DATA with a compressed EXCEPTION  *
  *                      TABLE results in ABEND04E RC00E4000E    *
  *                      from DSNUGACC OFFSET1450 followed by an *
  *                      ABENDS0C4 RC38 at DSNUZLCR OFFSET1C68   *
  *                      and then DB2 abnormally terminating     *
  *                      with ABEND04F RC00F30420.               *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  CHECK DATA was run with a COMPRESS YES EXCEPTION TABLE with a
  primary key.  However, there was no index defined for the
  primary key so the definition was incomplete.
  
  Since the exception table was compressed, compression on insert
  logic was triggered to create a dictionary when a sufficient
  amount of rows were inserted into it by CHECK DATA.  Because no
  index existed for the primary key, message MSGDSNT501I RESOURCE
  UNAVAILABLE - REASON 00C9009F was issued followed by an ABEND04E
  RC00E4000E from DSNUGACC +x'1450'.
  
  However, the recovery routine set up by the dictionary process
  was not created correctly which cause both invalid and
  unallocated storage to be accessed, first by that routine and
  then by successive recovery routines.  This resulted in an
  ABEND0C4 RC00000038 at DSNUZLCR +x'1C68' and eventually DB2
  abnormally terminated with ABEND04F RC00F30420.
  
  
  Note: some additional abends that could possibly be seen
  following the ABEND04E RC00E4000E either on the console or in
  SYS1.LOGREC are:
  
  ABEND0C4 RC10 in DSNWDMPS
  ABEND04E RC00E20005 in DSNSVBK
  ABEND04E RC00E3000A IN DSNTFRCV
  
  
  Additional Keywords: DSNT501I RC00C9009F
  

Problem conclusion

• Dictionary processing code for compression on insert has been
  changed to create its recovery routine correctly.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI40407

Modules/Macros

• DSNUZLCR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI40407

     UP16/09/13 P F609 Ž

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.