SQLCODE=-805 Issuing a SEARCH, INSERT or UPDATE

book

Article ID: 48793

calendar_today

Updated On:

Products

CA Repository

Issue/Introduction

Description:

Attempting to issue a SEARCH, INSERT or UPDATE in the Repository Tab of WebStation Option 7.2 may result in a SQLCODE=-805 Error.

A -805 Error is a DB2 SQL Error which indicates there is a problem locating a particular package or there is a mismatch with the contoken bound to the subsystem.

Solution:

Ensure the following with regards to the Repository Stored Procedures DBSEARCH and DBPROC which are used to control processing in the Repository Tab of WSO.

  1. The corresponding load modules are present in the steplib concatenation of the WLM.
  2. The dataset which contains the Repository Stored Procedures is a PDSE
  3. The Procedures are present in the SYSIBM.SYSROUTINES table and reference the correct WLM
  4. The load module in the WLM steplib matches the module in the Repository loadlib
  5. The Stored Procedure packages are bound with the correct WLM.

Environment

Release:
Component: XTR