IBM Support

db2rbind operations to rebind database packages may encounter sql error: SQL0805 sqlcode = -805

Troubleshooting


Problem

When OpenPages is installed, updated, or has database related maintenance applied in version 7.3 and earlier, the DB2 rebind utility (db2rbind) is used to rebind all packages in the database.  On rare occasions, an error may be encountered, indicating that a package in the db2rbind's list of packages was not found for rebinding.  

 This error can be ignored, as long as all packages are in a valid state.  To ensure packages are in a valid state, run the attached script, op-check-rebind.sql.

Symptom

The oprbind.log will show errors with sqlcode = -850.  

Example:

Package 'OPENPAGE.SQL141628436862360.' of database 'OPX' did not succeed to rebind.
UniqueID = 4B427263514F4969
    sqlcode = -805; sqlerrmc = OPENPAGE; sqlrrp = SQLRA14E
    SQL0805N  Package "OPENPAGE.SQL141628436862360. " was not found.
  SQLSTATE=55
1002

 

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All versions - DB2 deployments only","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS4PJS","label":"IBM OpenPages on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM OpenPages with Watson

Software version:
All versions - DB2 deployments only

Document number:
728185

Modified date:
08 May 2025

UID

ibm10728185

Manage My Notification Subscriptions