IQL exception does not trigger after upgrade to Sysview for Db2 r19
search cancel

IQL exception does not trigger after upgrade to Sysview for Db2 r19

book

Article ID: 72519

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Sysview Performance Management Option for Db2 for z/OS (IDB2) IQL exception that no longer works in r19.
It is an exception that should trip if an active thread extends beyond 5 minutes without a commit.

Cause

The exception does not match the definition, because the ID in the exception output is too short.
The output text must start with an eight character ID padded on the right side with blanks if needed.  

Resolution

Ensure the exception matches the definition.  In this particular scenario, the ID in the exception output was too short.
The output text must start with an eight character ID padded on the right side with blanks (as needed).