IFCID 147 - Distributed Header Data

This topic shows detailed information about Record Trace - IFCID 147 - Distributed Header Data.

Place text here

DISTRIBUTED HEADER DATA
REQUESTING LOCATION   : REQUESTLOCATION1
AR NAME               : SRVNAMPARAMETER1
REQUESTING TIMESTAMP  :                      N/P  PRDID : PRD VID R0 M1

REQUESTING LOCATION

The location name of the requester. If the thread is an allied thread (no distributed requests) or the thread is an allied-distributed thread (this location is the requester), OMEGAMON for Db2® PE sets this field equal to the local location. If the thread is a database access thread (this location is a server).

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup. For parallel query rollup records, the value will be derived from the parent record.

Field Name: QWHDRQNM

AR NAME

The application requester name.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup. For parallel query rollup records, the value will be derived from the parent record.

Field Name: QWHDSVNM

REQUESTING TIMESTAMP

The timestamp for database access thread (DBAT) records.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup. For parallel query rollup records, the value will be derived from the parent record.

Field Name: QWHDTSTP

PRDID

Shows the product identifier (ID) of the requester. It can have the following values:

DB2

For Db2 UDB for z/OS®

SQL/DS

For Db2 UDB for VSE and VM

JDBC DRIVER

For Universal JDBC driver

COMMON SERV

For Db2 UDB for Linux®, UNIX, Windows

DB2/400

For Db2 UDB for IBM i

Otherwise, it shows the first 3 characters of the product ID, or N/P if the record was written at the application requester location.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup. For parallel query rollup records, the value will be derived from the parent record.

Field Name: QWHDPRID