How to Fix DB2 SQLcode=-805? -IBM Mainframes SQLCODE -805 in DB2 indicates that a required package was not found Specifically, it means the application program attempted to use a DBRM (Database Request Module) or package that is not available at runtime
Getting error SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME Not found Which means The package name was not found because there is no package list for the plan Contact DB2 admins asking them to add the PKLIST option with the appropriate package list entry to the REBIND subcommand and rebind the application plan that is identified by name COBDBSTR Got the correct plan from DB2ADM (DB2 administrator)
Resolving Db2 SQLCODE -805 error for DSNACLI plan When processing large amounts of data, you can encounter insufficient space in the Db2® work file database Batch import jobs from the Inquisitor or the Usage Monitor require exclusive access to tables in the Repository database to prevent timeouts or deadlocks
ERROR: DSNT408I SQLCODE = -805, ERROR: PACKAGE NAME when DB2 z OS . . . This error occurs after creating a new WLM environment and attempting to run the Stored Procedure In this case, there is a COLLID mismatch between the failed STC message and the query against the sysroutines output for the Stored Procedure
DB2 Error Code -805 program name location name. collection id. program . . . In this post, you’ll learn about the error message -805 program name location name collection id program name consistency token not found in plan plan name in the IBM DB2 database , the reason why it occurs along with the solution to fix it