Question about Detector trace option and DB2 utilities

Products

• Detector for DB2 for z/OS

Issue/Introduction

Are the DB2 Utilities recorded in the Detector for Db2 for z/OS (PDT) trace option?

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.