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

book

Article ID: 15492

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA 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