DB2 Trace

[ Team LiB ]

DB2 Trace The DB2 trace facility has been significantly improved in v8 and it can now be used as one of the primary tools for gathering information regarding a problem. However, the DB2 trace should only be used in conjunction with DB2 Support. DB2 trace records information about operations and formats it into a readable form. On UNIX, sysadm, sysctrl, or sysmaint authority is required. On Windows, no authorization is required. NOTE db2trc can be used to trace activity for an instance or for the DB2 Administration server. A connection to the database is not required. db2trc is useful when other FFDC facilities have failed to provide you and DB2 Support with enough information to identify and solve the problem being investigated. The following is an example of the db2trc command: db2trc on �p 20, 40, 60 The example command causes tracing to be enabled for processes 20, 40, and 60. Use the following command to dump the trace information to a file: db2trc dmp dbtrc.dmp After you have dumped the trace to a file you must stop the trace as follows: db2trc off After you have turned the trace off, you can format it using the flw or fmt option. Note that the db2trc command has to be issued multiple times to gather the information and format it to a text file. For further information, refer to the DB2 UDB v8 Command Reference.

[ Team LiB ]