Easytrieve job abends with SQLCODE -805 after DB2 migration

Products

• Easytrieve Report Generator

Issue/Introduction

Encounter an abend in an Easytrieve job after migrating a DB2 entity from one LPAR to another. The job failure includes the following error messages:
B204 SQL - SQL ERROR, SQLCODE IS -805
DSNT408I SQLCODE = -805, ERROR: PACKAGE NAME ####..####.#### NOT FOUND IN PLAN ####
REASON 03
DSNT418I SQLSTATE = 51002
This occurs even if no direct changes are made to the Easytrieve code or the DB2 configuration during the move.

 

Environment

Easytrieve 

DB2

Cause

The Easytrieve package associated with the plan is missing or not bound to the new DB2 location where the job is now executing. Reason code 03 typically indicates that the package was not found because the consistency tokens do not match or the package does not exist at the target location.

Resolution

Identify the working source DB2 where the package exists.
Perform a BINDCOPY of the required package (e.g., ####.####.####) from the source DB2 to the target DB2 (e.g., ####) where the failure is occurring.
Verify that the application job completes as expected after the bind process finishes.
Performing a BINDCOPY is the preferred solution as it avoids the need to modify job JCL or PROC members.