Tracing Host variables for static SQL calls

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.