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
Release : 20.0
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.