S878 abend when explaining with PROCVIEW=Y using Plan Analyzer.
search cancel

S878 abend when explaining with PROCVIEW=Y using Plan Analyzer.

book

Article ID: 32494

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS

Issue/Introduction

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.

Cause

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  

 

Resolution

Turning off PROCVIEW will resolve the symptom.