IBM Support

PM95270: LOAD WITH PERIODOVERRIDE CAUSING MULTIPLE ABENDS

Subscribe

You can track all active APARs for this component.

 

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 number

    PM95270

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-08-16

  • Closed date

    2013-11-21

  • Last modified date

    2018-03-14

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 March 2018