ATF Queued Summary attributes

Use these attributes to view ATF Queued Summary information.

AuthID1 The Auth ID 1 (Field name: ATQAUTH1).

AuthID2 The Auth ID 2 (Field name: ATQAUTH2).

AuthID3 The Auth ID 3 (Field name: ATQAUTH3).

AuthID4 The Auth ID 4 (Field name: ATQAUTH4).

AuthID5 The Auth ID 5 (Field name: ATQAUTH5).

CAPPlan The server plan name (Field name: ATQPLNAM).

Collection1 The collection 1 (Field name: ATQCOLL1).

Collection2 The collection 2 (Field name: ATQCOLL2).

Collection3 The collection 3 (Field name: ATQCOLL3).

Connection The connection ID (Field name: ATQCONN).

Connection Data The connect data flag (Field name: ATQCOND).

Correlation The correlation ID (Field name: ATQCORR).

Data Sharing Group The Data Sharing Group name (Field name: GROUP).

DB2 Subsystem The Db2 subsystem ID (Field name: DB2ID).

DB2 Version The Db2 version (Field name: DB2VER).

DSG Member Name The Data Sharing Group Member name (Field name: MEMBER).

DSN The ATF VSAM data set name (Field name: ATQCAPDS).

Duration The time limit in 100th of sec (Field name: ATQTMLIM).

End Time The actual ATF end time (Field name: ATQENDTM).

End User Application The client application name (Field name: ATQCLAP).

End User ID The end user ID (Field name: ATQEUID).

End User Workstation The workstation name (Field name: ATQCWSI).

Exclude Appl The exclude client application flag (Field name: ATQEXAP).

Exclude AuthID The exclude auth ID flag (Field name: ATQEXAU).

Exclude Coll The exclude collection flag (Field name: ATQEXCO).

Exclude EndUser The exclude end user ID flag (Field name: ATQEXWU).

Exclude Loc The exclude location flag (Field name: ATQEXLO).

Exclude Package The exclude package flag (Field name: ATQEXPK).

Exclude Plan The exclude plan flag (Field name: ATQEXPL).

Exclude Role The exclude role flag (Field name: ATQEXRO).

Flush Interval The flush interval in 100th of sec (Field name: ATQFLUSH).

Group Scope The group scope flag (Field name: ATQGROP).

Host Variables The host variables flag (Field name: ATQHVAR).

Interval Start The start time of this interval (Field name: TIMESTAMP).

Location1 The location 1 (Field name: ATQLOC1).

Location2 The location 2 (Field name: ATQLOC2).

Lock Data The lock data flag (Field name: ATQLOCK).

MVS System ID The MVS identifier (Field name: MVSID).

Originating System The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters; example, DB91:SYS1:DB2. (Field name: ORIGINNODE).

Owner The logon ID (Field name: ATQUSER).

Package1 The package 1 (Field name: ATQPACK1).

Package2 The package 2 (Field name: ATQPACK2).

Package3 The package 3 (Field name: ATQPACK3).

Package4 The package 4 (Field name: ATQPACK4).

Package5 The package 5 (Field name: ATQPACK5).

Plan1 The plan 1 (Field name: ATQPLAN1).

Plan2 The plan 2 (Field name: ATQPLAN2).

Plan3 The plan 3 (Field name: ATQPLAN3).

Plan4 The plan 4 (Field name: ATQPLAN4).

Plan5 The plan 5 (Field name: ATQPLAN5).

Queued Time1 The STCK part 1 of queue entry (Field name: ATQTIME1).

Queued Time2 The STCK part 2 of queue entry (Field name: ATQTIME2).

Reason Code The ATFQSUM reason code. (Field name: ATQRSNCD). Possible values are:
DataReturned=0
The queued ATFs are returned.
MissingOMVT=1
Internal error.
MissingATFCVT=2
Internal error.
ENQFailed=3
Internal error.
NoDatainQueue=4
No queued ATFs exist.
DataTruncated=5
Truncated data is displayed.
NoUserData=6
There is no ATF for the user ID or for Db2.
Timeout=99
Data collection error.
Unknown=100
Internal error.

Return Code The ATFQSUM return code. (Field name: ATQRETCD). If the return code is 8 (RC=8), restart OMPE. If restarting OMPE does not resolve the issue, contact IBM support.

Routine1 The routine name 1 (Field name: ATQR1NM).

Routine2 The routine name 2 (Field name: ATQR2NM).

Routine Count The number of routines (Field name: ATQRTNC).

Scan Data The scan data flag (Field name: ATQSCAN).

Scheduled Start The scheduled start time (Field name: ATQSCHDS).

Schema1 The routine schema 1 (Field name: ATQR1SC).

Schema2 The routine schema 2 (Field name: ATQR2SC).

SQL Data The SQL data flag (Field name: ATQSQLD).

SSID The Db2 subsystem ID (Field name: ATQSSID).

Start Time The actual ATF start time (Field name: ATQSTRTM).

Static SQL The static SQL flag (Field name: ATQSSQL).

Term Reason The termination reason (Field name: ATQTERM). Possible values are:
  • NormalExit=00
  • PlanNotFound=01
  • TraceNotAuthed=02
  • PlanNotAuthed=03
  • ConnNotAuthed=04
  • AT#WorkExhausted=05
  • CollectorAbend=06
  • Db2Termed=07
  • IDBACKMaxed=08
  • Mon2NotAuthed=09
  • TraceStopped=0A
  • AllOPxInuse=0B
  • CafRelMismatch=0C
  • AllocDSNFailed=0D
  • OpenDSNFail=0E
  • GetStorageFail=0F
  • DSNNearFull=10
  • Unknown=FF

Thread Data The thread data flag (Field name: ATQTHRD).

Trace Rec Captured The number of trace record captured (Field name: ATQTRWR).

Trace Status The status of the queued ATF entry (Field name: ATQSTAT). Possible values are:
  • PENDING=P
  • EXECUTING=E
  • COMPLETE=C
  • FAILED=F
  • SCHEDULED=S
  • OBSOLETE=O

Trace Rec Lost The number of lost trace records (Field name: ATQTRLV).

UOW Rec Captured The number of unit of work captured (Field name: ATQUWWR).

UOW Rec Lost The number of lost UOW records (Field name: ATQUWLV).