IBM Support

PI50849: ALLOW ALTER TABLE DROP RESTRICT ON DROP FOR AN AOT

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Allow ALTER TABLE DROP RESTRICT ON DROP
    when the target table is an accelerator-only table.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 and 11 for z/OS users of              *
    *                 IBM DB2 Analytics Accelerator                *
    ****************************************************************
    * PROBLEM DESCRIPTION: User creates an accelerator-only table  *
    *                      with the WITH RESTRICT ON DROP option   *
    *                      specified, but cannot drop the table    *
    *                      because ALTER TABLE is restricted for   *
    *                      accelerator-only tables.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Users can create accelerator-only tables with the
    WITH RESTRICT ON DROP option specified. Afterwards, the table
    can only be dropped if it is altered to remove the
    WITH RESTRICT ON DROP attribute.
    
    However, all ALTER TABLE options on accelerator-only tables are
    restricted. This prevents accelerator-only tables with the
    WITH RESTRICT ON DROP attribute from being altered to remove the
    attribute and prevents them from being dropped.
    
    Users who attempt to DROP such a table receive SQLCODE -672:
    "OPERATION DROP NOT ALLOWED ON TABLE table-name".
    
    Users who attempt to ALTER the table to remove the attribute
    receive SQLCODE -650, REASON 28: "ALTER TABLE is not allowed
    when the table is an accelerator-only table."
    

Problem conclusion

  • DB2 has been modified to allow the following ALTER TABLE options
    for accelerator-only tables:
    - ADD RESTRICT ON DROP
    - DROP RESTRICT ON DROP
    
    Users can now alter accelerator-only tables to add or remove the
    WITH RESTRICT ON DROP attribute.
    
    The IBM Knowledge Center documentation for DB2 10 and 11 for
    z/OS will be modified as follows:
    - The ALTER TABLE statement topic will state that only the
      RESTRICT ON DROP options can be specified for accelerator-only
      tables.
    - The SQLCODE -650, REASON 28 documentation will state that only
      the RESTRICT ON DROP options can be specified for
      accelerator-only tables.
    
    Additional Keywords:
    SQLALTER
    SQLDROP
    SQLCODE650
    SQLCODE672
    IDAAV4R1/K
    IDAAV5R1/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI50849

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-10-20

  • Closed date

    2016-02-02

  • Last modified date

    2016-03-02

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

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

    UI34985 UI34986

Modules/Macros

  •    DSNXIATB
    

Publications Referenced
GC19297100 SC19298300 GC19405300 SC19406600  

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI34985

       UP16/02/18 P F602

  • RB10 PSY UI34986

       UP16/02/18 P F602

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

Reference #: PI50849

Modified date: 02 March 2016


Translate this page: