|
Problem IT32922
|
Status: Closed |
CREATE OR REPLACE VIEW FAILS WITH SQL0727 WHEN VIEW DOES NOT EXIST
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem 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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to latest fix pack *
**************************************************************** |
| Local Fix: |
Do not specify OR REPLACE if you know the view does not exist.
Alternatively, change auto_reval to DEFERRED. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to latest fix pack *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.05.2020
23.11.2021
23.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
