Plan Analyzer statistics manager strategy executed online fails with PSA013 internal error
search cancel

Plan Analyzer statistics manager strategy executed online fails with PSA013 internal error

book

Article ID: 118740

calendar_today

Updated On: 10-06-2023

Products

Plan Analyzer for DB2 for z/OS

Issue/Introduction

Plan Analyzer for Db2 for z/OS (PPA) Statistics Manager failed with the following message when executing a strategy online using these control cards:
PS013E: Internal error in @DATX . RC=40, Reason=76, Reason2=0

STRATEGY = (xxxx,xxxxxx,PSM,000000,ssid,U)
DESC = ()
ROLLBACK = (Y)
QUALIFIER = (SYSIBM)
CALCOPTS = (TSPCTFREE,TSPAGEFREE,IXPCTFREE,IXPAGEFREE,SEGSIZE, COLGROWTH/05)
IMPORT = (ssid,LOCAL)
EXPORT = (ssid,LOCAL)
OBJECT = (S,,xxxx)
FUNCTION = (IMPORT)

Environment

Release:
Component: ANLDB2

Resolution

Increasing the region size of the TSO User id or running the strategy in batch resolves the problem.