PI69879: DUE TO OBD STORAGE BEING CORRUPTED, THERE CAN BE UNPREDICTABLE RESULTS INCLUDING STORAGE OVERLAYS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Due to OBD storage corruption, 8 bytes of storage can
  be overlaid that results DB2 in issuing unpredictable abends.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 12 fo z/OS users of CLONE tables                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In DB2 12 for z/OS , due to OBD storage being corrupted,     *
  * there can be unpredictable results including storage         *
  * overlays.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 12 for z/OS, the OBD might be corrupted due to CLONE
  table processing, hence, DB2 might abend unpredictably depending
  on where the storage is overlaid.
  
  Below are the possible known symptoms:
  
  1. ABEND0C4 RC00000038 AT DSNB1GD1 OFFSET 00A58
  2. ABEND04E RC00C90101 AT DSNTDMST ERQUAL5002
  3. REPAIR DBD reports error on OBDFS_STR_SEC
  4. ABEND0C4 RC00C90101 AT DSNGDCPD ERQUAL5022
  5. ABEND0C4 RC00000038 AT DSNTDMI OFFSET 02C6E
  ADDITIONAL SYMPTOMS:
  ABEND0C4 DSNB1DBP +03B2C
  ABEND0C4 DSNB1PCK +03FE0
  ABEND0C4 DSNB1DRN +00982
  ABEND0C4 DSNB1PCP +00D08
  

Problem conclusion

• DB2 code has been fixed so that the internal control block is
  set correctly.
  However, this APAR will not fix any existing corrupted object's
  OBD. If any of the abends occur,
  user can run REPAIR DBD DIAGNOSE to see if any errors and
  REBUILD if necessary.
  
  ADDITIONAL KEYWORDS:
  SQLALTER
  SQLCLONE
  SQLINDEXONEXP
  SQLPROCEDURE
  DB2OVRLAY/K
  ABEND0C4
  ABEND04E
  

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:

  UI42152

Modules/Macros

• DSNGEPUF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI42152

     UP16/11/15 P F611

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.