Managing Db2 profile tables

Db2 profile tables can be used to monitor threads and connections, customize certain subsystem parameters in particular contexts, set special registers, set global variables, and stabilize dynamic SQL statements.

Before you begin

A set of profile tables must already exist on the Db2 subsystem. These tables are created by a Db2 installation job.

About this task

In Db2 Admin Tool, you can manage these profile tables by using the Display/Manage Profile Tables (ADB2Z2P) panel:

Figure 1. Display/Manage Profile Tables (ADB2Z2P) panel

ADB2Z2P n                DD1A Display/Manage Profile Tables               16:18
Command ===>                                                                   
                                                                               
                                                                               
   1 - Display profiles                                                        
   2 - Display profile attributes                                              
   3 - Display profile history                                                 
   4 - Display profile attributes history                                      
   5 - START PROFILE                                                           
   6 - STOP PROFILE 
   7 - DISPLAY PROFILE                                                           
                                                                               
 History display filter:                                                       
   Created within .

Tip: Option 1 and option 7 are not the same. Option 7 issues the DISPLAY PROFILE command; option 1 displays all of the profile information in DSN_PROFILE_TABLE.

To navigate to this panel from the DB2 Administration Menu (ADB2) panel, specify Z.2P.