search cancel

IDB2 IQL exception displays a thread not found in Thread History

book

Article ID: 258144

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Sysview for Db2 (IDB2) has an IQL exception displaying a thread that is not in Thread History for the same timeframe.

 

Environment

Release : 20.0

Cause

DB2 ZPARM ACCUMAC being set to a high value (i.e. 10)

Resolution

With DB2 ZPARM ACCUMAC set at ten (ACCUMAC=10), there is always a chance that history could be missing the explicit thread's QMDA-PRODUCT (Prd ID) value due to the rollup (every tenth) record (based on enduser ID and wkstation) not containing the same QMDA-PRODUCT (Prd ID).