ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 200234

calendar_today

Updated On:

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