Does a multiple condition require an IQL alert

Article Id: 106151

Status: Published

Updated On: 13-07-2018 14:42

Products:

CA Bind Analyzer for DB2 for z/OS , 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:

DB2 page requests greater than 10,000 and synchronous I/O less than 20. This implies a looping thread. Does a multiple condition require an IQL alert?

Environment:

Release:
Component: CIDB

Resolution:

Yes. Complex exceptions usually require an IQL request with a WHERE clause that satisfies the requirement.