PM95270: LOAD WITH PERIODOVERRIDE CAUSING MULTIPLE ABENDS

APAR status

• Closed as program error.

Error description

• Running LOAD with PERIODOVERRIDE causing multiple abends,
  saw abend:
  ABND=0C4-00000004,LOC=DSNUTILA.DSNURMFL+0242"
  ABND=04E-00E2002F, LOC=DSNSLD4 .DSNSVSFM+0734"
  ABND=04E-00C200C6,LOC=DSNIDM  .DSNB1RWI+1E38"
  ABND=04E-00E20027,LOC=DSNUGSTA.DSNSVBK +1C02"
  ABND=04E-00C202B2,LOC=DSNIDM  .DSNB1PPP+2642"
  ABND=04E-00C202B1,LOC=DSNIDM  .DSNB1PER+038E"
  ABND=0C4-00000004,LOC=DSNUTILA.DSNURMFL+025C"
  ABND=0C4-00000004,LOC=DSNUTILA.DSNURWUF+2E70"
  ABND=0C4-00000038, LOC=DSNUTILA.DSNURWI +C0FC
  
  An overlay in the URPK control block, so when DB2 tried to
  read a counter, it read x'20202020' and do a loop from 1 to
  x'2020' causes it to run off the end of a page.
  The overlay is the basic culprit of all of the abends.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 utility users of LOAD with PERIODOVERRIDE    *
  *                 and/or TRANSIDOVERRIDE                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: LOAD INTO TABLE FORMAT DELIMITED        *
  *                      specifying PERIODOVERRIDE and utilizing *
  *                      a field specification list abends with  *
  *                      ABENDS0C4 RC4 at DSNURMFL +x'0242'      *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  LOAD INTO TABLE FORMAT DELIMITED specifying PERIODOVERRIDE and
  utilizing a field specification that specified only a part of
  the columns of the table, abended with an ABEND0C4 at DSNURMFL
  OFFSET0242.  The abend occurred because during initialization
  when control blocks were being built, an error in calculating
  the number of control blocks needed caused duplicate control
  blocks to be built for the ROW START, ROW END, and TRANSACTION
  START ID columns. Because they were duplicates, during their
  creation, already allocated storage ended up being overlayed.
  It was this overlaid storage that caused all of the different
  abends that were seen.
  
  Other abends that occurred were:
  
  ABENDS0C4 RC4 DSNURMFL +x'025C'
  ABENDS0C4 RC4 DSNURWUF +x'2E70'
  ABEND04E RC00E2002F DSNSVSFM +x'0734'
  ABEND04E RC00C200C6 DSNB1RWI +x'1E38'
  ABEND04E RC00E20027 DSNSVBK +x'1C02'
  ABEND04E RC00C202B2 DSNB1PPP +x'2642'
  ABEND04E RC00C202B1 DSNB1PER +x'038E'
  ABEND0C4 RC38 DSNURWI +x'C0FC'
  
  This error can also occur without FORMAT DELIMITED and also with
  TRANSIDOVERRIDE specified.  It can occur when the column is
  defined as a TIMESTAMP WITH TIME ZONE as well.
  
  
  Additional keywords: OFFSET025C OFFSET2E70 OFFSET0734 OFFSET1E38
                       OFFSET1C02 OFFSET2642 OFFSET038E OFFSET025C
                       OFFSETC0FC DB2OVRLAY  DB2OVRLAY/K
  

Problem conclusion

• LOAD code has been changed to not create the duplicate control
  blocks for the ROW BEGIN, ROW END, and TRANSACTION START ID
  columns.
  

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:

  UI12788 UI12789

Modules/Macros

• DSNURWUF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY

     UP

• RB10 PSY

     UP