search cancel

Does a multiple condition require an IQL alert

book

Article ID: 106151

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS 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.