Subsystem Analyzer for DB2 for z/OSDetector for DB2 for z/OS
Issue/Introduction
Running tests and a procedure failed due to a -905 error exceeding CPU limit. In Omegamon can be seen a specific thread pointing to package SCC355 (Elapsed Time 01min 52sec). In CA Detector the -905 error is not reported with an Exception recorded.
Environment
z/os DB2
Cause
For R19 and above releases, -905 threshold setting under profile options has been deprecated. So Detector will collect the -905 SQL error only if it is generated by DB2.
Resolution
Be aware that for R19 and above releases, -905 threshold setting under profile options has been deprecated. So Detector will collect the -905 SQL error only if it is generated by DB2. The Detector profile threshold setting to flag -905 SQL error is not supported anymore.