IBM Support

Understanding the scope of db2trc command in DPF environment

Technical Blog Post


Abstract

Understanding the scope of db2trc command in DPF environment

Body

1. By default, that is to say turning on db2trc without any location-options, the scope is the current host on which the db2trc command is issued, accordingly db2trc is turned on all partitions in the current host.


2. To turn on/off db2trc for all partitions including the partitions on remote host(s), you can use rah:  
rah "db2trc on"
rah "db2trc off"

You can also use location-option '-global' to reach the same goal:
db2trc on -global
Note that option '-global' is deprecated in DB2 Version 9.7 Fix Pack 4 and later fix packs.


3. To turn on/off db2trc for all partitions on the specified host or hosts, you can use the option '-host':
db2trc on -host hostname1
db2trc on -host hostname1,hostname2
 

 

4. To turn on/off db2trc for specified partition or partitions, you can use the option '-member member_number | member_range':
db2trc on -member 0      (turn on db2trc for partition 0)
db2trc on -member 0,1,2  (turn on db2trc for partitions 0,1 and 2)
db2trc on -member all    (turn on db2trc for all partitions defined in db2nodes.cfg.)

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm13286767