DB2 Version 9.7 for Linux, UNIX, and Windows

FP3: Improvements to the granularity of the db2trc tool

Starting with V9.7 FP3, two new features have been added to improve the granularity of the db2trc tool. These are an ability to trace only the members (or partitions) specified and an ability to trace based on a specific application ID (or application handle).

To provide this functionality the following trace masks have been added to the db2trc tool.

-appid: Use this parameter to trace specific application IDs. The -appid option works with the on and change command. -appid will not work with the -perfcount option
-apphdl: Use this parameter to trace specific application handles. The -apphdl option works with the on and change command. -apphdl will not work with the -perfcount option
-member: Specifies which database members (or partitions) to trace. The -member option works with the on, change, format (both flow and format options), stop, and off options.