ATF Wait Data attributes

Use these attributes to view ATF Wait Data information.

Buffer Writes The number of buffer writes. (Field name: QW0058WT).

Claim Wait The accumulated wait time for claim counts. (Field name: QW0058CL).

Data Sharing Group The Data Sharing Group (DSG) name.

DB2 Subsystem The Db2 subsystem ID.

DB2 Version The Db2 version.

Drain Lock Wait The accumulated wait time for drain locks. (Field name: QW0058DA).

DSG Member Name The DSG member name.

Filler1 The pad field. (Field name: FILLER01).

Get Pages The number of Getpage operations. (Field name: QW0058GP).

Global-Pageset L-Lock The accumulated wait time for global Pageset or Partition L-locks. (Field name: ATDSQWTN).

Global Child L-Lock The accumulated wait time for global child L-locks. (Field name: ATDSQWTC).

Global Other L-Lock The accumulated wait time for global other L-locks. (Field name: ATDSQWTM).

Global Other P-Lock The accumulated wait time for global other P-locks. (Field name: ATDSQWTQ).

Global Page P-Lock The accumulated wait time for global page P-locks. (Field name: ATDSQWTO).

Global lock Wait The accumulated wait time for global locks. (Field name: QW0058GL).

Has Wait Data Flag set to Y if QW0058 has wait data. (Field name: ATDSQFLW).

inDb2 CPU The accumulated in-Db2 CPU time. (Field name: QW0058CP). This time includes CPU time that was consumed on an IBM specialty engine.

inDb2 ETime The accumulated in-Db2 elapsed time. (Field name: QW0058ET).

Index Scans The number of index scans. (Field name: QW0058IS).

Interval Start The start time of this interval.

Latch Wait Accumulated wait time for latches. (Field name: QW0058LH).

Lock Wait The accumulated wait time for locks. (Field name: QW0058LK).

Log Write Wait The accumulated wait time for log writers. (Field name: QW0058LG).

MVS System ID The MVS identifier.

Originating System The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Page Latch Wait The accumulated wait time for page latches. (Field name: QW0058PA).

Parall Groups The number of parallel groups created. (Field name: QW0058PG).

Read Wait The accumulated wait time for read activity by another thread. (Field name: QW0058OR).

RID Db2Limit The number of times that the record ID (RID) list was not used because the number of RIDs would have exceeded Db2 limits. (Field name: QW0058RL).

RID Storage The number of times that a RID list was not used because there is not enough storage available to hold the list of RIDs. (Field name: QW0058RS).

Rows Examined The number of rows examined. (Field name: QW0058ER).

Rows Processed The number of rows processed. (Field name: QW0058PO).

Scan Data Count The number of times the data was scanned. (Field name: ATDSQXCT).

Sorts The number of sorts. (Field name: QW0058ST).

Statement ID The statement identifier. (Field name: QW0058TK).

Statement Type The type of statement. (Field name: ATDSQWTY).

Sync Reads The number of synchronous buffer reads. (Field name: QW0058SR).

Sync Wait The accumulated wait for synchronous I/O. (Field name: QW0058SI).

Tablespace Scans The number of table space scans. (Field name: QW0058TB).

Wait Pipe The accumulated wait time for pipes. (Field name: QW0058PW).

Wait UnitSwitch The accumulated wait time for synchronous execution unit switches. (Field name: QW0058EU).

Wait Parallel Query The accumulated time spent waiting for parallel queries to synchronize between parent and child tasks. (Field name: ATDSQWPQ).

Write Wait The accumulated wait time for write activity by another thread. (Field name: QW0058OW).