DT212I SQL text length exceeds maximum length retained

Products

• Database Management for DB2 for z/OS - Performance Suite
• Detector for DB2 for z/OS

Issue/Introduction

Is it possible to set CA Detector to collect large SQLs ? According to the documentation for static SQL text the max value is 4000 bytes and for dynamic  32767 bytes. Can it be overwritten ? 

 

Environment

Release : 20.0

Component : General Services for DB2

Resolution

The Static and dynamic max value can be overwritten. The Static text can be viewed in its entirety from the standard activity displays.