How to filter the sql history by authid / correlation id & read the entire SQLTEXT in IDB2?

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

How to filter the sql history by authid / correlation id and read the entire SQLTEXT?

 

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

For option 11 SQL Exec History,, there is no filter for R/HSUDYNSQ Dynamic SQL Statistics - History Summary