DB2 - Problem description
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) |