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.)
UID
ibm13286767