PSA0807 SSANALZE CTHREAD FAILED/PLAN NOT AUTHORIZED DB2=DB2U

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Subsystem Analyzer Initialization fails with message PSA0807 followed by PSA0123, PSA0124 and PSA0109:

PSA0807 SSANALZE CTHREAD FAILED/PLAN NOT AUTHORIZED DB2=DB2U                   
PSA0123 CDB PROCESS INIT FAILED. MOST LIKELY PROBLEMS ARE INCORRECT DB2 LOADLIB IN JCL 
PSA0124 CDB PROCESS INIT FAILED.  OTHER CAUSES MAY BE THE SSA PLAN OR ACCESS TO IT, IS NOT SET UP PROPERLY

 

Environment

Release : 20.0

Resolution

The PSA0807 error is indicating an authorization issue. The problem is that the Xmanager id(XXXXXXXX) needs Db2 plan execute authority to the first Subsystem Analyzer plan name in use PSAPLN01(XXXXXXXX) within the PLANSXX member of the CDBAPARM dataset. Once the grant is issued, Xmanager needs to be recycled.  Make sure the plan name in the start command of PSA is correct. Also check the PSAPLN01 plan in the  CDBAPARM(PLANSXX) member matches the PLAN parameter in the Subsystem start commands in your CDBAPXMP library.