Limit output of BTPRTRCE SP/UDF Trace Report for a specific Stored procedure
search cancel

Limit output of BTPRTRCE SP/UDF Trace Report for a specific Stored procedure

book

Article ID: 15526

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Limit output of BTPRTRCE for a specific procedure.



How do we Limit output of BTPRTRCE SP/UDF Trace Report for a specific Stored procedure?

 

Environment

z/os DB2

Resolution

WHERE STORPROC-EVENT-TYPE = X'01' 

/* additional qualifiers 

AND EVENT-DUR > 1 SECS 

AND PLAN-NAME = 'DISTSERV' 

AND SCHEMA-NAME = 'SYSPROC' 

STORPROC-NAME-LEN = 6 AND STORPROC-NAME-LONG(,6) = 'JH0R05' 

Powered by Wolken Software