Question about Detector trace option and DB2 utilities

book

Article ID: 207700

calendar_today

Updated On:

Products

CA Detector for DB2 for z/OS

Issue/Introduction

Are the DB2 Utilities recorded in the Detector trace option?. 

Environment

Release : 20.0

Component : CA Detector for DB2 for z/OS

Resolution

Via either Detector collection or the "SQL trace" additional feature, data on DB2 Utility statements such as LOAD, REORG, or UNLOAD is not collected.  

However, data is collected on all SQL statements executed, including the SELECT, INSERT, UPDATE, DELETE, CALL, PREPARE, EXECUTE, EXECUTE IMMEDIATE, OPEN, FETCH, and CLOSE statements executed.