Abend S878 while doing a Plan Analyzer for Db2 for z/OS (PPA) Explain with PROCVIEW=Y.
Turning off PROCVIEW resolved the problem. It is failing both online (TSO region size 131072)
and Batch Region=0M without any exit. This only affects one system.
When PROCVIEW=Y is turned on, PPA is required to recursively parse through every dependent view or MQT
statement in that query and build the associated data structures necessary for the selected reports.
Certainly, if one system has a larger number of views or MQTs that can impact storage demands.
It also depends on:
- The SQL statements being processed and the number of view/MQT levels that need to be traced through
- The number of collections or packages to be Explained
- The number of reports selected
Turning off PROCVIEW will resolve the symptom.