You can create a trace profile for an accelerator. In a trace profile, you can edit trace
level details and trace components.
About this task
Trace profiles provide the following information:
The accelerator components to be traced and the trace detail level
The approximate size of the compressed trace data
Whether a trace record is immediately written to disk (flush) or if it is cached in memory for
better performance
You can select and activate trace profiles. You can also define new profiles and remove
existing ones. Several trace profiles are preconfigured on the accelerator.
Procedure
On the DB2 Administration Menu
(ADB2) panel, specify option
Z, and press Enter.
The System Administration
(ADB2Z) panel is
displayed.
Specify option AC, and press Enter.
The DB2 Accelerators
(ADBPZAC) panel is displayed, as shown in the
following figure.
Figure 1. DB2 Accelerators
(ADBPZAC) panel
ADBPZAC n --------------- DB2X DB2 Accelerators -------------- Row 1 to 2 of 2
Command ===> Scroll ===> PAGE
Commands: DIS ADD
Line commands: STA - Start accelerator STO - Stop accelerator T - Tables
DIS - Display accelerator L - Location AT - Accelerated tables DEL - Delete
? - Show all line commands
Select Accelerator Name Location Type IP Address Port
* * * * *
------ ---------------- ---------------- ---- --------------- -----
ACC1 V
ACC2 ACC2 R 9.116.85.193 1277
In the Select column, specify TPR to display a
list of trace profiles that are associated with the accelerator, and press Enter.
The Accelerator Trace Profiles
(ADBPZTPR) panel is displayed, as shown in
the following figure.
ADBPZTPR ----------- DB2X Accelerator Trace Profiles -------- Row 1 to 8 of 8
Command ===> Scroll ===> PAGE
Accelerator name : ACC1
Commands: ADD
Line commands:
CO - Components DESC - Description DEL - DeleteACT - Activate
Default File Force
Sel Name Active Level Size Flush
* * * * *
---- ----------------------- ------ --------------- ----- -----
DEFAULT YES WARN 3 NO
QUERY NO WARN 160 NO
LOAD NO WARN 90 NO
ARCHIVE NO WARN 90 NO
REPLICATION NO WARN 63 NO
SOFTWARE_UPDATE NO WARN 20 NO
CONTROLLERS NO WARN 20 NO
SYSTEM_CRASH NO TRACE 1000 YES
Specify ADD to add a new trace profile, and press Enter.
The Add Accelerator Trace
Profile (ADBPZTPA) panel is displayed, as shown
in the following figure.
ADBPZTPC ----------- DB2X Accelerator Trace Profiles ------------- 16:54
Command ===> Scroll ===> PAGE
Accelerator name . . : ACC1
Trace profile name . : QUERY_NEW
Commands: CONTINUE CANCEL
Line commands:
I - Insert R - Repeat D - Delete
S Name Level Operation
* * *
---- ------------------------------ -------------- ----------
? ?
The following component names are valid: CATALOG, CONTROLLER, DRDA, PROFILING, REPLICATION,
SERVICES or TRACE.
The following component values are valid: DEBUG, ERROR, INFO, OFF, TRACE or WARN.
What to do next
You can activate a non-default or user-created trace profile by issuing the ACT command. Activating a trace profile allows you to capture and provide customized details to IBM® Support.
Important: Using a trace profile other than the DEFAULT profile can lower the performance of the accelerator. Use a non-default profile only when instructed to do so by IBM Support. Re-enable the DEFAULT profile when the support activities are complete.