SMF DB2 Fields of IFCID 143 and 144

Note

These field names are all common to IFCID 143 and 144.

Name
 (Filter)

Tag
 CEF Name

Description

QW0143DB
 (Integer)

DBID
 cn1

Database ID (DBID)

QW0143OB
 (Integer)

OBID
 cn2

Record OBID

QW0143PS
 (Integer)

PSID
 cn3

Pageset OBID

QW0143SI
 (Integer)

StmtID

Statement ID or Zero

QW0143UR

RecID

Unit of recovery ID (log RBA or zeros)

Many of these descriptions are taken from one of the following sources:
DB2 Version 9.1 for z/OS Performance Monitoring and Tuning Guide © Copyright 1982, 2009 IBM Corporation; DB2 10 for z/OS SQL Reference © Copyright 1982, 2011 IBM Corporation; the IBM macro DSNA10.ADSNMACS(DSNDQWSP) © Copyright 1982, 2010 IBM Corporation; or z/OS Security Server RACF Data Areas © Copyright 1994, 2008 IBM Corporation.

Related topic

SMF-DB2-fields

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*