Creating trace profiles

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.

Figure 2. Accelerator Trace Profiles (ADBPZTPR) panel

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 - Delete  ACT - 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.

Figure 3. Add Accelerator Trace Profile (ADBPZTPA) panel

ADBPZTPA ------ DB2X Add Accelerator Trace Profile ------------ 07:24
Command ===>                                                                   
                
Commands: CONTINUE  COMP

Accelerator name . . ACC1  
Profile name . . . . QUERY_NEW                                                                
Default level  . . .         (D-DEBUG, DE-DEBUG_EXTENDED, E-ERROR, F-FATAL,
                              I-INFO, O-OFF, T-TRACE or W-WARN) 
File size in MB  . .         (1-4096)
Force flush  . . . .         (Yes/No)    
Description  . . . .

Specify COMP command to define individual tracing components whose trace levels deviate from the default trace level, and press Enter.

The Accelerator Trace Profiles (ADBPZTPC) panel is displayed, as shown in the following figure.

Figure 4. Accelerator Trace Profiles (ADBPZTPC) panel

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.