Displaying information about stored procedures with Db2 commands

Use the DISPLAY PROCEDURE command and the DISPLAY THREAD command to obtain information about a stored procedure while it is running.

About this task

Because native SQL procedures do not run in WLM-established address spaces, the best way to monitor native SQL procedures is by using the START TRACE command and specifying accounting class 10, which activates IFCID 239.