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

Document ID : KB000015526
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Limit output of BTPRTRCE for a specific procedure.

Question:

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

 

Environment:
z/os DB2
Answer:

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'