Tracing Host variables for static SQL calls

book

Article ID: 238704

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Is it possible to list the host variables used in some SQL static calls (COBOL program)? 

 

Environment

Release : 20.0

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

Resolution


There are some IFCID records that can provide limited information about host variables, 
but the product does not have a native function to provide host variables used in some SQL static calls.


The CA Detector product does provide some information on Host Variables
in Static SQL statements.