IBM Support

PI96853: ABEND04E RC00E70005 AT DSNXIATS P168 OCCURRED FOR AN ALTER TABLESPACE OF AN INDEX-CONTROLLED PARTITIO 18/05/23 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 AT DSNXIATS P168 OCCURRED FOR AN ALTER
    TABLESPACE OF AN INDEX-CONTROLLED PARTITIONING TABLE
    SPACE CREATED PRIOR TO V8.
    
    LOAD REPLACE or RESUME of PBG running at M500 or higher that
    needs an additional partition for a table created pre-M500 can
    
    fail with a S04E REASON=X'00E40347'  CAUSE=X'00E40405'
    
    and DSNT500I DSNUGRAR RESOURCE UNAVAILABLE REASON 00000072
    
    TYPE 00000000
    
    
    LOCAL FIX:
    For the LOAD failure, ALTER TS PRIQTY nnnn (same PRIQTY as
    initial PRIQTY)
    or  ALTER TABLE xxxxxx.xxxxxxx ADD PARTITION. Only needs to
    
    be run once if the problem is encountered. Doesn't need to be
    
    rerun even if additional partitions are needed for subsequent
    
    LOADs.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 12 for z/OS users of ALTER TABLESPACE                    *
    * BUFFERPOOL and LOAD utility who have                         *
    * applied PI86123/UI53246.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Users might receive an ABEND04E                              *
    * RC00E70005 at DSNXIATS P168 on ALTER                         *
    * TABLESPACE with BUFFERPOOL option.                           *
    *                                                              *
    * LOAD REPLACE or RESUME of partition-by                       *
    * -growth table space running at                               *
    * function level 500 or higher might                           *
    * fail with a S04E RC00E40347                                  *
    * CAUSE=X'00E40405' and DSNT500I.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    Users might receive an ABEND04E RC00E70005 on ALTER TABLESPACE
    with the BUFFERPOOL option on an index-controlled partitioning
    table space created prior to V8. The same abend might also
    occur with other options of ALTER TABLESPACE statement.
    
    LOAD REPLACE or RESUME of partition-by-growth table spaces
    running at function level 500 or higher that needs an
    additional partition for a table created prior to function
    level 500 might fail with a S04E RC00E40347 CAUSE=X'00E40405'
    and DSNT500I DSNUGRAR RESOURCE UNAVAILABLE REASON 00000072
    TYPE 00000000. The same issue might occur on INSERT with
    concurrent Utility on the same table space or REORG that does
    not materialize pending definition changes.
    
    This APAR also handles an existing issue on ALTER TABLESPACE
    with ERASE option of work file table space, where users get
    ABEND0C4 RC00000010 or RC00000038 in DSNGDADP.
    
    This existing issue is exposed when Db2, via PI86123/UI53246,
    populates the missing values of table space's new attributes
    (including SYSTABLESPACE.ERASERULE) to a migrated work file
    table space. In this case, users get
    o ABEND0C4 RC00000010 or RC00000038 in DSNGDADP on ALTER
      TABLESPACE of work file table space with allowed options.
    o ABEND04E RC00C90101 in DSNGD001.DSNGDADP ERQUAL500A when
      growing a new part of work file table space.
    

Problem conclusion

  • Db2 has been modified to avoid the following:
    o ABEND04E RC00E70005 at DSNXIATS P168 on ALTER TABLESPACE
      statement of an index-controlled partitioning table space
      created prior to V8.
    o S04E RC00E40347 CAUSE=X'00E40405' with LOAD REPLACE or
      RESUME, or INSERT, or REORG without pending change
      materialization in function level 500 (or higher) when a
      partition is grown in a partition-by-growth table space
      created prior to function level 500.
    o ABEND04E RC00C90101 in DSNGD001.DSNGDADP ERQUAL500A when
      growing a new part of a migrated work file table space.
    o ABEND0C4 RC00000010 or RC00000038 in DSNGDADP on ALTER
      TABLESPACE of
     - a work file table space with ERASE option.
     - a migrated work file table space with allowed options.
    
    Additional keywords:
    SQLALTER
    RC00E70005
    RC00C90101
    RC00000010
    RC00000038
    RC00E40347
    RC00E40405
    DSNGDADP ERQUAL500A
    MSGDSNT500I
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI96853

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-04-17

  • Closed date

    2018-07-16

  • Last modified date

    2018-09-04

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

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

    UI56192

Modules/Macros

  • DSNXIPG2 DSNGDAII DSNXISB6 DSNXIATS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI56192

       UP18/08/02 P F808 {

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.

[{"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":"12.0","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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 September 2018