IBM Support

PI99129: ABEND04E RC00E70005 DSNXIATB:P033 ON ALTER TABLE ALTER PARTITIONLIMIT KEY

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 DSNXIATB:P033 on ALTER TABLE ALTER PARTITION
    LIMIT KEY.                                              (d79201)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 11 and 12 for z/OS users of          *
    *                 ALTER TABLE ALTER PARTITION ENDING AT        *
    ****************************************************************
    * PROBLEM DESCRIPTION: User receives ABEND04E RC00E70005 at    *
    *                      location DSNXIDDL.DSNXIATB P033 when    *
    *                      executing an ALTER TABLE ALTER          *
    *                      PARTITION ENDING AT statement to        *
    *                      modify a partitioning key.              *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available.         *
    ****************************************************************
    Users might receive ABEND04E RC00E70005 at location
    DSNXIDDL.DSNXIATB P033 when executing an ALTER TABLE ALTER
    PARTITION ENDING AT statement to modify a partitioning key.
    This problem occurs because Db2 incorrectly issues an ABEND
    instead of a SQLCODE -904 while checking if the table is empty.
    
    The following statements also check for table emptiness and
    might be affected:
    - ALTER TABLE ADD CONSTRAINT
    - CREATE INDEX DEFINE NO to define a non-partitioned index
    - CREATE INDEX on a ROW CHANGE TIMESTAMP column
    - ALTER INDEX ADD COLUMN to include a ROW CHANGE TIMESTAMP
      column
    

Problem conclusion

  • Db2 is modified to correctly process SQLCODE -904 errors that
    might occur while checking if a table is empty and return them
    to the user.
    
    Additional Keywords:
    DSNXIATB
    ABEND04E
    RC00E70005
    SQLCODE904
    SQLALTER
    SQLCREATE
    SQLCONSTRAINT
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI99129

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-06-13

  • Closed date

    2018-08-13

  • 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:

    UI57834 UI57835

Modules/Macros

  •    DSNXIAB4 DSNXIATB DSNXIAX2 DSNXICX2
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI57835

       UP18/08/29 P F808

  • RC10 PSY UI57834

       UP18/08/29 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.



Document information

More support for: DB2 for z/OS

Software version: 11.0

Reference #: PI99129

Modified date: 04 September 2018


Translate this page: