Default language.

Db2 application trace (ATRAC)

Data collection must be activated by starting the trace before data can be displayed with the application trace services. A trace can be started by:

  • Using the Start Trace (ST) command on the CT view
  • Using line commands in task-related views to start detail trace for an active transaction
  • Defining ATRAC requests in an AUTOBLK member of your BBI-SS PAS BBPARM data set and referring to it in member BBIISPxx to start the requests automatically
  • Writing an EXEC to issue the SET command for the ATRAC service

Related topic

Collecting-trace-data

A  product must be installed.

Use the IMFEXEC IMFC command followed by the service name, optional parameters, and an identifier for the target Db2 region:

 IMFEXEC IMFC SET REQ=ATRAC SUMTRC1 TYPE=SUMMARY TITLE=title ELAP=5.0 TARGET=db2ssid 

In a BBPARM BLKxxxxx member, the same trace can be specified as:

 REQ=ATRAC PLANNAME TARGET=DB2P TYPE=SQL,SCAN,IO,LOCK, STORAGE=4000K WRAP=Y DB2PLAN=planname TITLE=title GROUPSQL=Y

See BBPARM member BLKDMRKY for a complete description of all keywords that you can use.

This section contains the following topics:


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*