|
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) |
