Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

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

A BMC MainView AutoOPERATOR 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:

Related topic

Collecting-trace-data

 

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