Aggregated Accounting attributes

Use these attributes to view information about aggregated accounting suspensions.

Lock (Db2+IRLM) Event The number of wait trace events processed for waits for local contention for locks aggregated by connection type (Field name: SWACARNL).

Lock (Db2+IRLM) Time The accumulated wait time due to local contention for locks aggregated by connection type (Field name: SWACAWTL).

Latch (Db2+IRLM) Time The accumulated wait time due to latch contention aggregated by connection type (Field name: SWACAWLH).

Latch (Db2+IRLM) Event The number of wait trace events processed for waits for latch contention aggregated by connection type (Field name: SWACARLH).

Synchronous I/O Event The total number of synchronous I/O suspensions aggregated by connection type (Field name: SDIOSUSC).

Synchronous I/O Time The I/O elapsed time accumulated due to synchronous I/O suspensions. Db2 calculates this value by subtracting the store clock time when an agent begins waiting for a synchronous I/O from the time the agent is resumed. Value is aggregated by connection type. (Field name: SDIOSUST).

Database I/O Time The accumulated I/O elapsed wait time for database I/O done under this connection type (Field name: SWACAWTI).

Database I/O Event The number of wait trace events processed for waits for database I/O under this connection type (Field name: SWACARNE).

Log Write I/O Event The number of wait trace events that were processed for waits for log read I/O aggregated by connection type (Field name: SWACARLG).

Log Write I/O Time The accumulated wait time for log write I/O aggregated by connection type (Field name: SWACAWLG).

Other Read I/O Time Other accumulated wait time for read I/O aggregated by connection type (Field name: SWACAWTR).

Other Read I/O Event Other number of wait trace events processed for waits for read I/O aggregated by connection type (Field name: SWACARNR).

Other Write I/O Event Other number of wait trace events processed for waits for write I/O aggregated by connection type (Field name: SWACARNW).

Other Write I/O Time Other accumulated wait time for write I/O aggregated by connection type (Field name: SWACAWTW).

Service Task Switch Time The accumulated waiting time due to a synchronous execution unit switching to Db2 services from the thread aggregated by connection type (Field name: SDSTSUST).

Service Task Switch Event The total number of suspensions due to a synchronous execution unit switching to Db2 services from the thread aggregated by connection type (Field name: SDSTSUSC).

Update Commit Event The number of wait trace events processed for waits for synchronous execution unit switching for COMMIT or ABORT aggregated by connection type (Field name: SWACARNS).

Update Commit Time The accumulated wait time because of a synchronous execution unit switch for Db2 COMMIT, ABORT, or DEALLOCATION processing aggregated by connection type (Field name: SWACAWTE).

Open/Close Data Set Time The accumulated wait time for a synchronous execution unit switch to the Db2 OPEN/CLOSE data set service or the HSM recall service aggregated by connection type (Field name: SWAXOCSE).

Open/Close Data Set Event The number of wait trace events processed for waits for the synchronous execution unit switching to the OPEN/CLOSE service aggregated by connection type (Field name: SWAXOCNS).

SYSLGRNG Event The number of wait trace events processed for waits for synchronous execution unit switching to the SYSLGRNG recording service aggregated by connection type (Field name: SWAXSLNS).

SYSLGRNG Time Accumulated wait time for a synchronous execution unit switch to the Db2 SYSLGRNG recording service aggregated by connection type (Field name: SWAXSLSE).

Extend/Delete/Define Data Set Time The accumulated wait time for a synchronous execution unit switch to the Db2 data space manager services, which include define data set, extend data set, delete data set, reset data set, and VSAM catalog access aggregated by connection type (Field name: SWAXDSSE).

Extend/Delete/Define Data Set Event The number of wait trace events processed for waits for synchronous execution unit switching to the data space manager service tasks aggregated by connection type (Field name: SWAXDSNS).

Other Service Event The number of wait trace events processed for waits for synchronous execution unit switching to other service tasks aggregated by connection type (Field name: SWAXOTNS).

Other Service Time The accumulated wait time for a synchronous execution unit switch to other Db2 service tasks aggregated by connection type (Field name: SWAXOTSE).

Archive Log Quiesce Time The waiting time caused by processing ARCHIVE LOG(QUIESCE) commands aggregated by connection type (Field name: SWACALOG).

Archive Log Quiesce Event Events due to processing ARCHIVE LOG MODE(QUIESCE) commands aggregated by connection type (Field name: SWACALCT).

Archive Log Read Event Events due to processing ARCHIVE LOG READ commands aggregated by connection type (Field name: SWACANAR).

Archive Log Read Time The waiting time caused by processing ARCHIVE LOG READ commands aggregated by connection type (Field name: SWACAWAR).

Drain Lock Time The waiting time caused by drain lock processing aggregated by connection type (Field name: SWACAWDR).

Drain Lock Event Events due to drain lock processing during the execution of the package or DBRM aggregated by connection type (Field name: SWACARND).

Claim Release Event Claim release Event aggregated by connection type (Field name: SWACARNC).

Claim Release Time Claim release Time aggregated by connection type (Field name: SWACAWCL).

Page Latch Time The accumulated wait time because of page latch contention aggregated by connection type (Field name: SWACAWTP).

Page Latch Event The number of wait trace events processed for page latch contention aggregated by connection type (Field name: SWACARNH).

Stored Procedures Event The number of times an SQL call statement had to wait for an available TCB before the stored procedure could be scheduled. Aggregated by connection type (Field name: SWACCANM).

Stored Procedures Time The total elapsed time spent waiting for an available TCB before the stored procedure could be scheduled. Aggregated by connection type (Field name: SWACCAST).

Notify Messages Time The accumulated elapsed wait time caused by suspension for sending messages to other members in the data sharing group. Aggregated by connection type (Field name: SWACAWTG).

Notify Messages Event The number of wait trace events processed for waits for sending messages to other members in the data sharing group. Aggregated by connection type (Field name: SWACARNG).

Global Contention Event The number of suspensions caused by global lock contention. Aggregated by connection type (Field name: SDGCSUSC).

Global Contention Time The total accumulated waiting time caused by the suspension of IRLM lock requests due to global lock contention in a data sharing environment that requires intersystem communication to resolve. Aggregated by connection type (Field name: SDGCSUST).

L-locks Time The accumulated global contention wait time for all L-locks. Aggregated by connection type (Field name: SDLKSUST).

L-locks Event The number of global contention waits for all L-locks. Aggregated by connection type (Field name: SDLKSUSC).

Parent (DB, TS, TAB, PART) Event The number of wait trace events processed for waits for global lock contention for parent L-locks. Aggregated by connection type (Field name: SWACARNJ).

Parent (DB, TS, TAB, PART) Time The accumulated wait time due to global contention for parent L-locks. Aggregated by connection type (Field name: SWACAWTJ).

Child (Page, row) Time The accumulated wait time due to global contentionfor child L-Locks. Aggregated by connection type (Field name: SWACAWTK).

Child (Page, row) Event The number of global contention wait events for child L-locks. Aggregated by connection type (Field name: SDLCSUSC).

Other Event L-locks The number of global contention wait events for other L-locks. Aggregated by connection type (Field name: SDLOSUSC).

Other Time L-locks The accumulated wait time due to global contention for other L-locks. Aggregated by connection type (Field name: SWACAWTM).

P-locks Time The accumulated global contention wait time for all P-locks. Aggregated by connection type (Field name: SDPLSUST).

P-locks Event The number of global contention waits for all P-locks. Aggregated by connection type (Field name: SDPLSUSC).

Pageset or Partition Event The number of global contention waits for pageset and partition P-locks. Aggregated by connection type (Field name: SDPSSUSC).

Pageset or Partition Time The accumulated wait time due to global contention for page set or partition P-locks. Aggregated by connection type (Field name: SWACAWTN).

Page Time The accumulated wait time due to global contention for page P-locks. Aggregated by connection type (Field name: SWACAWTO).

Page Event The number of global contention waits for page P-locks. Aggregated by connection type (Field name: SDPPSUSC).

Other Event The number of global contention waits for other P-locks. Aggregated by connection type (Field name: SDPOSUSC).

Other Time P-locks The accumulated wait time due to global contention for other P-locks. Aggregated by connection type (Field name: SWACAWTQ).

Commit Phase 1 Write I/O Time The accumulated wait time for commit phase 1 database write I/O completion. Aggregated by connection type (Field name: SWAXAWFC).

Commit Phase 1 Write I/O Event The number of wait trace events processed for FORCE-AT-COMMIT. Aggregated by connection type (Field name: SWAXFCCT).

Asynchronous IXL requests Event The number of wait trace events processed for asynchronous IXLCACHE/IXLFCOMP invocations. Aggregated by connection type (Field name: SWAXIXLE).

Asynchronous IXL Requests Time The waiting time of the asynchronous IXL requests aggregated by connection type (Field name: SQWAXIXL).

TCP/IP LOB XML Time The number of wait trace events that were processed for waits for TCP/IP LOB or XML materialization. Aggregated by connection type (Field name: SWACALBC).

TCP/IP LOB XML Event Accumulated wait time for tcp/ip lob or xml materialization. Aggregated by connection type. (Field name: SWACALBW).

Autonomous Procedures Event The number of autonomous procedures that were executed. Aggregated by connection type (Field name: SWACACNT).

Autonomous Procedures Time The accumulated wait time for autonomous procedures to complete. Aggregated by connection type (Field name: SWACWAIT).

Accelerator Time The accumulated wait time for requests to an accelerator. Aggregated by connection type (Field name: SWACAACW).

Accelerator Event The number of wait trace events that were processed for requests to an accelerator. Aggregated by connection type (Field name: SWACAACC).

Connection type The connection name for which Accounting data has been aggregated (Field name: QW0369CN).

Quantity The number of parallel child agents, Accounting intervals, or autonomous procedures rolled up for all threads of the connection type (Field name: SWACPCNT).

Class 1 Elapsed The class 1 elapsed time aggregated by connection type (Field name: SDRECETT).

Class 1 CPU The class 1 CPU time aggregated by connection type (Field name: SDCPUT).

Class 1 SE CPU The sum of several accumulated CPU times consumed while running on an IBM specialty engine in all environments and aggregated by connection type (Field name: SWACC1Z).

Class 2 Elapsed The class 2 elapsed time aggregated by connection type (Field name: SDDB2ETT).

Class 2 CPU The class 2 CPU time aggregated by connection type (Field name: SDDBCPUT).

Class 2 SE CPU The accumulated and consumed class 2 time on an IBM specialty engine aggregated by connection type (Field name: SWACC2Z).

Class 3 Susp The waiting time for all types of class 3 suspensions aggregated by connection type (Field name: SDTSUST).

Class 2 Not Acc The time not accounted in Db2 and aggregated by connection type (Field name: SDNOTACC).

Elapsed Outside Db2 Class 2 The elapsed time outside Db2 (Class 2) aggregated by connection type (Field name: SDTTOTOD).

Non-nested in Application Class 1 The non-nested class 1 elapsed time of the allied agent aggregated by connection type (Field name: SDNNNET1).

Non-nested in Db2 Class 2/3 The accumulated elapsed time in Db2 aggregated by connection type (Field name: SWACASC).

Stored Proc in Application Class 1 The total elapsed time spent by the allied agent in stored procedures aggregated by connection type (Field name: SDELTSP1).

Stored Proc in Db2 Class 2/3 The total elapsed time that the allied agent spent when running SQL in the stored procedures or WLM address space aggregated by connection type (Field name: SDELTSP2).

UDF in Application Class 1 The total elapsed time spent in user-defined function (UDF) requests processed in a Db2 stored procedure or WLM address space aggregated by connection type (Field name: SWAELUD1).

UDF in Db2 Class 2/3 The total elapsed time that is spent executing SQL using user-defined function (UDF) requests that are processed in a Db2 stored procedure or WLM address space. Aggregated by connection type (Field name: SWAELUD2).

Trigger Class 1 The total elapsed time spent by the allied agent in triggers aggregated by connection type (Field name: SDTRET).

CP CPU Time Outside Class 2 The CP CPU time outside Db2 (Class 2) aggregated by connection type (Field name: SDCPUODB).

Agent in Application Class 1 It comprises the class 1 CPU time of the allied agent, which may include the accumulated class 1 CPU time for processing stored procedures, user-defined functions, and triggers if present. Aggregated by connection type (Field name: SDAGENT1).

Agent in Db2 Class 2/3 It comprises the class 2 CPU time of the allied agent. This time includes the accumulated class 2 CPU time for processing stored procedures, user-defined functions, and triggers, if present. CPU time for processing parallel tasks is not charged to this counter. Aggregated by connection type (Field name: SDAGENT2).

Agent Non-nested in Application Class 1 The class 1 CPU time of the non-nested activity of the allied agent aggregated by connection type (Field name: SDNNEST1).

In Db2 Non-nested Class 2/3 The accumulated CPU time aggregated by connection type (Field name: SWACAJST).

Non-nested outside DB2 Class 2 The class 2 CP CPU time of the non-nested activity of the allied agent outside Db2 aggregated by connection type (Field name: SDTTCBOD).

Stored Procedure in Application Class 1 An accumulated and consumed time for stored procedures aggregated by connection type that consists of following parts: The CPU time accumulated in Db2 for processing SQL CALL statements in the stored procedures or WLM address space. This time is only calculated if accounting class 1 is active. The accumulated CPU time consumed when running stored procedure requests on the main application execution unit. This time does not include CPU time consumed on an IBM specialty engine. As these stored procedures run entirely within Db2, this time represents class 1 and class 2 time (Field name: SDCPUSP1).

Stored Procedure in Db2 Class 2/3 An accumulated and consumed time for stored procedures aggregated by connection type that consists of the following information: The CPU time accumulated in Db2 for processing SQL statements issued by stored procedures processed in a Db2 stored procedure or WLM address space. This time is only calculated if accounting class 2 is active. In Db2 time needed to connect and disconnect the SP task for non-SQL stored procedures. SQL procedure times are included in this time if the SQL procedure was called on a nested task and was not invoked by the main application execution unit. CPU time that is consumed when running stored procedure requests on the main application execution unit (Field name: SDCPUSP2).

UDF in application CPU Class 1 The accumulated CPU time consumed executing user-defined functions aggregated by connection type. This time does not include CPU consumed on an IBM specialty engine. It consists of following parts: - The accumulated CPU time used to satisfy UDF requests processed in a Db2 stored procedure or WLM address space. This time is only calculated if accounting class 1 is active. - The accumulated CPU time consumed executing user-defined functions on the main application execution unit. This time represents class 1 and class 2 time, because these UDFs run entirely within Db2. (Field name: SWACPUD1).

UDF in Db2 CPU Class 2/3 The accumulated CPU time consumed executing user-defined functions. This time does not include CPU time consumed on an IBM specialty engine. It consists of following parts: - The accumulated CPU time consumed in Db2 when processing SQL statements that were issued by UDFs in a Db2 stored procedure or WLM address space. This time also includes the Db2 time required to connect or disconnect the UDF task. It is only calculated if accounting class 2 is active. - The accumulated CPU time consumed executing user-defined functions on the main application execution unit. This time represents class 1 and class 2 time, because these UDFs run entirely within Db2. (Field name: SWACPUD2).

Trigger CPU Time The accumulated CPU time consumed while executing under the control of triggers aggregated by connection type. For triggers there is no distinction between class 1 and class 2 CPU time. All processing controlled by a trigger is within Db2 (Field name: SDTRCP).

Waiting Time in Db2 Class 2/3 The waiting time in Db2 (Class 2/3) aggregated by connection type (Field name: SDTWTDB).

Agent Susp Time in Db2 Class 2/3 The waiting time of the allied agent for all types of class 3 suspension aggregated by connection type. This counts class 3 suspension time within nested activity. Suspension time of parallel tasks in query or utility parallelism is not included (Field name: SDTCBCL3).

Suspensions Class 3 Events The total number of class 3 suspensions aggregated by connection type (Field name: SDTSUSC).

Commits The number of successful phase 2 or single-phase commit (sync) requests. Aggregated by connection type (Field name: SWACCOMM).

Rollback The number of rollback requests aggregated by connection type (Field name: SWACABRT).

Log records written The number of log records written. Aggregated by connection type (Field name: SWACLRN).

Log record bytes The total number of bytes of log records written. Aggregated by connection type (Field name: SWACLRAB).

Current workfile blocks The current workfile blocks aggregated by connection type (Field name: SWACWCUR).

Maximum workfile blocks The maximum workfile blocks aggregated by connection type (Field name: SWACWMAX).

Non stored procedures The number of Db2 entry and exit events processed by the allied address space. Aggregated by connection type (Field name: SWACARNA).

Stored procedures The number of sql entry or exit events performed by stored procedures. Aggregated by connection type (Field name: SWACSPNE).