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 ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
