SMF 101-003 DB2 Accounting
- 15 May 2024
- 6 Minutes to read
- Contributors
- Print
- DarkLight
SMF 101-003 DB2 Accounting
- Updated on 15 May 2024
- 6 Minutes to read
- Contributors
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
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 |
| |
| 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 |