---
title: "SMF 101-003 DB2 Accounting"
slug: "smf-101-003-db2-accounting"
updated: 2024-05-15T07:41:17Z
published: 2024-05-15T07:41:17Z
canonical: "docs.zetaly.io/smf-101-003-db2-accounting"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zetaly.io/llms.txt
> Use this file to discover all available pages before exploring further.

# SMF 101-003 DB2 Accounting

## Introduction

CSV I239 for SMF 101 IFCID 239, including PROD section and General Package accounting section. SMF 101-239 was created by IBM as an overflow of the SMF 101-003, to contain additional data. They share the same header and are link by the exact same timestamp.

## Fields

Stored in dbaData

| SMF Field | DB Column name | Description | Unit |
| --- | --- | --- | --- |
|  | recType | Value is always 0 |  |
| QWACBSC | startTime | Beginning store clock value |  |
| QWACESC | endTime | Ending store clock value |  |
| SM101SID | sid |  |  |
| SM101SSI | db2Id | Subsystem ID |  |
| QWHCATYP | sourceType | Type of connecting system |  |
| QWHCEUTX | trx | Transaction name for the user |  |
| QWHCAID | racfUser | Authorization ID |  |
| QWACWLME | wlmClass | MVS workload manager service class name |  |
| QWHCCN | connection | Connection name |  |
| QWHCPLAN | planName | Plan name |  |
| QWHCCN | cicsName | If sourceType equal 'CICS' fill with connection value |  |
| QWHCCV QWHCCN | jobName | - If sourceType equal 'TSO' or 'DB2 CALL' or 'DB2 UTIL' fill with correlationId value - If sourceType equal 'IMS DLI' fill with connection value |  |
| QWHCCV | psbName | If sourceType equal 'IMS BMP' or 'IMS MPP' or 'IMS DLI' or 'IMS TRX' or 'IMS CONTROL' fill with correlationId value without 4 first character |  |
| QWHCCN | imsid | If sourceType equal 'IMS BMP' or 'IMS MPP' or 'IMS DLI' or 'IMS TRX' or 'IMS CONTROL' fill with 4 first character of connection value |  |
| QWHSLUNM | luName | LU name |  |
| QWHSNID | netId | Network ID |  |
| QWHSLUUV | uniqueId | Uniqueness value |  |
| QWACRINV | acctReason | Reason accounting is invoked |  |
| QWACFLGS | flags | Flags |  |
| QWHSACE | taskAddress | Ace address dispatch unit address |  |
| QWHCEUID | endUserId | The end user's userID at the user's workstation |  |
| QWHCCV | correlationId | Correlation ID value |  |
| QWHCCTKN_D | correlToken | Use if QWHCCTKN_Off |  |
| QWACPACE | correlAddress | For non-rollup parent record = 0. For non-rollup child agent record = QWHSACE of parent record. For parallel query rollup record = QWHSACE of parent record. For autonomous procedures rollup record = QWHS of parent record. For DDF/RRSAF rollup record = No meaning |  |
| QWHCOPID | operatorId | Original primary authorization ID |  |
| QWHCTCXT | trustedCtx | Trusted context name |  |
| QWHCROLE | roleName | Role name associated with authid |  |
| QWHSLOCN | localName | Local location name |  |
| QWHDRQNM | ipAddr | Long name version of the distributed transaction requestor location |  |
| QWHDSVNM | computerName | SRVNAM parameter of DRDA EXCSAT command |  |
| QWHDPRID | clientProduct | PRDID parameter of DRDA ACCRDB command |  |
| QWHAMEMN | memberName | Db2 member name |  |
| QWHADSGN | groupName | Db2 data sharing group name |  |
| QWHCEUWN | workstation | Workstation name for the user |  |
| QWHCEUTX | pgmName | If sourceType equal 'DRDA' fill with trx value or correlationId if trx is empty |  |
| QTXARLID | rlfTableId | Resource Limit Table ID |  |
| QWHCCV | pstNumber | If sourceType equal 'IMS BMP' or 'IMS MPP' or 'IMS DLI' or 'IMS TRX' or 'IMS CONTROL' fill with 4 first character of correlationId value |  |
| QWACESC - QWACBSC | respTime | Shows the duration of the accounting interval. It includes the time spent in DB2 and time spent in the front end |  |
|  | db2Duration | sqlDuration + spDuration + udfDuration + triggDuration | second |
| QWACASC | sqlDuration | Accumulated elapsed time in db2 | second |
| QWACSPEB+ELAP | spDuration | The total elapsed time spent executing SQL via stored procedure requests processed in a DB2 stored procedure WLM address space | second |
| QWACUDEB+ELAP | udfDuration | The total elapsed time spent executing SQL via UDF requests processed in a DB2 stored procedure/WLM address space | second |
| QWACTRET | triggDuration | The accumulated elapsed time expended executing triggers on the main application execution unit | second |
|  | appSuCount | (row.appCpuTime / 1000.0) * (16000000 / row.cpuFactor) |  |
|  | db2SuCount | (row.db2CpuTime / 1000.0) * (16000000 / row.cpuFactor) |  |
|  | appCpuTime | appCpTime + appSeTime |  |
|  | appCpTime | QWACEJST-QWACBJST + QWACSPCP + QWACUDCP + QWACTRTT |  |
|  | appSeTime | QWACCLS1_ZIIP + QWACSPNF_ZIIP + QWACUDFNF_ZIIP + QWACTRTT_ZIIP |  |
|  | db2CpuTime | db2CpTime + db2SeTime |  |
|  | db2CpTime | QWACAJST + QWACSPTT + QWACUDTT + QWACTRTT |  |
|  | db2SeTime | QWACCLS2_ZIIP + QWACSP_CLS2SE + QWACUDF_CLS2SE + QWACTRTT_ZIIP |  |
|  | sqlCpuTime | QWACAJST + QWACCLS2_ZIIP |  |
|  | spCpuTime | QWACSPTT + QWACSP_CLS2SE |  |
|  | udfCpuTime | QWACUDTT + QWACUDF_CLS2SE |  |
|  | triggCpuTime | QWACTRTT + QWACTRTT_ZIIP |  |
| QWACPCNT | taskCount | Number of parallel/subtasks created |  |
| QWACPKGN | packageCount | Number of packages/DBRMs for which the appropriate traces were active and therfore, package/DBRM level accounting was performed |  |
| QWACSUCV | cpuFactor | This field contains the SU conv factor |  |
| QWHSLUCC | commitCount | Commit count |  |
| QWACCOMM2 | commit2Count |  |  |
| QWACABRT | abortCount | Number of abort requests |  |
| QWACARNA2 | db2EntryCount |  |  |
| QWACLRN | logRecords | log records written |  |
| QTXADEA | deadlockCount | Deadlock count |  |
| QTXASLOC | lockSuspCount | Number of suspends because of lock conflicts |  |
| QTXATIM | timeoutCount | Timeout counts |  |
| QTXALOCK | lockCount | Lock request count |  |
| QTXAUNLK | unlockCount | Unlock request count |  |
| QWACARNE | dbIoCount | Number of wait trace events processed for waits for database I/O under this thread |  |
| QWACAWTI | dbIoWait | Accumulated I/O elapsed wait time for database I/O done under this thread |  |
| QWACARNL | latchCount | Number of wait trace events processed for waits for latch of local contention for locks |  |
| QWACAWTL/LATCH | latchWait | Accumulated wait time due to latch contention or to local contention for locks |  |
| QWACARNR | readIoCount | Number of wait trace events processed for waits for read I/O under another thread |  |
| QWACAWTR | readIoWait | Accumulated wait time for read I/O that is done under a thread other than this one |  |
| QWACARNW | writeIoCount | Number of wait trace events processed for waits for write I/O under another thread |  |
| QWACAWTW | writeIoWait | Accumulated wait time for write I/O that is done under a thread other than this one |  |
| QWACARNS | switchCount | number of wait trace events processed for waits for synchronous execution unit switching for commit/abort |  |
| QWACAWTE | switchWait | Accumulated wait time due to synchronous execution unit switch for DB2 commit, abort, or deallocation processing |  |
| QWACARLG | logIoCount | Number of wait trace events processed for waits for log write I/O |  |
| QWACAWLG | logIoWait | Accumulated wait time for a log write I/O |  |
| QWACALBC | lobCount | Number of wait trace events processed for waits for TCP/IP LOB materialization |  |
| QWACALBW | lobWait | Accumulated wait time for TCP/IP LOB materialization |  |
| QWACARNH | pageLatchCount | Number of wait trace events processed for page latch contention |  |
| QWACAWTP | pageLatchWait | Accumulated wait time due to page latch contention |  |
| QWACARNG | sendCount | Number of wait trace events processed for sending of messages to other members in the data sharing group |  |
| QWACAWTG | sendWait | Accumulated wait time due to sending of messages to other DB2 members in the data sharing group |  |
| QWACARNJ | lLockCount | Number of wait trace events processed for waits for global lock contention for parent L-locks |  |
| QWACAWTJ | lLockWait | Accumulated wait time due to global contention for parent L-locks |  |
| QWACSPNE | spCount | the number of SQL entry/exit events performed by stored procedures |  |
| QWACCAST | spWait | the total elapsed time spent waiting for an available TCB, before the stored procedure could be scheduled |  |
| QWACUDNE | udfCount | the number of SQL entry/exit events performed by user-defined functions |  |
| QWACUDST | udfWait | the total elapsed time spent waiting for an available TCB, before the user-defined function could be scheduled |  |
| QXSELECT | selectCount | Number of selects |  |
| QXINSRT | insertCount | Number of inserts |  |
| QXUPDTE | updateCount | Number of updates |  |
| QXDELET | deleteCount | Number of deletes |  |
| QXDESC | describeCount | Number of describes |  |
| QXPREP | prepareCount | Number of prepares |  |
| QXOPEN | openCount | Number of opens |  |
| QXCLOSE | closeCount | Number of closes |  |
| QXFETCH | fetchCount | Number of fetchs |  |
| QXLOCK | lockTableCount | Number of lock table |  |
| QXCALL | sqlCallCount | Number of SQL CALL statements executed |  |
| QXRWSFETCHD | fetchRows | Number of Rows Fetched |  |
| QXRWSINSRTD | insertRows | Number of Rows Inserted |  |
| QXRWSUPDTD | updatedRows | Number of Rows Updated |  |
| QXRWSDELETD | deleteRows | Number of Rows Deleted |  |
| QBACGET | getPages | Number of get page requests issued |  |
| QBACRIO | synchRead | Number of synchronous read I/O |  |
| QBACSIO | asyncRead | Number of asynchronous pages read by prefetch under the control of the agent |  |
| QBACSWS | pageUpdt | Number of setw issued for system pages |  |
| QBACIMW | syncWrite | Number of immediate (synchronous) write I/O |  |
| QBACSEQ | seqPrefetch | Number of seq prefetch requested |  |
| QBACLPF | listPrefetch | Number of list prefetch requested |  |
| QBACDPF | dynPrefetch | Number of dynamic prefetch requested |  |
| QBACNGT | getPageFail | Number of unsuccessful get page operations due to conditional get page requests |  |
| QTXAPREC | rlfReason | How Limit was determined |  |
| QTXASLMT | rlfSuLimit | Limit in SU's ASUTIME |  |
| QTXACLMT | rlfCpuLimit | Limit in CPU | 16 microseconds |
| QTXACHUS | rlfCpuMax | Highest CPU used | 16 microseconds |
|  | rlfSuMax | (rlfCpuMax / 1000) * (16000000 / cpuFactor) |  |
| QWACFLGS | isRollup | Bit 1 |  |
| QWACRINV | isAbnormal | If acctReason is more than 16 |  |
|  | actionId |  |  |
|  | cec_name |  |  |
|  | cec_type |  |  |
|  | cec_model |  |  |
|  | lpar_name |  |  |