Collecting report data with the Db2 START TRACE command

You can use the Db2 START TRACE command to obtain all types of Db2 trace data.

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:

• TRACE privilege
• SQLADM authority
• System DBADM authority
• SYSOPR authority
• SYSCTRL authority
• SYSADM authority
• SECADM authority

Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. A logged-on z/OS user ID must be defined in RACF or a similar security server. A logged-on z/OS user ID must be defined in RACF or a similar security server.

For more details about the environment, syntax, and option descriptions for this command, see the -START TRACE command (Db2) topic in IBM® Db2 for z/OS® in IBM Documentation.