This document states how PSA0820 TABLE LOCFAIL SQLCODE=-805 messages can usually be corrected.
How can I correct the PSA0820 TABLE LOCFAIL SQLCODE=-805 messages that appear in my Xmanager Log?
z/OS 1.11 and above.
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