DB2 - Problem description
Problem IT29681 | Status: Closed |
BIND OF PACKAGE FROM NON CATALOG NODE RESULTS WITH A SQL0727 WITH SQLCODE-805 | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Binding package from a non-catalog node may result in a SQL0727N with SQLCODE -805. If same package bound from catalog node the bind does not fail. If the SQL in a bind file (or in the source file if issuing a PRECOMPILE) refers to an object like a function or procedure that is in an invalid state, then the attempt to revalidate the object during the bind will fail with a SQL0727N and sqlcode -805 if the bind or precompile is issued from a connection at a non-catalog node. if the connection is from the catalog node this error is not returned. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Those in DPF environments * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 fp6 * **************************************************************** | |
Local Fix: | |
Bind from Catalog Node or revalidate the invalid object referenced in the SQL by using ADMIN_REVALIDATE_DB_OBJECTS. | |
Solution | |
Workaround | |
Bind from the catalog node | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.07.2019 17.12.2019 17.12.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |