DISTSERV SQL NOT EXCEPTION

book

Article ID: 16267

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction



A SQL statement that is currently executing has not been captured as an exception even though it has exceeded the threshold for GETPAGES. Why is this?

Environment

Release:
Component: PDT

Resolution

The reason why this SQL statetement has not been labeled an exception is that it has not yet finished. When the statement ends, it is then evaluated to determine if it exceeded the threshold limits.