SMF DB2 fields of IFCID 107


Name

(Filter)

Tag

CEF Name

Description

QW0107DB

(Integer)

DBID

cn1

Database ID (DBID)

QW0107DN

(EGNX)

DBName

filePath

Data base name

QW0107OB

(Integer)

PSID

cn3

Pageset OBID

QW0107T

(EGNX)

Type

fileType

Type of request expressed as a one-byte code: C for Close or O for Open

QW0107TD

(Mapped Integer)

Type

fileType

Type of request expressed as Close or Open

QW0107TN

(EGNX)

ObjName

fname

Table space name

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.

 

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

BMC AMI Datastream for Db2 7.1