Why did Detector not Capture a -904 DISTSERV error that occurred in relation to a -254 error

Products

• Detector for DB2 for z/OS

Issue/Introduction

A -904 error was captured in Detector for Db2 for z/OS (PDT) on one Db2 subsystem. However, on a different Db2 subsystem it was not captured
but a -254 error was captured.

Resolution

Detector tracks SQL calls and picks up SQL Error from the Db2 control block provided the thread was established. If the thread did not get far enough
where Detector was able to intercept the SQL Call, then we will not be able to track the SQL error.