-805 errors reported in Detector

Products

• Detector for DB2 for z/OS

Issue/Introduction

Multiple SQL error -805 messages in Detector for DB2 for z/OS from an operator ID (OPID). This behavior occurs even if the jobs do not show errors in their logs or the program is not listed as being called.

Environment

z/os 

DB2

Cause

The issue occurs because a DB2 bind for the program is missing. 

Resolution

1. Perform a rebind of the plans and packages for the affected program. 
2. Ensure there is no mismatch between when the program was compiled/assembled and when it was bound.
3. Verify how the program handles SQL error -805 to ensure it is reporting correctly in your environment.