DB2 Version 9.7 for Linux, UNIX, and Windows

FP5: db2trc command has been improved for clients

In Version 9.7 Fix Pack 5 and later fix packs, the ability to allocate trace resources for the trace facility (which you invoke with db2trc command) helps improve the performance of some remote client applications. Also, clients who use a fenced procedure can capture detailed information about the environment.

For Linux, Solaris, and HP-UX operating systems only, the new db2trcStartupSize configuration file keyword is added to help allocate resources for the trace facility on remote clients. The new configuration file keyword must be placed in the db2dsdriver.cfg configuration file under the global parameters section to allocate and associate trace resources automatically for remote client applications. When the trace facility is initialized it helps improve the performance of applications running on remote DB2® clients.

The db2trc command is also updated to help clients who use a fenced procedure to collect trace related information about the fenced procedure. If you specify the db2trc command with either the -appid or -apphdl parameter, a trace is performed as usual but now it also gathers trace information about fenced procedures.

Note: Modifying the db2dsdriver.cfg configuration file or issuing the db2trc command must only be done when directed by a DB2 technical support representative.