How can I correct the PSA0820 TABLE LOCFAIL SQLCODE=-805 messages that appear in my Xmanager Log?

Document ID : KB000015492
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

This document states how PSA0820 TABLE LOCFAIL SQLCODE=-805 messages can usually be corrected.

Question:

How can I correct the PSA0820 TABLE LOCFAIL SQLCODE=-805 messages that appear in my Xmanager Log?

Environment:
z/OS 1.11 and above.
Answer:

The PSA0820 TABLE LOCFAIL SQLCODE=-805 messages usually indicates a mismatch in plan names. In these cases, it can be corrected by:

1) Obtaining the name of your Subsystem Analyzer Plan name. It can be found in your <High.Level>. CDBAPARM(PLANSxx) member's PSAPLN01= Plan name

2) Place the above name into the PLAN() parameter of your Subsystem Analyzer start commands in your <High.Level>. CDBAPXMP library. Sample start commands can be found in the $STRTPSA & $STRTALL members 

3) Recycle your Xmanager