Administrator Guide : Troubleshooting and support : Troubleshooting a problem : Comparison of the Monitor facility and the SQL Trace facility
  
Comparison of the Monitor facility and the SQL Trace facility
The output of the Monitor facility and the SQL Trace facility is slightly different. For example, you need to use the SQL Trace facility to trace statements that are executed in stored procedures.
Description
Monitor
SQL trace
Trace SQL statements executed in stored procedures
No
Yes
Dynamic SQL parameter values
Yes
No
Statement row counts
Yes
No
Commit return code
No
Yes
User connect and disconnect messages
Yes
No
trans begin displayed at the start of transactions
No
Yes
Same statement ID displayed as in ADMIN COMMAND 'userlist' and ADMIN COMMAND 'sqllist' outputs
Yes
No
See also
Troubleshooting a problem