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

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

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?

Environment

z/OS 1.11 and above.

Resolution

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