Common Fields

The following idb2 fields are found in all records.
caidb219
The following 
CA SYSVIEW for DB2
 fields are found in all records.
  • ENDUSER-USERID
    Specifies the user ID of the end user of the thread for which the storage is being reported.
    IBM DB2 Field Name:
     QWHCEUID
  • ENDUSER-TRANSACTION
    Specifies the transaction name of the end user of the thread for which the storage is being reported.
    IBM DB2 Field Name:
     QWHCEUTX
  • ENDUSER-WORKSTATION
    Specifies the workstation name of the end user of the thread for which the storage is being reported.
    IBM DB2 Field Name:
     QWHCEUWN
  • HEADER-FLAGS
    Specifies the following flags:
    • x'80
      —Indicates whether trace information in selected fields is in UNICODE (UTF-8). 1—The trace is in UNICODE.
    • x'40'
      —Indicates whether a check for record compatibility or incompatibility is required. 1—The check is required.
    IBM DB2 Field Name:
     QWHSFLAG
  • BASEREL-SUBVERSION
    Specifies the subversion for the base release.
    IBM DB2 Field Name:
     QWHSSUBV
  • ENDUSER-USERID-OFFSETS
    Specifies the offset from the beginning of data section to the variable/long field name, when the QWHCEUID field is truncated. This field is thread-related and does not apply to record types 1, 2, 1001, and 1002.
    IBM DB2 Field Name:
     QWHCEUID_OFF
  • ENDUSER-USERID-VAR
    Specifies the workstation user ID of the end user. This ID can be different from the authorization ID used to connect to DB2. If the client did not supply this information, this field is blank.
    This field varies in length and contains the complete name.
    IBM DB2 Field Name:
     QWHCEUID_D
  • ENDUSER-USERID-LEN
    Specifies the length of the user ID of the end user.
    IBM DB2 Field Name:
     QWHCEUID_LEN
  • ENDUSER-USERID-LONG
    Specifies the workstation user ID of the end user. This ID can be different from the authorization ID used to connect to DB2. If the client did not supply this information, this field is blank.
    This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWHCEUID_VAR
  • REC-NAME
    Specifies the record-name-event type.
    IBM DB2 Field Name:
     N/A
  • RMID
    Specifies the resource manager ID.
    IBM DB2 Field Name:
     QWHSRMID
  • IFCID
    Specifies the IFCID.
    IBM DB2 Field Name:
     QWHSIID
  • LSE-IND-NUM
    Specifies the release indicator number.
    IBM DB2 Field Name:
     QWHSRN
  • ACE
    Specifies the ACE address-dispatch unit address.
    IBM DB2 Field Name:
     QWHSACE
  • SUBSYS
    Specifies the subsystem name.
    IBM DB2 Field Name:
     QWHSSSID
  • EVENT-TIME
    Specifies the event date and time (STCK).
    IBM DB2 Field Name:
     QWHSSTCK
  • EVENT-TIME-HOURS
    Specifies the store clock time when the trace record was produced. The value is trimmed to hours and can be used to group data in a summary request.
    IBM DB2 field name:
     Derived from QWHSSTCK
  • EVENT-DATE
    Specifies the event date (STCK), 
    yyyymmdd
    .
    IBM DB2 Field Name:
     Derived from QWHSSTCK
  • EVENT-TOD
    Specifies the event time of day (STCK), 
    hhmmss
    .
    IBM DB2 Field Name:
     Derived from QWHSSTCK
  • EVENT-TIMESTAMP
    Specifies the event time in DB2 timestamp format, 
    YYYYMMddhhmmssnnnnnn
    .
    IBM DB2 Field Name:
     N/A
  • EVENT-DAY-OF-YEAR
    Specifies the day portion of Julian date.
    IBM DB2 Field Name:
     N/A
  • EVENT-DAY-OF-WEEK
    Specifies the day of the week (a number from 1 through 7, where 1 represents Sunday).
    IBM DB2 Field Name:
     N/A
  • EVENT-CP
    Specifies the CPU time between the start/end pair of events. This time does not include the CPU time that is consumed on an IBM zIIP.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     Delta of QWHUCPU-QWHUSE values
  • WEEK-NUM
    Indicates the relative week number since 01/01/1900. This field is useful in grouping or summarizing data by week.
    IBM DB2 Field Name:
     Derived from QWHSSTCK
  • INTTIME, INT-START-TIME
    Specifies the start timestamp of the interval, for an interval-based request.
    IBM DB2 Field Name:
     N/A
  • INTENDTM, INT-END-TIME
    Specifies the end timestamp of the interval, for an interval-based request.
    IBM DB2 Field Name:
     N/A
  • INTELAP, INT-ELAP-TIME
    Specifies the elapsed time for the interval, for an interval-based request.
    IBM DB2 Field Name:
     N/A
  • DEST-SEQ-NUM
    Specifies the record sequence number for the destination.
    IBM DB2 Field Name:
     QWHSWSEQ
  • IFCID-SEQ-NUM
    Specifies the record sequence number for the IFCID
    IBM DB2 Field Name:
     QWHSISEQ
  • LOCATION
    Specifies the local location name.
    IBM DB2 Field Name:
     QWHSLOCN
  • LOCATION-OFFSET
    Specifies the offset from the beginning of data section to the variable/long field name, when the QWHSLOCN field is truncated. This field provides no practical tuning purposes. The monitor uses this field to locate the long name in a DB2 trace record. Use this field to verify that DB2 provides a long name in the trace record.
    IBM DB2 Field Name:
     QWHSLOCN_OFF
  • LOCATION-VAR
    Identifies the location name by which DB2 refers to a particular DB2 subsystem in a network of subsystems.
    The location name is defined in the communications database in table SYSIBM.LOCATIONS, which maps location names to VTAM LU names.
    This field varies in length and contains the complete name.
    IBM DB2 Field Name:
     QWHSLOCN_D
  • LOCATION-LEN
    Specifies the length of the location name.
    IBM DB2 Field Name:
     QWHSLOCN_LEN
  • LOCATION-LONG
    Identifies the location name by which DB2 refers to a particular DB2 subsystem in a network of subsystems. The location name is defined in the communications database in table SYSIBM.LOCATIONS, which maps location names to VTAM LU names. 
    This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWHSLOCN_VAR
  • AUTH-ID
    Specifies the authorization ID. This field is thread-related and does not apply to record types 1, 2, 1001, and 1002.
    IBM DB2 Field Name:
     QWHCAID
  • AUTH-ID-OFFSET
    Specifies the offset from the beginning of data section to the variable/long field name, when the QWHCAID field is truncated. This field provides no practical tuning purposes. The monitor uses this field to locate the long name in a DB2 trace record. Use this field to verify that DB2 provides a long name in the trace record.
    IBM DB2 Field Name:
     QWHCAID_OFF
  • AUTH-ID-VAR
    Specifies the primary authorization ID of the DB2 thread producing the trace data. This field varies in length and contains the complete name.
    IBM DB2 Field Name:
     QWHCAID_D
  • AUTH-ID-LEN
    Indicates the length of the authorization ID.
    IBM DB2 Field Name:
     QWHCAID_LEN
  • AUTH-ID-LONG
    Specifies the primary authorization ID of the DB2 thread producing the trace data. This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWHCAID_VAR
  • CORR-ID, CORRELATION
    Indicates the correlation ID value. This field is thread-related and does not apply to record types 1, 2, 1001, and 1002.
    IBM DB2 Field Name:
     QWHCCV
  • CORR-NAME-DERIVED
    Contains a derived value from the correlation ID. 
    • For IMS threads, the value is the PSB name.
    • For CICS threads, the value is the CICS transaction ID.
    • For all other threads, the value is the same as the correlation ID.
    This field is useful for grouping CICS and IMS data.
    IBM DB2 Field Name:
     Derived from QWHCCV
  • JOB-STEP
    Contains a JCL step name for the batch job when the DB2 thread is running as a TCB.
    This field is new with DB2 12.
    IBM DB2 Field Name:
     QWHCJOBSTEP 
  • CONN-NAME, CONNECTION, CONN-TYPE
    Specifies the connection name. This field is thread-related and does not apply to record types 1, 2, 1001, and 1002.
    IBM DB2 Field Name:
     QWHCCN
  • CONN-TYPE-8
    Contains a short description of the type of connection that the thread that produced the trace data uses. Examples include the following descriptions:
    • TSO
    • DB2CALL
    • DLI-BTCH
    • CICS
    • IMS-BMP
    • IMS-MPP
    • DB2-PRIV
    • DRDA
    • IMS-CNTL
    • IMS-TBMP
    • UTILITY
    • RRS
    IBM DB2 Field Name:
     Derived from QWHCATYP
  • PLAN-NAME, PLAN
    Specifies the plan name. This field is thread-related and does not apply to record types 1, 2, 1001, and 1002.
    IBM DB2 Field Name:
     QWHCPLAN
  • OPER-ID
    Specifies the original authorization ID before signon exit. This field is thread-related and does not apply to record types 1, 2, 1001, and 1002.
    IBM DB2 Field Name:
     QWHCOPID
  • OPER-ID-OFFSET
    Specifies the offset from the beginning of data section to the variable/long field name, when the QWHCOPID is truncated. This field provides no practical tuning purposes. The monitor uses this field to locate the long name in a DB2 trace record. Use this field to verify that DB2 provides a long name in the trace record.
    IBM DB2 Field Name:
     QWHCOPID_OFF
  • OPER-ID-VAR
    Identifies the original authorization ID before the authorization exit routine of the installation changed the ID. 
    If the exit routine did not change the original ID, or is not present, then the OPER ID is the same as the authorization ID.
    An exception to this situation occurs when thread is reused for IMS and CICS. If a thread is reused in CICS or IMS and the authorization ID of the current user differs from the authorization ID currently associated with the thread (the last user of the thread), then the OPER ID is the authorization ID of the previous user.
    This field varies in length and contains the complete name.
    IBM DB2 Field Name:
     QWHCOPID_D
  • OPER-ID-LEN
    Specifies the length of the original authorization ID.
    IBM DB2 Field Name:
     QWHCOPID_LEN
  • OPER-ID-LONG
    Identifies the original authorization ID before the authorization exit routine of the installation changed the ID. 
    If the exit routine did not change the original ID, or is not present, then the OPER ID is the same as the authorization ID.
    An exception to this situation occurs when thread is reused for IMS and CICS. If a thread is reused in CICS or IMS and the authorization ID of the current user differs from the authorization ID currently associated with the thread (the last user of the thread), then the OPER ID is the authorization ID of the previous user.
    This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWHCOPID_VAR
  • EVENT-DUR
    Specifies the event duration-for end events from START/END pairs.
    IBM DB2 Field Name:
     N/A
  • EVENT-CPU
    Specifies the event CPU time-for end events from START/END pairs. This time includes CPU that is consumed on an IBM zIIP.
    DB2 or
    CA SYSVIEW for DB2
    normalized the zIIP CPU time to standard CP time. If the zIIP processor is faster than the standard CP, the reported zIIP CPU and total CPU times can be greater than the reported elapsed time.
    IBM DB2 Field Name:
     N/A
  • SUBSYS-CRIT-EXC
    Indicates the number of critical subsystem exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • SUBSYS-WARN-EXCPT
    Indicates the number of warning subsystem exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • SUBSYS-INFO-EXCPT
    Indicates the number of informational subsystem exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • DATABASE-CRIT-EXCPT
    Indicates the number of critical database exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • DATABASE-WARN-EXCPT
    Indicates the number of warning database exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • DATABASE-INFO-EXCPT
    Indicates the number of informational database exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • APPL-CRIT-EXCPT
    Indicates the number of critical application exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • APPL-WARN-EXCPT
    Indicates the number of warning application exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • APPL-INFO-EXCPT
    Indicates the number of informational application exceptions that were detected during the last exception cycle.
    IBM DB2 Field Name:
     N/A
  • MVS-SMF-ID
    Specifies the SMF ID of the MVS system.
    IBM DB2 Field Name:
     N/A
  • DB2-SRC
    Specifies the subsystem recognition character (SRC) for the DB2 subsystem. The SRC must prefix every command that is issued from a console for this subsystem.
    IBM DB2 Field Name:
     N/A
  • DB2-VERSION
    Indicates the DB2 version number.
    IBM DB2 Field Name:
     N/A
  • DB2-ELAPSED-TIME
    Shows how long the DB2 subsystem has been active.
    IBM DB2 Field Name:
     N/A
  • CONN-SYSTEM
    Indicates the connecting system type code.
    IBM DB2 Field Name:
     QWHCATYP
  • CONN-TOKEN
    Specifies the network name, LUNAME, CICS uniqueness value (if RCT coded TOKENE=YES).
    IBM DB2 Field Name:
     N/A
  • DS-DB2-MEMBER
    Specifies the DB2 member name within the DB2 data sharing group.
    IBM DB2 Field Name:
     N/A
  • DS-GROUP-NAME (alias DATASHR-GROUP-NAME)
    Specifies the DB2 data sharing group name. Use the alias name in any IQL WHERE clause.
    IBM DB2 Field Name:
     N/A
  • DS-DATA-MEMS-COUNT
    Shows the count of data collectors that returned data to be included in the aggregated data sharing display. This count represents the number of data sharing group members whose data is included in the aggregated statistics. If either of the following conditions exist, this count is 1:
    • The data is not from a data sharing group member.
    • The data does not show aggregated statistics (not a summary request).
    IBM DB2 Field Name:
     N/A
  • DS-DATA-MEMS-VAR
    Shows the list of data sharing members (SSID list) for which an associated data collector returned data. The returned data is included in the aggregated data sharing display. If either of the following conditions exist, this list has one SSID (local SSID):
    • The data is not from a data sharing group member.
    • The data does not show aggregated statistics (not a summary request).
    This IQL variable is a variable length string value.
    IBM DB2 Field Name:
     N/A
  • DS-DATA-MEMS-LONG
    Shows the list of data sharing members (SSID list) for which an associated data collector returned data. This data is included in the aggregated data sharing display.
    If either of the following conditions exist, this list has one SSID (local SSID):
    • The data is not from a data sharing group member.
    • The data does not show aggregated statistics (not a summary request).
    This IQL variable is a fixed-length string value padded with blanks.
    IBM DB2 Field Name:
     N/A
  • PADDING-FIELD
    Always contains zero. This field is used by archive requests.
    DB2 Name:
    N/A
  • ZERO-TOD
    Always contains zero. This field is used by archive requests.
    DB2 Name:
    N/A
  • ZERO-FIELD
    Always contains zero. This field is used by archive requests.
    DB2 Name:
    N/A
  • DS-DATA-MEMS-LEN
    Shows the data string length of the list of data sharing members (SSID list) for which an associated data collector returned data. This data is included in the aggregated data sharing display.
    IBM DB2 Field Name:
     N/A
  • START-EVENT-TIME
    Specifies the start time for DB2 events that come in pairs of records (begin and end events).
    IBM DB2 Field Name:
     N/A
  • INSIGHT-THREAD-UNIQ
    Identifies the activity that is associated with an instance of a thread, or when thread is reused in CICS and IMS, a logical unit of work.
    Use this field in thread-related requests to logically group thread activity. This field does not have display value.
    IBM DB2 Field Name:
     N/A
  • DB2-STATUS
    Specifies the status of the DB2 subsystem (active or inactive).
    IBM DB2 Field Name:
     N/A
  • DB2-START-TIME
    Indicates the date and time that the DB2 subsystem was started.
    IBM DB2 Field Name:
     N/A
  • DB-NAME
    Specifies the database name for applicable record types. This field is a valid character translation of the DBID field when this field occurs in a record. This field is otherwise unpredictable and is not translated for repeating fields in MIAP-SELECTION and LOCK-SUMMARY.
    IBM DB2 Field Name:
     N/A
  • PAGESET-NAME
    Specifies the page set name for applicable record types. This field is a valid character translation of the OBID or PAGESET-OBID fields when this field occurs in a record. This field is otherwise unpredictable and is not translated for repeating fields in MIAP-SELECTION and LOCK-SUMMARY.
    IBM DB2 Field Name:
     N/A
  • NAT-PROGRAM
    Indicates the NATURAL DB2 program name.
    This field is obsolete.
    IBM DB2 Field Name:
     N/A
  • NAT-LIBRARY
    Indicates the NATURAL DB2 library name.
    This field is obsolete.
    IBM DB2 Field Name:
     N/A
  • NAT-STMT-NUM
    Indicates the NATURAL DB2 statement number.
    This field is obsolete.
    IBM DB2 Field Name:
     N/A
  • TRUSTEDCONTENT-OFFSET
    Specifies the offset from the beginning of QWHC to the trusted context name, when the application is running in a trusted context. This field provides no practical tuning purposes. The monitor uses this field to locate the long name in a DB2 trace record. Use this field to verify that DB2 provides a long name in the trace record.
    IBM DB2 Field Name:
     QWHCTCXT_OFF
  • TRUSTEDCONTEXT-VAR
    Indicates the trusted context name. This field varies in length and contains the complete name. 
    IBM DB2 Field Name:
     QWHCTCXT_D
  • TRUSTEDCONTEXT-LEN
    Specifies the length of trusted context name.
    IBM DB2 Field Name:
     QWHCTCXT_LEN
  • TRUSTEDCONTEXT-LONOG
    Specifies the trusted context name. 
    This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWHCTCXT_VAR
  • ROLE-NAME-OFFSET
    Specifies the offset from the beginning of QWHC to the role name associated with the authorization ID, when the application is running in a trusted context. This field provides no practical tuning purposes. The monitor uses this field to locate the long name in a DB2 trace record. Use this field to verify that DB2 provides a long name in the trace record.
    IBM DB2 Field Name:
     QWHCROLE_OFF
  • ROLE-NAME-VAR
    Indicates the role name that is associated with the authorization ID. 
    This field varies in length and contains the complete name.
    IBM DB2 Field Name:
     QWHCROLE_D
  • ROLE-NAME-LEN
    Specifies the length of the role name.
    IBM DB2 Field Name:
     QWHCROLE_LEN
  • ROLE-NAME-LONG
    Specifies the role name that is associated with the authorization ID. 
    This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWHCROLE_VAR
  • ORIG-APP-USER-OFFSET
    Indicates the offset from the beginning of QWHC to the original application user ID. This field provides no practical tuning purposes. The monitor uses this field to locate the long name in a DB2 trace record. Use this field to verify that DB2 provides a long name in the trace record.
    IBM DB2 Field Name:
     QWHCOAUD_OFF
  • ORIG-APP-USER-VAR
    Specifies the original application user ID. This field varies in length and contains the complete name.
    IBM DB2 Field Name:
     QWHCOAUD_D
  • ORIG-APP-USER-LEN
    Specifies the length of the original application user ID.
    IBM DB2 Field Name:
     QWHCOAUD_LEN
  • ORIG-APP-USER-LONG
    Specifies the original application user ID. This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWlHCOAUD_VAR
  • CORR-TOKEN-OFFSET
    Specifies the offset from the beginning of QWHC to the extended correlation token field. This field provides no practical tuning purposes. The monitor uses this field to locate the long name in a DB2 trace record. Use this field to verify that DB2 provides a long name in the trace record.
    IBM DB2 Field Name:
     QWHCCTKN_OFF
  • CORR-TOKEN-VAR
    Specifies the extended correlation token value. Requester applications in a distributed environment can provide a token value to identify the connecting application. If the appropriate information is provided, this field contains a correlation token. Use this token to correlate work at the remote system with work performed at the DB2 subsystem. 
    The correlation token contains the following components, which are separated by a period:
    • 3 to 39 character IP address
    • 1 to 8 character port address
    • 12 character unique identifier
    This field varies in length and contains the complete name.
    IBM DB2 Field Name:
     QWHCCTKN_D
  • CORR-TOKEN-LEN
    Indicates the length of the extended correlation token value.
    IBM DB2 Field Name:
     QWHCCTKN_LEN
  • CORR-TOKEN-LONG
    Specifies the extended correlation token value. A requester application in a distributed environment can provide a token value to identify the connecting application. If the appropriate information is provided, this field contains a correlation token. Use this token to correlate work at the remote system with work performed at the DB2 subsystem.
    The correlation token contains the following components, which are separated by a period:
    • 3 to 39 character IP address
    • 1 to 8 character port address
    • 12 character unique identifier
    This field contains the complete field name, expanded to the maximum length.
    IBM DB2 Field Name:
     QWHCCTKN_VAR
  • DB2-RLSE-NUM
    Indicates the DB2 version and release in
    w
    .
    r
    format.
    IBM DB2 Field Name:
     N/A
  • NULLS-31-FIELDS
    Contains Y if the DB2 data is from a release before version 3. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-41-FIELDS
    Contains Y if the DB2 data is from a release before version 4. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-51-FIELDS
    Contains Y if the DB2 data is from a release before version 5. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-61-FIELDS
    Contains Y if the DB2 data is from a release before version 6. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-71-FIELDS
    Contains Y if the DB2 data is from a release before version 7. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-81-FIELDS
    Contains Y if the DB2 data is from a release before version 8. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-91-FIELDS
    Contains Y if the DB2 data is from a release before version 9. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-10-FIELDS
    Contains Y if the DB2 data is from a release before version 10. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-11-FIELDS
    Contains Y if the DB2 data is from a release before version 11. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-12-FIELDS
    Contains Y if the DB2 data is from a release before version 12. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-13-FIELDS
    Contains Y if the DB2 data is from a release before version 13. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • NULLS-14-FIELDS
    Contains Y if the DB2 data is from a release before version 14. Otherwise, this field contains N.
    IBM DB2 Field Name:
     N/A
  • ACCT-ZERO
    Always contains zero. Used by archive requests.
    IBM DB2 Field Name:
     N/A
  • STATS1-ZERO
    Always contains zero. Used by archive requests.
    IBM DB2 Field Name:
     N/A
  • STATS2-ZERO
    Always contains zero. Used by archive requests.
    IBM DB2 Field Name:
     N/A
  • CICS-TRANSID
    Contains the four-character CICS transaction ID for CICS-related data.
    IBM DB2 Field Name:
     Derived from QWHCCV
  • IMS-PST-NUM
    Contains the four-character PST number for IMS-related data.
    IBM DB2 Field Name:
     Derived from QWHCCV
  • IMS-PSB-NAME
    Contains the eight-character PSB name for IMS-related data.
    IBM DB2 Field Name:
     Derived from QWHCCV
  • ARC-EXTENDED-CONN-TYPE
    Contains an extended description of the type of connection used by the thread that produced the trace data, for example:
    • TSO ONLINE/BATCH
    • DB2 CALL ATTACH
    • DL/I BATCH
    • CICS ATTACH
    • IMS ATTACH BMP
    • IMS ATTACH MPP
    • SYSTEM-DIRECTED ACCESS
    • APPLIC-DIRECTED ACCESS
    • IMS CONTROL REGION
    • IMS TRANSACTION BMP
    • DB2 UTILITIES
    • RRSAF ATTACH
    IBM DB2 Field Name:
     Derived from QWHCATYP
  • MVS-SYSTEM-ID
    Identifies the four character MVS system ID.
    IBM DB2 Field Name:
     QWHSSID
  • ACCOUNTING-ACE
    Identifies the ACE of the agent that initiated the accounting interval. If the record was written outside of the accounting interval, this field contains a 0. 
    This field has the following uses:
    • Correlation to QWHSACE for non-rollup IFCID 3 records
    • Correlate to QWARACE for DDF/RRSAF rollup accounting
    IBM DB2 Field Name: 
    QWHCAACE
  • IWHDUSE
    Identifies the CPU time of the currently dispatched execution unit consumed on an IBM specialty engine.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHUSE
  • EVENT-SE
    Identifies the CPU time used only on a zIIP engine between the start and end of an event.
    The zIIP CPU time is normalized.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     Delta of QWHUSE values
  • ENDUSER-TRANSACTION-OFF
    Specifies the offset from the beginning of data section to the variable or long field name when QWHCEUTX is truncated. 
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHCEUTX_OFF
  • ENDUSER-TRANSACTION-VAR
    Identifies the transaction or application is running. If the client did not provide this information, this field is blank. 
    This variable length field contains the complete name.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHCEUTX_D
  • ENDUSER-TRANSACTION-LEN
    Identifies the length of the end-user transaction name.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHCEUTX_LEN
  • ENDUSER-TRANSACTION-LONG
    Identifies the transaction or application is running. If the client did not provide this information, this field is blank. 
    This field contains the complete field name, expanded to the maximum length.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHCEUTX_VAR
  • ENDUSER-WORKSTATION-OFF
    Specifies the offset from the beginning of the data section to the variable or long field name when QWHCEUWN is truncated.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHCEUWN_OFF
  • ENDUSER-WORKSTATION-VAR
    Identifies the end-user workstation. If the client did not provide this information, this field is blank.
    This variable length field contains the complete name.
    This field is new with DB2 11.
    IBM DB2 Field Name: 
    QWHCEUWN_D
  • ENDUSER-WORKSTATION-LEN
    Identifies the length of the end-user workstation name.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHCEUWN_LEN
  • ENDUSER-WORKSTATION-LONG 
    Identifies the end-user workstation. If the client did not provide this information, this field is blank.
    This field contains the complete field name, expanded to the maximum length.
    This field is new with DB2 11.
    IBM DB2 Field Name:
     QWHCEUWN_VAR
  • FUNCTION-LEVEL
    Indicates the DB2 function level in the form of V
    xx
    R
    y
    M
    zzz
    .
    This field is new with DB2 12.
    IBM DB2 Field Name:
     QWHS_MOD_LVL
  • COMPAT-COUNT
    Specifies the number of trace record internal changes that are compatible with the original trace record layout.
    This field is new with DB2 12.
    IBM DB2 Field Name:
     QWHS_REC_COMPAT
  • INCOMPAT-COUNT
    Specifies the number of trace record internal changes that are incompatible with the original trace record layout.
    This field is new with DB2 12.
    IBM DB2 Field Name:
     QWHS_REC_INCOMPAT