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