O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tracing Facilities

DB2 has several tracing facilities that can be used during problem determination. These facilities are discussed in the following sections.

DB2 Trace (db2trc)

A DB2 trace is a detailed trace about most function calls in the DB2 libraries. It is generally only useful to DB2 Service because it references specific trace points within the DB2 source code. Running the trace will generally slow down performance because additional code is executed. To reduce performance loss, the trace is written to shared memory by default, which can then be dumped to a file after the trace is completed. The problem with this is that the size of the shared memory buffer must be specified when enabling the trace, so if the trace contents exceed the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required