IBM Support

IT32879: CREATE OR REPLACE VIEW FAILS WITH SQL0727 WHEN VIEW DOES NOT EXIST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible.

Error description

  • With auto_reval set to IMMEDIATE, CREATE OR REPLACE VIEW may
    fail with SQLCODE -727 if the view does not exist.  This can
    happen if the view was previously dropped leaving invalidated
    dependent objects.  Since there is no actual view replacement,
    Db2 should not try to re validate the dependent objects
    immediately.  If an error occurs during revalidation, this
    prevents successful completion of the CREATE OR REPLACE VIEW.
    

Local fix

  • Do not specify OR REPLACE if you know the view does not exist.
    Alternatively, change auto_reval to DEFERRED.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to latest fix pack                                   *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT32879

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED UR5

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-14

  • Closed date

    2021-11-23

  • Last modified date

    2021-11-23

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

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

    IT32922

Fix information

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022